Excel 2013 Unit B

An Excel complex formula uses more than one arithmetic operator.

• True

• False

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).

• True

• False

=D8+E8*0.5 is a complex formula.

• True

• False

Clicking the Minimize button minimizes the Function Arguments dialog box so you can select cells in a worksheet.

• True

• False

In this formula, =(A6*A8)+$D$1, the cell references A6 and A8 are relative cell references.

• True

• False

A mixed reference means that either the column or row reference in the formula is absolute, but not both.

• True

• False

Which of the following is a complex formula?

• =SUM(B4:B8)

• =(B4/B8)*10

• =AVERAGE(C6:D6)

• =MIN(D5:D7)

All functions begin with the formula prefix ____.

• @ (at symbol)

• = (equals sign)

• # (number symbol)

• + (plus sign)

In Excel, MAX and AVERAGE are examples of ____.

• functions

• arguments

• lists

• buttons

Which method of entering a function requires the user to know the name and initial characters of a function?

• manually typing the function

• using the Insert Function button

• using the Sum button

• using the Sum list arrow