Introduction to Microsoft Excel

By default, all cell references are _________ references. 

• Absolute
• Relative

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

• Absolute
• relative

What does the Average formula return?

• Returns the lowest argument.

• Returns the middle argument.

• Returns the three highest arguments.

• Returns the mean of all its arguments.

In the picture, why is D2 through D5 placed in paranthesis?

• So Excel knows to total the cells before performing the next operation.
• So the total of the cells can be multiplied rather than added.

By default, all cell references are _________ references. 

• Absolute
• Relative

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

What does the Average formula return?

• Returns the lowest argument.

• Returns the middle argument.

• Returns the three highest arguments.

• Returns the mean of all its arguments.

Which operator is used to multiply in Excel?

• +

• -

• /

• *

All formulas begin with a(n) _______________.

• &

• =

• +

• #

Excel will display _______________________ if the cell is not wide enough.

• ******

• ^^^^^

• ######

• >>>>>