S3 Spreadsheets - Absolute Cell References

Front

Select the relative cell reference from the following options: A, A7, 7, $A$7.

Back

A7

Front

Which formula uses an absolute cell reference? Options: =A1+B2, =A1+$B$2, =A1*B2, =A1/B2

Back

=A1+$B$2

Front

Which symbol makes a cell reference absolute? Options: @, &, #, $

Back

$

Front

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

Back

True

Front

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

Back

True

Front

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

Back

F4

Front

A type to cell reference that does not change when copied or filled is called

Back

Absolute cell reference

Front

A cell reference that changes when copied is called

Back

Relative cell reference

Front

You can use an _________________ to keep a row and/or column constant.

Back

Absolute cell reference

Front

To use multiple worksheets as possible cell reference may state ________________.

Back

Sheet1!A1