WorksheetsExcel Chapter 2 Test Review
Total questions: 26
Worksheet time: 13mins
Name
Class
Date
1.
Name:
4 lines
2.
1. When writing your own formulas, you must begin each formula with
a)
a quotation mark (").
b)
an equals sign (=).
c)
a colon (:).
d)
an asterisk (*).
3.
2. Indicate what the following formula will do: =B2/C2.
a)
It will multiply the contents of cell B2 by the contents of cell C2.
b)
It will display the text “B2/C2” in the active cell.
c)
It will divide the contents of cell B2 by the contents of cell C2.
d)
It will divide the contents of cell C2 by the contents of cell B2.
4.
3. After typing a formula into a cell, you can finish by pressing any of the following keys except
a)
Shift + Tab.
b)
Tab.
c)
Enter
d)
Spacebar
5.
4. Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab.
a)
Formula Auditing; Formulas
b)
Cells; Home
c)
Calculation; Formulas
d)
Editing; Home
6.
5. The Cell Address is also known as the ?
a)
Cell Indicator
b)
Name Box
c)
Cell Range
d)
Cell Reference
e)
7.
6. If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to cell D3?
a)
The formula will change to =SUM(A3:C3).
b)
The formula will change to =SUM(B3:D3).
c)
The formula will change to =SUM(B2:D2).
d)
The formula will not change.
8.
7. To copy data or formulas using the fill handle, first position the mouse pointer on the desired fill handle until it turns into a
a)
pointing hand.
b)
thin black cross
c)
double-headed arrow point left and right
d)
clipboard icon
9.
8. When creating a formula by pointing to cell references instead of typing them, what happens to the cell to which you are pointing?
a)
The cell is shaded yellow.
b)
A temporary moving border is placed around the cell.
c)
The cell contents are displayed in a bold font.
d)
The cell background is shaded gray and the text is dimmed.
10.
9. When writing a formula by pointing, how do you end the formula?
a)
Click in an empty cell.
b)
Double-click the active cell.
c)
Press the Esc key.
d)
Press the Enter key.
11.
10. If you want to change the order of operations in a formula, use these around the part of the formula you want to calculate first.
a)
parentheses
b)
commas
c)
question marks
d)
quotation marks
12.
11. When the Trace Error button appears, what is displayed in the upper left corner of the active cell?
a)
a yellow circle
b)
a small dark green triangle
c)
a stop sign icon
d)
an exclamation point
13.
12. A built-in formula, such as =SUM, is called a(n)
a)
argument.
b)
function.
c)
constant.
d)
operator.
14.
13. The process of calculating a formula and inserting the value in a cell is referred to as
a)
nesting.
b)
returning the result.
c)
a what-if scenario.
d)
layering.
15.
14. An Insert Function button can be found on the Formulas tab and
a)
on the Status bar.
b)
on the Formula bar.
c)
in the Name box.
d)
on the Insert tab.
16.
15. In the Insert Function dialog box, what displays in the Select a function list box?
a)
all functions
b)
an alphabetical list of functions
c)
functions that Excel thinks might be useful for the current worksheet
d)
the most recently used functions
17.
16. Clicking the down-pointing arrow at the right side of the AutoSum button and then clicking More Functions will display this dialog box.
a)
More Functions
b)
Insert Function
c)
Function Arguments
d)
Function Builder
18.
17. Excel’s functions are grouped into _____ categories.
a)
17
b)
13
c)
5
d)
9
19.
17. Which of the following is not one of the categories of functions offered by Excel?
a)
Statistical
b)
Scientific
c)
Logical
d)
Financial
20.
18. What does the MIN function return?
a)
the value in a range with the fewest number of characters
b)
the first value in a range that falls below a limit you specify
c)
the minimum value in a range
d)
the first negative number in a range
21.
19. If you have a range of cells containing employee salaries, what function would you use to return the highest value in the range?
a)
MAX
b)
CEILING
c)
MIN
d)
AVERAGE
22.
20. What will happen if you press Ctrl + ` (grave accent)?
a)
The active worksheet will be sent to the printer immediately.
b)
The worksheet will display formulas instead of results.
c)
All formulas will be recalculated.
d)
The current date and time will be inserted into the active cell.
23.
21. Display all formulas in a worksheet by clicking the Show Formulas button in the _____ group on the _____ tab.
a)
Editing; Home
b)
Formula Auditing; Formulas
c)
Number; Home
d)
Function Library; Formulas
24.
22. This function returns the current date in a date format.
a)
NOW
b)
TODAY
c)
DATE
d)
DAYS
25.
23. What does it mean for a formula to have a mixed cell reference?
a)
It has an error in the cell reference.
b)
It has a cell reference that comes from a worksheet other than the active worksheet.
c)
It has cell references that come from more than one worksheet.
d)
t has a cell reference in which one component (row or column) is relative, while the other is absolute.
26.
24. What symbol is used to indicate an absolute cell reference?
a)
exclamation point (!)
b)
pound or number sign (#)
c)
dollar sign ($)
d)
asterisk (*)
100 %
