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

Quiz =AVERAGEA — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Since which Excel version is =AVERAGEA available?

Question 2 of 10 2/10

How many arguments does =AVERAGEA have in total?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Is =AVERAGEA volatile?

Question 5 of 10 5/10

Which statement about =AVERAGEA is correct?

Question 6 of 10 6/10

Which category does =AVERAGEA belong to?

Question 7 of 10 7/10

Which function is related to =AVERAGEA?

Question 8 of 10 8/10

In =AVERAGEA, which is argument #1?

Question 9 of 10 9/10

Which function is NOT related to =AVERAGEA?

Question 10 of 10 10/10

Which use case fits =AVERAGEA?

Click a question to see the answer.

1. Since which Excel version is =AVERAGEA available?

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

Explanation: Version: “All versions”.

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

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

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

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

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

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

4. Is =AVERAGEA volatile?

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

Explanation: AVERAGEA is not volatile.

5. Which statement about =AVERAGEA is correct?

A. To locate the Show a zero in cells that have a zero value check box:
B. Median which is the middle number of a group of numbers; that is, half the numbers have values that are greater than the median, and half the numbers have values that are less than the median. For example, the median of 2, 3, 3, 5, 7, and 10 is 4.
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. Arguments that contain TRUE evaluate as 1; arguments that contain FALSE evaluate as 0 (zero).

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 category does =AVERAGEA belong to?

A. Statistical ✓
B. Web
C. Cube
D. Database

Explanation: Category is “Statistical”.

7. Which function is related to =AVERAGEA?

A. AVERAGE ✓
B. AGGREGATE
C. XIRR
D. ISREF

Explanation: “AVERAGE” is related to AVERAGEA.

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

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

Explanation: Argument #1 is “value1”.

9. Which function is NOT related to =AVERAGEA?

A. LOGNORM.INV ✓
B. AVERAGEA_X
C. —
D. AVERAGE

Explanation: “LOGNORM.INV” is not related to AVERAGEA.

10. Which use case fits =AVERAGEA?

A. Scientific & Unit Conversion
B. Data Cleaning
C. Descriptive Statistics ✓
D. External Data, Web & Cube

Explanation: Use case “Descriptive Statistics” fits AVERAGEA.