Spreadsheet Cell References Worksheet
Grade 10 math worksheet on understanding and applying spreadsheet cell references (relative, absolute, mixed).
Includes
Standards
Topics
Spreadsheet Cell References
Name:
Date:
Score:
Read each question carefully and provide the best answer based on your knowledge of spreadsheet cell references. Show your work where applicable.
1. Which of the following is an example of an absolute cell reference?
A1
$A1
A$1
$A$1
2. If the formula =B2+C2 is copied from cell D2 to cell D3, what will the formula in D3 be?
=B2+C2
=B3+C3
=$B$2+$C$2
=B$2+C$2
3. A cell reference that changes when it is copied to a new location is called a reference.
4. To make a row reference absolute, you would place a dollar sign before the .
5. A mixed cell reference has either the or the absolute, but not both.
6. An absolute cell reference will always refer to the same cell, regardless of where the formula is copied.
True
False
7. If you copy the formula =A1*B1 from cell C1 to cell C2, the formula in C2 will be =A2*B2.
True
False
8. Explain the difference between a relative cell reference and an absolute cell reference. Provide an example of when you would use each.
9. You have a spreadsheet with sales data. Cell B1 contains the sales tax rate (e.g., 0.08). You want to calculate the sales tax for each item in column A, starting from A2. Write a formula for cell B2 that can be copied down the column correctly.
Consider the following spreadsheet snippet:
| A | B | C
--|-----|-----|----
1 | 10 | 5 | =A1*B1
2 | 20 | 3 |
3 | 15 | 8 |
10. If the formula from cell C1 is copied to cell C2, what value will be displayed in cell C2?
11. If the formula in cell C1 was =$A$1*B1 and it was copied to cell C2, what value would be displayed in cell C2?