Name ______Date ______
Excel 2010: Chapter 2 – Multiple Choice
Instructions: Circle the correct response.
1. To alert Excel that you are entering a formula and not text, type a(n) ______preceding the formula.
a. ampersand (&)
b. equal sign (=)
c. number sign (#)
d. asterisk (*)
2. If the following arithmetic operations all are found in a formula with no parentheses, which one is completed last?
a. +
b. *
c. /
d. ^
3. When you copy a formula with relative cell references down a row, ______.
a. the row references change in the formula
b. the column references change in the formula
c. no references are changed in the formula
d. the cell reference of the formula remains the same
4. You can select a range using the keyboard, just press the ______then use the arrow keys to select the desired range.
a. ALT key
b. F8 key
c. CTRL key
d. space bar
5. You can enter functions ______.
a. with the keyboard or mouse
b. the Sum menu
c. the Insert Function box in the formula bar
d. all of the above
6. The ______function is used to determine the lowest number in a given range.
a. LOW
b. NUM
c. SMALL
d. MIN
7. To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a ______.
a. fixed dollar sign
b. floating dollar sign
c. comma style dollar sign
d. Currency style dollar sign
8. When Excel automatically sets the width of a column based on the widest entry in the column, it is called ______.
a. custom fit
b. choice fit
c. best fit
d. close fit
9. Excel has a(n) ______you can use to check the worksheet for spelling errors.
a. error checker
b. spell checker
c. dictionary
d. autofix
10. ______is the process of finding and correcting errors in a worksheet.
a. Fixing
b. Debugging
c. Checking
d. Editing