WorksheetsModule 2 Excel Test Review
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
A ____ is a prewritten formula that is built into Excel.
a)
function
b)
feature
c)
task
d)
calculation
2.
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
a)
placement
b)
operations
c)
positioning
d)
selections
3.
Which of the following happens when you enter the formula =G15 into a cell?
a)
Excel recalculates all formulas in the worksheet
b)
Excel assigns the sum of the values in the previous 15 cells to the active cell
c)
Excel assigns the value in cell G15 to the active cell
d)
Nothing; =G15 is an invalid formula
4.
The adjusted cell references in a copied and pasted formula are called ____ cell references.
a)
related
b)
relative
c)
pasted
d)
alternative
5.
The ____ function displays the highest value in a range.
a)
MIN
b)
SUM
c)
MAX
d)
AVERAGE
6.
The ____ function determines the lowest number in a range.
a)
LOW
b)
BASE
c)
LEAST
d)
MIN
7.
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
a)
DIVSUM
b)
RANGEAVG
c)
AVERAGE
d)
MAX
8.
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
a)
Formula Finder
b)
Range Finder
c)
Calculation Finder
d)
Function Finder
9.
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell
a)
Comma style format
b)
Accounting number format
c)
Percent style format
d)
Currency style format
10.
A ____ is text and graphics that print at the top of each page.
a)
header
b)
topper
c)
margin
d)
crown
11.
The default view in Excel is called ____ view.
a)
Normal
b)
Standard
c)
Basic
d)
Values
12.
A ____ is text and graphics that print at the bottom of every page.
a)
footer
b)
toe
c)
margin
d)
stopper
13.
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
a)
40
b)
26
c)
48
d)
13
14.
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
a)
Normal
b)
Page Layout
c)
Page Break Preview
d)
Full Screen
15.
The equal sign (=) precedes a formula.
a)
true
b)
false
16.
The most common error when entering a formula is to reference the wrong cell in the formula.
a)
true
b)
false
17.
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
a)
true
b)
false
18.
The range automatically selected by Excel is always correct.
a)
true
b)
false
19.
Best fit means that the width of the column will be increased or decreased by a percentage you specify.
a)
true
b)
false
20.
As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.
a)
true
b)
false
100 %
