Excel HR 2019 Module 5 Review # 1

Which of the following refers to an unnamed range in the current worksheet?

• =Q3Expenses!A19

• =SUM(C2:E12)

• =SUM(budget.summary)

Which function adds up the values in a selected range and then divides that total by the number of nonblank cells in the range?

• MAX

• MIN

• MEDIAN

• AVERAGE

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

• MAX

• MIN

• COUNTA

• SUM

Once you name a range, you can change the size of the range using the Name Manager.

• True

• False

Which of the following is an example of a cell range?

• A9:E9

• A$9

• A9

Per the order of operations, which of the following is calculated first?

• Exponentiation ( ˆ )

• Subtraction (-)

• Addition (+) and subtraction (−) (left to right)

• Parentheses ()

Which of the following is not an arithmetic operator?

• *

• B) ]

• -

• +

Which of the following is an example of a relative cell reference?

• A) A9

• B) A$9

• C) $A9

• D) 9A

Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification.

• True

• False

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

• subtotal_west

• subtotal/west

• subtotal west

• C7