Spreadsheet Cell References Worksheet
Practice identifying and using cell references in spreadsheets with this Grade 6 math worksheet.
Includes
CustomMultiple ChoiceFill in the BlanksShort AnswerTrue / FalseMatching
Standards
CCSS.MATH.CONTENT.6.EE.B.6
Topics
spreadsheetscell referencesmathgrade 6
8 sections · Free to use · Printable
Spreadsheet Cell References
Name:
Date:
Score:
Read each question carefully and provide your answer. For questions involving a spreadsheet, refer to the image below.
1. What is the cell reference for the cell containing the number 15?
a
B1
b
B2
c
C1
d
C2
2. The value in cell A4 is .
3. If you add the values in B1 and C2, the sum is .
4. Explain the difference between a relative cell reference and an absolute cell reference in a spreadsheet. Provide an example of each.
5. A cell reference like $A$1 is an example of a relative cell reference.
T
True
F
False
Match each cell reference with its type.
6. A1
a. Absolute Reference
7. $B$5
b. Relative Reference
8. C$3
c. Mixed Reference