Recall
Set 1: Quick Check
Predict how relative references move and recognize relative, absolute, and mixed references.
Cell References
Cell References and Copying Formulas
Build practical skills in cell references.
Start Chapter PracticeChapter plan
What you will be able to do
- Apply cell references concepts in realistic spreadsheet work.
- Study time
- 24–28 minutes, self-paced
- Course
- Excel for Work (Beginner)
- Practice order
- Four sets, completed in sequence
Chapter practice
Practice in chapter order
10 activities · 80% mastery target
Start set 1
Guided application
Set 2: Core Practice
Use safe copying practices, lock shared assumptions, and anchor references deliberately.
Hands-on
Set 3: Workplace Task
Copy a sales formula down a worksheet while preserving the intended row references.
Independent check
Set 4: Mastery Check
Audit a copied formula column, predict mixed-reference behavior, and explain each dollar sign.