Have an account?
Skip to Content
Build your own quiz
18 questions
Show Answers
See Preview
- 1. Multiple Choice
You use a(n) ____ to automate data analyses.
data table
formula checker
amortization schedule
IF function
- 2. Multiple Choice
A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.
dialog box
amortization schedule
formula checker
data table
- 3. Multiple Choice
____ ensures that users do not change values inadvertently that are critical to the worksheet.
cell protection
range finder
the formula checker
data table
- 4. Multiple Choice
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
the range finder
the formula checker
a data table
an amortization schedule
- 5. Multiple Choice
You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.
ALT
CTRL
TAB
SHIFT
- 6. Multiple Choice
A cell ____ often is created from column or row titles.
function
name
formula
data table
- 7. Multiple Choice
Which of the following is the path to the Name Manager button?
(FORMULAS tab | Function Library group)
(FORMULAS tab | Defined Names group)
(FORMULAS tab | Names group)
(FORMULAS tab | Calculation group)
- 8. Multiple Choice
Names are ____ cell references.
absolute
mixed
relative
formatted
- 9. Multiple Choice
Which of the following is the path to the Financial button and the PMT function?
(FORMULAS tab | Function Library group)
(HOME tab | Formulas group)
(FORMULAS tab | Defined Names group)
(DATA tab | Function Library group)
- 10. Multiple Choice
With a(n) ____ data table you can vary the value in one cell.
one-input
two-input
three-input
unlimited-input
- 11. Multiple Choice
Data tables must be built in a(n) ____ area of a worksheet
used
unused
upper-left
lower-right
- 12. Multiple Choice
Which of the following is the maximum number of active data tables per worksheet?
5
20
50
As many as you want
- 13. Multiple Choice
You can delete a data table by selecting the data table and then ____.
clicking the Delete command in the Clipboard group on the Home tab
pressing the DELETE key
clicking the DELETE DATA TABLE command on a shortcut menu
pressing the OVERTYPE key
- 14. Multiple Choice
The ____ function returns the present value of an annuity.
FV
PMT
PV
VDB
- 15. Multiple Choice
You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.
Paste Options
Insert Comment
Format Cells
Filter
- 16. Multiple Choice
Cell ____ can be used to distinguish the different functional parts of a worksheet.
ranges
values
indices
borders
- 17. Multiple Choice
You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.
Margins
Header/Footer
Page
Sheet
- 18. Multiple Choice
You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.
Page
Sheet
Margins
Header/Footer
- Answer choicesTagsAnswer choicesTags