WorksheetsExcel 2016 Module 4 Test Review 2020
Total questions: 24
Worksheet time: 8mins
Name
Class
Date
1.
You use a(n) ____ to automate data analyses.
a)
formula checker
b)
amortization schedule
c)
IF function
d)
data table
2.
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.
a)
dialog box
b)
amortization schedule
c)
formula checker
d)
data table
3.
____ ensures that users do not change values inadvertently that are critical to the worksheet.
a)
Cell protection
b)
Range Finder
c)
The formula checker
d)
A data table
4.
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
a)
The Range Finder
b)
The formula checker
c)
A data table
d)
An amortization schedule
5.
You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.
a)
ALT
b)
CTRL
c)
TAB
d)
SHIFT
6.
With a(n) ____ data table you can vary the value in one cell.
a)
one-input
b)
two-input
c)
three-input
d)
unlimited-input
7.
Data tables must be built in a(n) ____ area of a worksheet.
a)
used
b)
unused
c)
upper-left
d)
lower-right
8.
Which of the following is the maximum number of active data tables per worksheet?
a)
5
b)
20
c)
50
d)
As many as you want
e)
Sheet
9.
The ____ function returns the present value of an annuity.
a)
FV
b)
PMT
c)
PV
d)
VDB
10.
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.
a)
Margins
b)
Header/Footer
c)
Page
d)
Sheet
11.
You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.
a)
Page
b)
Sheet
c)
Margins
d)
Header/Footer
12.
To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.
a)
ALT
b)
F3
c)
CTRL
d)
F10
13.
Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.
a)
repetitiveness
b)
brevity
c)
violations
d)
consistency
14.
When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula.
a)
blue square
b)
red circle
c)
green triangle
d)
green diamond
15.
Assigning names to a cell or range of cells allows you to select them quickly.
a)
true
b)
false
16.
Spreadsheet specialists usually format a worksheet before they enter any data.
a)
true
b)
false
17.
When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.
a)
true
b)
false
18.
The FV function returns the future value of an investment based on periodic, constant payments and a constant interest rate.
a)
true
b)
false
19.
An amortization schedule summarizes loan information over the life of the loan.
a)
true
b)
false
20.
Once you set a print area, Excel will continue to print the specified range, rather than the entire worksheet.
a)
true
b)
false
21.
Names are ____ to the workbook.
a)
national
b)
international
c)
global
d)
inclusive
22.
To hide an entire workbook on an unattended computer, click the Hide button on the ____.
a)
(HOME tab | View group)
b)
(VIEW tab | Workbook Views group)
c)
(VIEW tab | Window group)
d)
(HOME tab | Display group)
23.
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.
a)
locked
b)
indexed
c)
unprotected
d)
hybrid
24.
You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.
a)
Paste Options
b)
Insert Comment
c)
Format Cells
d)
Filter
100 %
