1. (TCO 5) In the formula =SUM(C:Reports[Budget.xlsx]Annual!(C10:C25), what does the Annual! portion refer to? (Points: 2)
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: (Points: 2)
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. (Points: 2)
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 __________. (Points: 2)
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): (Points: 2)
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. (Points: 2)
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. (Points: 2)
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. (Points: 2)
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? (Points: 2)
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. (Points: 2)
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. (Points: 2)
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). (Points: 2)
scenarios
adjustable cells
constraints
resources