1. Which of the following is an example of qualitative data?

a Major

b Age

c Grade percentage

2. What is the purpose of creating an absolute reference to a cell in a formula?

a. To ensure that the formula refers to the next consecutive cell value depending on how the formula is copied

b. To ensure that the value in the referenced cell can never be changed

c. To ensure when your formula is copied that the value in the same exact cell is used for each copied formula

3.Can you use a mixture of absolute and relative references in a single formula?

a. Yes

b. No

c. Yes, but only if you refer to cells in a single row

4. If you wanted to lock your reference to cell C7 in a formula and copy that formula down a column, what should it look like?

a. C7

b. $C7

c. C$7

5. If you wanted to lock your reference to cell C7 in a formula and copy that formula across a row, what should it look like?

a. C7

b. $C7

c. C$7