S3 Spreadsheets - Absolute Cell References

There are 2 types of cell reference, absolute and relative. Select the relative cell reference.

• A

• A7

• 7

• $A$7

Which formula uses an absolute cell reference?

• =A1+B2

• =A1+$B$2

• =A1*B2

• =A1/B2

Which symbol makes a cell reference absolute?

• @

• &

• #

• $

Absolute cell references should be used when possible to avoid having to make multiple updates when a key value changes.

• True

• False

Absolute cell references do not change when replicated (filled down).

• True

• False

Which of these formula will calculate 10% of an amount.

• = 10% / B3

• = B3 / 10

• = 10% * B3

• = B3 * 5%

Which key on the keyboard do we press to make a cell reference absolute?

• F2

• F4

• F6

• F8

What are the correct terms for copying a formula to a range of cells. (You may select more than one answer.)

• Fill across

• Copy and Paste

• Fill down

• Replicate

By naming a cell you no longer need to do what in a formula?

• Replicate it

• Add an absolute cell reference

• Put the = sign at the start

What do we mean by Commission?

• A sales person's basic pay

• Money earned based on the amount of sales made