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

Quiz =GEOMEAN — 15 Questions

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

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

← GEOMEAN ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

In =GEOMEAN, which is argument #1?

Question 2 of 15 2/15

Does =GEOMEAN return a dynamic array?

Question 3 of 15 3/15

What is the fix for #NUM! in =GEOMEAN?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Which formula is a valid example of =GEOMEAN?

Question 6 of 15 6/15

Which function is NOT related to =GEOMEAN?

Question 7 of 15 7/15

Which use case fits =GEOMEAN?

Question 8 of 15 8/15

Is =GEOMEAN volatile?

Question 9 of 15 9/15

Which function is related to =GEOMEAN?

Question 10 of 15 10/15

How many required arguments does =GEOMEAN have?

Question 11 of 15 11/15

Since which Excel version is =GEOMEAN available?

Question 12 of 15 12/15

What usually causes #NUM! in =GEOMEAN?

Question 13 of 15 13/15

How many arguments does =GEOMEAN have in total?

Question 14 of 15 14/15

Which statement about =GEOMEAN is correct?

Question 15 of 15 15/15

Which category does =GEOMEAN belong to?

Click a question to see the answer.

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

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

Explanation: Argument #1 is “number1”.

2. Does =GEOMEAN return a dynamic array?

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

Explanation: GEOMEAN does not spill.

3. What is the fix for #NUM! in =GEOMEAN?

A. Volatile and recalculates every time
B. Use the growth factor instead of the growth rate ✓
C. Only works in old versions
D. Requires add-in

Explanation: If any data point ≤ 0, GEOMEAN returns the #NUM! error value. — Fix: Use the growth factor instead of the growth rate

4. What is the type of argument “number1” in =GEOMEAN?

A. Value
B. Mixed
C. Array
D. Number ✓

Explanation: Type of “number1” is “Number”.

5. Which formula is a valid example of =GEOMEAN?

A. =GEOMEAN(A2:A8) ✓
B. =GEOMEAN(A2:A8, 0)
C. =AVERAGE(A2:A8)
D. GEOMEAN(A2:A8)

Explanation: Correct example: =GEOMEAN(A2:A8)

6. Which function is NOT related to =GEOMEAN?

A. HARMEAN
B. GESTEP ✓
C. PRODUCT
D. AVERAGE

Explanation: “GESTEP” is not related to GEOMEAN.

7. Which use case fits =GEOMEAN?

A. Descriptive Statistics ✓
B. Lookup & Retrieval
C. Forecasting & Trends
D. Sort, Filter & Dedupe

Explanation: Use case “Descriptive Statistics” fits GEOMEAN.

8. Is =GEOMEAN volatile?

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

Explanation: GEOMEAN is not volatile.

9. Which function is related to =GEOMEAN?

A. AVERAGE ✓
B. FORECAST.ETS.STAT
C. NOT
D. CONCATENATE

Explanation: “AVERAGE” is related to GEOMEAN.

10. How many required arguments does =GEOMEAN have?

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

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

11. Since which Excel version is =GEOMEAN available?

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

Explanation: Version: “All versions”.

12. What usually causes #NUM! in =GEOMEAN?

A. Select entire column for best performance
B. Requires add-in
C. If any data point ≤ 0, GEOMEAN returns the #NUM! error value. ✓
D. Text is always ignored

Explanation: If any data point ≤ 0, GEOMEAN returns the #NUM! error value. — Fix: Use the growth factor instead of the growth rate

13. How many arguments does =GEOMEAN have in total?

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

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

14. Which statement about =GEOMEAN is correct?

A. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
B. Only works in old versions
C. Text is always ignored
D. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓

Explanation: Correct: Arguments can either be numbers or names, arrays, or references that contain numbers.

15. Which category does =GEOMEAN belong to?

A. Lookup & Reference
B. Compatibility
C. Statistical ✓
D. Financial

Explanation: Category is “Statistical”.