Spreadsheet Cell References Worksheet
Grade 11 Math worksheet focusing on understanding and applying different types of cell references in spreadsheets (relative, absolute, mixed).
Includes
Topics
Spreadsheet Cell References
Name:
Date:
Score:
Read each question carefully and provide the best answer. This worksheet assesses your understanding of relative, absolute, and mixed cell references in spreadsheets.
1. Which type of cell reference changes when it is copied to another cell?
Absolute reference
Relative reference
Mixed reference
Circular reference
2. What symbol is used to denote an absolute cell reference?
#
@
$
%
3. A mixed cell reference has either the row or the column fixed, but not both. For example, $A5 is a mixed reference where the column is and the row is .
4. When you copy a formula that uses a relative cell reference, the reference adjusts based on the position of the formula.
5. An absolute reference locks both the row and column, so it does not change when copied.
True
False
6. The formula =A1+B1 copied from cell C1 to C2 will become =A2+B2 if both are relative references.
True
False
7. You have a formula in cell B2 that needs to always refer to cell A1, regardless of where the formula is copied. Write the cell reference for A1 that you would use in this formula.
8. Explain the difference between a relative cell reference and a mixed cell reference. Provide an example of each.
Consider the following spreadsheet snippet:
| A | B | C | ----|-----|-----|-----| 1 | 10 | 5 | | 2 | 20 | 10 | | 3 | | | |
9. If cell C1 contains the formula =A1*B1 and is copied to cell C2, what will be the formula in cell C2, and what will be its result?
Formula in C2:
Result in C2: