Quiz

Quiz: Cell Referencing (Relative, Absolute, Named, Multi-Sheet)

Cambridge Nationals IT Level 1/Level 2

10 Steps8 Questions

Students also studied

Text

Building on what you've learned about formulae and operators, let's test your knowledge of cell referencing!

Multiple ChoiceInteractive

Which type of cell reference changes when copied to another cell?

Start the lesson to answer this multiple choice question

Multi-SelectInteractive

Which of the following are examples of absolute cell references? (Select all that apply)

Start the lesson to answer this multi-select question

Fill in the BlankInteractive

A {{blank0}} cell reference remains fixed when copied, while a {{blank1}} cell reference changes.

Start the lesson to answer this fill in the blank question

MatchingInteractive

Match the items on the left with their correct pairs on the right

Start the lesson to answer this matching question

Multiple ChoiceInteractive

What symbol is used in an absolute reference to lock a row or column?

Start the lesson to answer this multiple choice question

typedAnswer

Match the items on the left with their correct pairs on the right

Multi-SelectInteractive

Which of the following cell references can be used for multi-sheet referencing? (Select all that apply)

Start the lesson to answer this multi-select question

Fill in the BlankInteractive

A {{blank0}} reference uses a name like 'Sales' instead of a cell address, improving {{blank1}}.

Start the lesson to answer this fill in the blank question

Multiple ChoiceInteractive

What would be the result of copying formula =Sheet1!A1 from one sheet to another?

Start the lesson to answer this multiple choice question

Get personalised lessons, quizzes, and instant feedback from your AI tutor.