Excel Reverences Revision

By default, all cell references are _________ references.

• Absolute

• Relative

_________ references do not change when copied or filled.

• Absolute

• Relative

An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.

• %

• #

• &

• $

In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.

• Absolute

• Relative

If you don't want a cell reference to change when copied to other cells, use _________ references

• Absolute

• Relative

If you want a cell reference to change when copied to other cells, use _________ references

• Absolute

• Relative

The most common way to identify a cell reference is

• $D2

• $D$2

• D$2

• D2$

In mixed references If the $ is on the left of the letter it means you lock---------

• the column

• the row

=$B4*C$3 is -------------reference

• Relative

• Mixed

• Absolute

Absolute references can be made absolute by hitting the ------------- while your cursor is on that cell reference.

• F4 key

• F2 key

• Fn key