Excel Intermediate

Which response best completes the following statement: A formula is used to 

• perform calculations or other actions.
• find averages.

Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.

• True
• False

Excel follows the ___________________ and first adds the values inside the parentheses.

• Order of Operations
• Formula Guidelines

By default, all cell references are _________ references. 

• Absolute
• Relative

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

• Absolute, Relative
• Relative, Absolute

An absolute reference is designated in a formula by the addition of a _______ sign. 

• %
• $
• &
• #

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) _______________.

• &

• =

• +

• #

Formulas can be copied to adjacent cells with the ____________.

• Fill handle

• PgDn Key

• Function key F4

• None of the above