Learn: Cell Referencing (Relative/Absolute/Named/Multi-Sheet)
Cambridge Nationals IT Level 1/Level 2
Ready to start this lesson?
Sign in to track your progress. 13 steps including 6 interactive questions.
Sign In to Start Learning
Students also studied
Browse allSteps in this lesson (13)
Match the items on the left with their correct pairs on the right
Match the items on the left with their correct pairs on the right
What does cell referencing allow you to do in a spreadsheet?
Start the lesson to answer this multiple choice question
Match the items on the left with their correct pairs on the right
Relative cell referencing automatically adjusts when a formula is {{blank0}} to a new location.
Start the lesson to answer this fill in the blank question
Match the items on the left with their correct pairs on the right
Which cell reference is an example of absolute referencing?
Start the lesson to answer this multiple choice question
Match the items on the left with their correct pairs on the right
Named cell referencing assigns a {{blank0}} to a cell or range for use in {{blank1}}.
Start the lesson to answer this fill in the blank question
Match the items on the left with their correct pairs on the right
Match the items on the left with their correct pairs on the right
Start the lesson to answer this matching question
Match the items on the left with their correct pairs on the right
Which of the following are true about cell referencing? (Select all that apply)
Start the lesson to answer this multi-select question
Want to Learn More?
Get personalised lessons, quizzes, and instant feedback from your AI tutor.
Explore More Topics