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

Quiz =AVERAGE — 10 Questions

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

Question 1 of 10 1/10

In =AVERAGE, which is argument #1?

Question 2 of 10 2/10

Which statement about =AVERAGE is correct?

Question 3 of 10 3/10

Is =AVERAGE volatile?

Question 4 of 10 4/10

How many arguments does =AVERAGE have in total?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Is argument “number2” required in =AVERAGE?

Question 7 of 10 7/10

Which category does =AVERAGE belong to?

Question 8 of 10 8/10

In =AVERAGE, which is argument #2?

Question 9 of 10 9/10

How many optional arguments does =AVERAGE have?

Question 10 of 10 10/10

How many required arguments does =AVERAGE have?

Click a question to see the answer.

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

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

Explanation: Argument #1 is “number1”.

2. Which statement about =AVERAGE is correct?

A. On the File tab, select Options, and then, in the Advanced category, look under Display options for this worksheet.
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. Average, which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.
D. Only works in old versions

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.

3. Is =AVERAGE volatile?

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

Explanation: AVERAGE is not volatile.

4. How many arguments does =AVERAGE have in total?

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

Explanation: =AVERAGE has 1 required, 1 optional (2 total).

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

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

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

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

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

Explanation: “number2” is optional.

7. Which category does =AVERAGE belong to?

A. Financial
B. Compatibility
C. Web
D. Statistical ✓

Explanation: Category is “Statistical”.

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

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

Explanation: Argument #2 is “number2”.

9. How many optional arguments does =AVERAGE have?

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

Explanation: =AVERAGE has 1 required, 1 optional (2 total).

10. How many required arguments does =AVERAGE have?

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

Explanation: =AVERAGE has 1 required, 1 optional (2 total).