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