1. (TCO 5) In the formula =SUM(C:Reports[Budget.xlsx]Annual!(C10:C25), what does the Annual! portion refer to? 
A named cell range 
A workbook 
A drive path 
A worksheet 

2. (TCO 5) The best way of documenting a workbook is considered to be: 
using the Review tab to document all pertinent data about a workbook 
using the Excel Options to document all pertinent data about a workbook. 
creating a documentation worksheet that describes the content of each worksheet within the workbook. 
creating a note at the bottom of each sheet about the author's name and date of creation. 

3. (TCO 5) The Data Validation dialog box is accessed from the ___________ group on the Data tab of the Ribbon. 
Get External Data 
Data Tools 
Sort & Filter 
Connections 

4. (TCO 5) By selecting an option from the Data Validation down arrow list, you can have Excel mark each cell containing invalid data on a worksheet by __________. 
drawing a circle around the cell 
displaying the cell contents in red 
making the cell blink 
displaying the cell contents in italics 


5. (TCO 5) A value that can be changed, such as possible down payment amounts for a car, in order to see how the change impacts other values, can be defined as a(n): 
constant. 
variable. 
target. 
result. 


6. (TCO 5) You want to create a one-variable data table to show the effects of different interest rates, such as 6.0%, 6.5%, 7.0%, etc., on the monthly payment amount for a loan. The different interest rates ou want to try (i.e., 6.0%, 6.5%, 7.0%, . . . ) will be entered in the _______ of the data table. 
input cells 
constraints 
result cells 
target cells 


7. (TCO 5) In a two-variable data table, the top-left cell is often reformatted using a _____ to display a text title. 
conditional format 
custom number format 
special font 
user-defined style 


8. (TCO 5) When creating a two-variable data table, the cell that contains the original value for the vertical variable (whose different values go from top to bottom) is entered in the ______ box in the Data Table dialog. 
Row Input Cell 
Column Input Cell 
Result Cell 
Target Cell 

9. (TCO 6) Which of the following starts with a desired end result and computes the unknown input value that will produce that result? 
Scenario Manager 
Goal Seek 
One-variable data table 
Two-variable data table 


10. (TCO 6) After you have created multiple scenarios using the same variables in the Scenario Manager, you can generate a ___________ that compares the results. 
Data Consolidation Sheet 
Scenario Summary Report 
Scenario Assessment Page 
Scenario Data Table 


11. (TCO 6) Click the ___________ tab to begin the process in creating a scenario summary report. 
Home 
Insert 
Data 
Developer 


12. (TCO 6) Solver allows you to specify a goal, identify variables (changing values), and ______ (restrictions, such as the maximum amount you can spend). 
scenarios 
adjustable cells 
constraints 
resources