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

Which use case fits =AVERAGEA?

Question 2 of 15 2/15

In =AVERAGEA, which is argument #1?

Question 3 of 15 3/15

Is =AVERAGEA volatile?

Question 4 of 15 4/15

Does =AVERAGEA return a dynamic array?

Question 5 of 15 5/15

Which function is related to =AVERAGEA?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Which function is NOT related to =AVERAGEA?

Question 8 of 15 8/15

Since which Excel version is =AVERAGEA available?

Question 9 of 15 9/15

What is the output type of =AVERAGEA?

Question 10 of 15 10/15

How many arguments does =AVERAGEA have in total?

Question 11 of 15 11/15

Which is the correct syntax of =AVERAGEA?

Question 12 of 15 12/15

Which category does =AVERAGEA belong to?

Question 13 of 15 13/15

Which formula is a valid example of =AVERAGEA?

Question 14 of 15 14/15

How many required arguments does =AVERAGEA have?

Question 15 of 15 15/15

Which statement about =AVERAGEA is correct?

Click a question to see the answer.

1. Which use case fits =AVERAGEA?

A. Data Cleaning
B. Reshape Tables
C. Date & Time Calculations
D. Descriptive Statistics ✓

Explanation: Use case “Descriptive Statistics” fits AVERAGEA.

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

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

Explanation: Argument #1 is “value1”.

3. Is =AVERAGEA volatile?

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

Explanation: AVERAGEA is not volatile.

4. Does =AVERAGEA return a dynamic array?

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

Explanation: AVERAGEA does not spill.

5. Which function is related to =AVERAGEA?

A. TRIMMEAN
B. IMCOSH
C. AVERAGE ✓
D. IMSECH

Explanation: “AVERAGE” is related to AVERAGEA.

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

A. Value
B. Any type ✓
C. Date
D. Array

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

7. Which function is NOT related to =AVERAGEA?

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

Explanation: “CONFIDENCE” is not related to AVERAGEA.

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. What is the output type of =AVERAGEA?

A. Date
B. Array
C. Text
D. Number ✓

Explanation: Output is “Number”.

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

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

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

11. Which is the correct syntax of =AVERAGEA?

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

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

12. Which category does =AVERAGEA belong to?

A. Date & Time
B. Information
C. Text
D. Statistical ✓

Explanation: Category is “Statistical”.

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

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

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

14. How many required arguments does =AVERAGEA have?

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

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

15. Which statement about =AVERAGEA is correct?

A. 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.
B. 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. ✓
C. Select entire column for best performance
D. Text is always 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.