Spreadsheet Cell References Worksheet
Grade 7 Math worksheet focusing on understanding and using spreadsheet cell references, including relative, absolute, and mixed references.
Includes
Standards
Topics
Spreadsheet Cell References
Name:
Date:
Score:
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?
A1
$A$1
A$1
$A1
2. When a formula containing a relative cell reference is copied to another cell, what happens to the reference?
It remains unchanged.
It adjusts based on the new cell's position.
It becomes an absolute reference.
It causes an error.
1. A cell reference that changes when it is copied to a new location is called a reference.
2. To make a column reference absolute in a spreadsheet, you would add a dollar sign before the .
3. A mixed cell reference has one part (either the row or the column) that is and the other part is relative.
1. An absolute cell reference always refers to the same cell, regardless of where the formula is copied.
True
False
2. The formula =A1+B1 is an example of using mixed cell references.
True
False
1. Explain the difference between a relative cell reference and an absolute cell reference.
2. Describe a scenario where using a mixed cell reference ($A1 or A$1) would be beneficial in a spreadsheet.
Consider the following simple spreadsheet:
A
B
C
1
Item
Quantity
Price
2
Pen
5
2.00
3
Book
2
10.00
If you wanted to calculate the total cost (Quantity * Price) for the Pen in cell D2, what formula would you enter in cell D2 using relative cell references?
If you then copied that formula from D2 to D3, what would the formula in D3 be, and what would be its result?