excel absolute reference

By default, all cell references are _________ references. 

• Absolute
• Relative

Which of the following is an example of an absolute cell reference?

• A9

• A$9

• $A$9

• A9:E9

It is always best to use the exact value instead of the cell reference when using formulas.

• TRUE

• FALSE

You can press the F4 key to add the $'s to an absolute reference.

• TRUE

• FALSE

Unlike _________ references, _________ references do not change when copied or filled. 

• Absolute, Relative
• Relative, Absolute

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.

• relative
• relational

A_________ is a built in mathematical formula included in excel.

• Function
• Cell
• Formula

Which of the following is a relative cell reference?

• P72
• G$9
• $K356

When number signs (#####) are displayed in the cell, it means: 

• The formula in the cell is wrong
• There are too many characters in the cell to be displayed with the current cell width
• The decimal point placement in the cell is wrong

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

• Absolute
• relative