Statistical =AVERAGEA(value1, [value2], ...)

Quiz =AVERAGEA — 15 Questions

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

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

← AVERAGEA ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Does =AVERAGEA return a dynamic array?

Question 2 of 15 2/15

How many optional arguments does =AVERAGEA have?

Question 3 of 15 3/15

Which function is NOT related to =AVERAGEA?

Question 4 of 15 4/15

Which category does =AVERAGEA belong to?

Question 5 of 15 5/15

How many required arguments does =AVERAGEA have?

Question 6 of 15 6/15

Is argument “value1” required in =AVERAGEA?

Question 7 of 15 7/15

Which formula is a valid example of =AVERAGEA?

Question 8 of 15 8/15

Since which Excel version is =AVERAGEA available?

Question 9 of 15 9/15

In =AVERAGEA, which is argument #1?

Question 10 of 15 10/15

What is the type of argument “value1” in =AVERAGEA?

Question 11 of 15 11/15

Which statement about =AVERAGEA is correct?

Question 12 of 15 12/15

Which is the correct syntax of =AVERAGEA?

Question 13 of 15 13/15

Is =AVERAGEA volatile?

Question 14 of 15 14/15

How many arguments does =AVERAGEA have in total?

Question 15 of 15 15/15

Which function is related to =AVERAGEA?

Click a question to see the answer.

1. Does =AVERAGEA return a dynamic array?

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

Explanation: AVERAGEA does not spill.

2. How many optional arguments does =AVERAGEA have?

A. 1
B. 0 ✓
C. —
D. 2

Explanation: =AVERAGEA has 1 required, 0 optional (1 total).

3. Which function is NOT related to =AVERAGEA?

A. AVERAGE
B. HYPGEOMDIST ✓
C. —
D. AVERAGEA_X

Explanation: “HYPGEOMDIST” is not related to AVERAGEA.

4. Which category does =AVERAGEA belong to?

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

Explanation: Category is “Statistical”.

5. How many required arguments does =AVERAGEA have?

A. 1 ✓
B. 0
C. 3
D. 2

Explanation: =AVERAGEA has 1 required, 0 optional (1 total).

6. Is argument “value1” required in =AVERAGEA?

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

Explanation: “value1” is required.

7. Which formula is a valid example of =AVERAGEA?

A. =AVERAGEA(A2:A6) ✓
B. AVERAGEA(A2:A6)
C. =AVERAGEA(A2:A6, 0)
D. =AVERAGE(A2:A6)

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

8. Since which Excel version is =AVERAGEA available?

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

Explanation: Version: “All versions”.

9. In =AVERAGEA, which is argument #1?

A. lookup_value
B. value
C. value1 ✓
D. range

Explanation: Argument #1 is “value1”.

10. What is the type of argument “value1” in =AVERAGEA?

A. Any type ✓
B. Logical
C. Number
D. Value

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

11. Which statement about =AVERAGEA is correct?

A. 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. ✓
B. For a symmetrical distribution of a group of numbers, these three measures of central tendency are all the same. For a skewed distribution of a group of numbers, they can be different.
C. If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGE function.
D. If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.

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.

12. Which is the correct syntax of =AVERAGEA?

A. AVERAGEA(value1, [value2], ...)
B. =AVERAGEA(value1, [value2], ..., 0)
C. =AVERAGEA(value1, [value2], ...) ✓
D. =AVERAGE(value1, [value2], ...)

Explanation: Correct syntax: =AVERAGEA(value1, [value2], ...)

13. Is =AVERAGEA volatile?

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

Explanation: AVERAGEA is not volatile.

14. How many arguments does =AVERAGEA have in total?

A. 2
B. 4
C. 3
D. 1 ✓

Explanation: =AVERAGEA has 1 required, 0 optional (1 total).

15. Which function is related to =AVERAGEA?

A. DB
B. AVERAGE ✓
C. FREQUENCY
D. MATCH

Explanation: “AVERAGE” is related to AVERAGEA.