Statistical =AVERAGE(number1, [number2], ...)

Quiz =AVERAGE — 15 Questions

15 quiz questions about =AVERAGE — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← AVERAGE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which is the correct syntax of =AVERAGE?

Question 2 of 15 2/15

In =AVERAGE, which is argument #1?

Question 3 of 15 3/15

Does =AVERAGE return a dynamic array?

Question 4 of 15 4/15

Which function is NOT related to =AVERAGE?

Question 5 of 15 5/15

Which statement about =AVERAGE is correct?

Question 6 of 15 6/15

Which formula is a valid example of =AVERAGE?

Question 7 of 15 7/15

Which use case fits =AVERAGE?

Question 8 of 15 8/15

Is argument “number2” required in =AVERAGE?

Question 9 of 15 9/15

Is =AVERAGE volatile?

Question 10 of 15 10/15

Which function is related to =AVERAGE?

Question 11 of 15 11/15

Since which Excel version is =AVERAGE available?

Question 12 of 15 12/15

Is argument “number1” required in =AVERAGE?

Question 13 of 15 13/15

Which category does =AVERAGE belong to?

Question 14 of 15 14/15

What is the type of argument “number1” in =AVERAGE?

Question 15 of 15 15/15

What is the type of argument “number2” in =AVERAGE?

Click a question to see the answer.

1. Which is the correct syntax of =AVERAGE?

A. =AVERAGE(number1, [number2], ...) ✓
B. =AVERAGE(number1, [number2], ..., 0)
C. AVERAGE(number1, [number2], ...)
D. =STDEV-S(number1, [number2], ...)

Explanation: Correct syntax: =AVERAGE(number1, [number2], ...)

2. In =AVERAGE, which is argument #1?

A. range
B. criteria
C. number2
D. number1 ✓

Explanation: Argument #1 is “number1”.

3. Does =AVERAGE return a dynamic array?

A. No ✓
B. No
C. —
D. Yes

Explanation: AVERAGE does not spill.

4. Which function is NOT related to =AVERAGE?

A. AVERAGEIF
B. AVERAGEA
C. STDEV-S
D. EVEN ✓

Explanation: “EVEN” is not related to AVERAGE.

5. Which statement about =AVERAGE is correct?

A. Requires add-in
B. To locate the Show a zero in cells that have a zero value check box:
C. When you average cells, keep in mind the difference between empty cells and those containing the value zero, especially if you have cleared the Show a zero in cells that have a zero value check box in the Excel Options dialog box in the Excel desktop application. When this option is selected, empty cells are not counted, but zero values are. ✓
D. If a range or cell reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

Explanation: Correct: When you average cells, keep in mind the difference between empty cells and those containing the value zero, especially if you have cleared the Show a zero in cells that have a zero value check box in the Excel Options dialog box in the Excel desktop application. When this option is selected, empty cells are not counted, but zero values are.

6. Which formula is a valid example of =AVERAGE?

A. AVERAGE(A2:A6)
B. =AVERAGE(A2:A6, 0)
C. =STDEV-S(A2:A6)
D. =AVERAGE(A2:A6) ✓

Explanation: Correct example: =AVERAGE(A2:A6)

7. Which use case fits =AVERAGE?

A. Daily Tasks ✓
B. Forecasting & Trends
C. Conditional Aggregation
D. Rounding & Numeric

Explanation: Use case “Daily Tasks” fits AVERAGE.

8. Is argument “number2” required in =AVERAGE?

A. No ✓
B. No
C. Yes
D. —

Explanation: “number2” is optional.

9. Is =AVERAGE volatile?

A. Yes
B. No
C. No ✓
D. —

Explanation: AVERAGE is not volatile.

10. Which function is related to =AVERAGE?

A. CHOOSECOLS
B. HEX2DEC
C. ISERROR
D. STDEV-S ✓

Explanation: “STDEV-S” is related to AVERAGE.

11. Since which Excel version is =AVERAGE available?

A. Excel 2007 (Compatibility)
B. All versions ✓
C. Excel 2019
D. Excel 365

Explanation: Version: “All versions”.

12. Is argument “number1” required in =AVERAGE?

A. Yes ✓
B. Yes
C. —
D. No

Explanation: “number1” is required.

13. Which category does =AVERAGE belong to?

A. Statistical ✓
B. Compatibility
C. Engineering
D. Math & Trig

Explanation: Category is “Statistical”.

14. What is the type of argument “number1” in =AVERAGE?

A. Any type ✓
B. Logical
C. Date
D. Reference

Explanation: Type of “number1” is “Any type”.

15. What is the type of argument “number2” in =AVERAGE?

A. Date
B. Any type ✓
C. Number
D. Mixed

Explanation: Type of “number2” is “Any type”.