45 points Multiple Choice: Choose the answer that best fits each statement below.

5. Which of the following can be found by clicking the AutoSum drop‐down?
a. Average
b. Min
c. Sum
d. All of the above

6. Which option is used to prevent a cell reference from changing when a formula is copied to
another location?
a. Named ranges
b. Absolute cell reference

7. An advantage to defining range names is:
a. Selections can be larger
b. Selections can be any format
c. Name ranges are easy to remember
d. Name ranges clear cell contents

True/False: Answer True or False for each statement below.
8. You can only increase or decrease the decimal places by two.
9. The comma style allows you to format with a thousands separator.
10. Excel does not allow you to copy and paste formulas with AutoFill.