Spreadsheet Cell References Worksheet

Spreadsheet Cell References

Read each question carefully and provide the best answer. This worksheet will test your knowledge of spreadsheet cell references.

1. Which of the following is an example of an absolute cell reference?

2. When copying a formula from cell B2 to B3, if the original formula was '=A1', what will the formula in B3 be?

3. A cell reference that changes when it is copied to another cell is called a   cell reference.

4. To make a cell reference absolute, you use the   symbol before the column letter and row number.

5. A   cell reference has either the row or the column fixed, but not both.

6. Explain the difference between a relative cell reference and an absolute cell reference. Provide an example of each.

7. If you copy a formula that contains '$C$5' to a different cell, the reference to C5 will change.

8. A mixed cell reference is used when you want only the column to change, but not the row, or vice-versa, when copying a formula.

9. You have a spreadsheet where cell A1 contains a value, and you want to multiply this value by a series of numbers in column B (B1, B2, B3, etc.). You want to write a formula in cell C1 and drag it down to C2, C3, etc., such that A1 remains constant in the multiplication, but the reference to column B changes. What formula would you use in C1?