Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/5
Score 0
In a spreadsheet, if you want a cell reference to stay exactly the same and not change when you copy the formula to a new location, which type of reference should you use?
30
Absolute Reference
Manual Reference
Dynamic Reference
Relative Reference
Q 2/5
Score 0
Which of the following describes a Relative Reference in a spreadsheet formula?
30
It always uses dollar signs to lock the cell address.
It is the default setting and changes based on the position where the formula is copied.
It keeps the exact same value regardless of where you move it.
It is a formula that must be typed manually into every single cell.
5 questions
Q.
In a spreadsheet, if you want a cell reference to stay exactly the same and not change when you copy the formula to a new location, which type of reference should you use?
1
30 sec
Q.
Which of the following describes a Relative Reference in a spreadsheet formula?
2
30 sec
Q.
3
30 sec
Q.
Which of the following describes the main difference between a Relative Reference and an Absolute Reference when copying a formula?
4
30 sec
Q.
Which symbol is used in a spreadsheet to create an Absolute Reference, ensuring a cell address does not change when the formula is moved?
