Excel Functions & Formulas Review

1. Which of the following is not an arithmetic operator?

• +

• -

• *

• ]

Which of the following is an acceptable name for a named range?

• C7

• subtotal_west

• subtotal west

• subtotal/west

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

• A9

• A$9

• $A$9

• A9:E9

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

• A9

• A$9

• $A$9

• A9:E9

To allow Excel to distinguish formulas from data, all formulas must begin with

• +

• cell reference

• function name

• =

You can create a new range by selecting the cells and typing a name in the Name Box next to the formula bar.

• True

• False

The order of operations determines which parts of a formula are calculated before other parts of the formula.

• True

• False

The formula = 6 * 2 / 3 produces the same result as = 6 * (2 / 3).

• True

• False

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

• AVERAGE

• AutoSum

• COUNT

• MAX

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

• MIN

• AVERAGE

• COUNT

• MAX