NEW
Font size
S
M
L
XL
WorksheetsExcel Module 3 Review #2
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
Which of the following is the path to the Zoom button?
a)
(VIEW tab | Zoom group)
b)
(HOME tab | Zoom group)
c)
(INSERT tab | Zoom group)
d)
(ZOOM tab | View group)
2.
Charts can either be embedded in a worksheet or placed in a separate ____.
a)
worksheet
b)
dialog box
c)
chart sheet
d)
range
3.
Which comparison operator means “not equal to”?
a)
<=
b)
>
c)
<
d)
<>
4.
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____values.
a)
logical
b)
constant
c)
consistent
d)
calculated
5.
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
a)
Quarter 1
b)
Qtr1
c)
Qtr2
d)
Quarter4
6.
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer’s memory.
a)
Ribbon
b)
Clipboard
c)
Folder
d)
File
7.
If you enter 90 in the Degrees box in the _____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.
a)
Position
b)
Orientation
c)
Slope
d)
Incline
8.
_____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
a)
Click
b)
Press or long-press
c)
Double-click
d)
Triple-click
9.
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
a)
two
b)
three
c)
four
d)
five
10.
When working with a large worksheet, you can split the window into ____ panes.
a)
three or four
b)
four or five
c)
two or six
d)
two or four
11.
When the Paste Options button is visible, you can use ____________________ to access the paste commands available in the Paste Options gallery.
a)
keyboard shortcuts
b)
mini toolbar
c)
Ribbon
d)
Home tab
12.
A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.
a)
Fixed
b)
IF Function
c)
absolute
d)
assumptions
13.
The ____________________ function is useful when you want to assign a value to a cell based on a logical test.
a)
NOW
b)
IF
c)
FX
d)
=
14.
____________________ are values in cells that can be changed to determine new values for formulas.
a)
Absolute
b)
Fixed
c)
Nested IF
d)
Assumptions
15.
The ____________________ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area.
a)
Fill Months
b)
Fill Series
c)
Fill Formatting Only
d)
Fill Without Formatting
Reset
