Questions and Answers
How do you create a worksheet group consisting of sheets that are not adjacent in a workbook?
Select the first sheet tab, hold down the Ctrl key, and then click on the tabs of the other sheets you want to include.
Can a worksheet have only one window?
False
How do you ungroup a worksheet group that consists of all the sheets in the workbook?
Click the sheet tab of any worksheet in the group.
What is the 3-D cell reference to cell C20 in the Monday worksheet?
Signup and view all the answers
What is the absolute 3-D cell reference to cell C20 in the Monday worksheet?
Signup and view all the answers
What is the 3-D cell reference to cell C20 in the Monday through Friday worksheet group?
Signup and view all the answers
Write a formula that uses the MAX function to calculate the maximum value of cell C20 of the Monday through Friday worksheet group.
Signup and view all the answers
What is the external reference to cell C20 of the Final Report worksheet located in the Annual Statement.xlsx workbook?
Signup and view all the answers
What is the external reference to cell D10 of the Sunday worksheet located in the Weekly Report.xlsx workbook that is stored in the C:\Documents\Reports folder?
Signup and view all the answers
When would you paste a copied cell using the Paste Link option?
Signup and view all the answers
How do you check the status of a link within the current workbook to determine whether the link's source file is accessible and up-to-date?
Signup and view all the answers
How does Excel indicate that a cell contains linked text?
Signup and view all the answers
What does Excel do when a hyperlink is clicked by the user?
Signup and view all the answers
Why is Report-Date not a valid names range?
Signup and view all the answers
What happens when you select a defined name in the Name box?
Signup and view all the answers
What is displayed in the title bar for a workbook created from the EmployeeList.xltx template file?
Signup and view all the answers
Describe the difference between a variable and a fixed expense.
Signup and view all the answers
When does the break-even point occur?
Signup and view all the answers
What is a data table? What is an input cell? What is a result cell?
Signup and view all the answers
What is a one-variable data table? What is a two-variable data table?
Signup and view all the answers
How many result cells can you display with a one-variable data table? How many result cells can you display with a two-variable data table?
Signup and view all the answers
Cell E5 contains the formula =B10. You want to display the text 'Profits' instead of the formula's value. What custom format would you use?
Signup and view all the answers
What is an array formula?
Signup and view all the answers
What is the one advantage of scenarios over data tables?
Signup and view all the answers
Study Notes
Worksheet Management and References
- Create a worksheet group of non-adjacent sheets by holding down Ctrl and clicking sheet tabs.
- Multiple workbook windows can be opened for a single worksheet.
- To ungroup all sheets in a workbook, click on any sheet tab within the group.
- 3-D cell reference for cell C20 in the "Monday" worksheet is written as Monday!C20.
- Absolute 3-D cell reference for cell C20 in "Monday" is expressed as Monday!$C$20.
- 3-D cell reference for C20 in the "Monday through Friday" group is formatted as Monday:Friday!C20.
Formulas and External References
- Use the formula
=MAX(Monday:Friday!C20)
to find the maximum value of cell C20 across the specified worksheets. - External reference to cell C20 in the "Final Report" worksheet of the "Annual Statement.xlsx" workbook is '[Annual Report.xlsx]Final Report'!C20.
- Reference cell D10 in the "Sunday" worksheet from "Weekly Report.xlsx" located in C:\Documents\Reports as '[C:\Documents\Reports\Weekly Report.xlsx]Sunday'!D10.
Pasting and Links
- Use the Paste Link option when needing to reference a cell rather than copying its value or format.
- Verify link status and accessibility through the Data tab by checking the Edit Links dialog box.
- Linked text in a cell appears green and underlined in Excel.
- Clicking a hyperlink launches the associated application for that link type.
Naming and Defined Names
- "Report-Date" is an invalid named range due to the inclusion of a dash.
- Selecting a defined name in the Name box highlights the respective cell or range it refers to.
- A workbook created from the "EmployeeList.xltx" template displays "EmployeeList1" in the title bar.
Financial Concepts
- Variable expenses fluctuate with production; fixed expenses remain the same regardless of production volume.
- The break-even point is reached when total revenue equals total expenses.
Data Tables and Scenarios
- A data table presents results from various what-if analyses, with input cells containing values to change during analysis.
- One-variable data tables involve a single row or column of input values and multiple results, while two-variable data tables have two inputs and only one result.
- There is no limit to the number of result cells in a one-variable data table; a two-variable data table yields one result cell.
Custom Formatting and Array Formulas
- To display the text "Profits" in cell E5 containing the formula =B10, use the custom format "Profits".
- An array formula processes a set of values, returning either a single value or an array of values.
- Scenarios allow for more complex what-if analyses compared to data tables.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge with these flashcards covering key concepts from Software Module 5 and 8. This quiz includes questions about worksheet groups, workbook windows, and more, designed to help you prepare for your final assessment. Enhance your understanding of essential software skills.