Statistical =GAUSS(z)

Quiz =GAUSS — 15 Questions

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

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

← GAUSS ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which formula is a valid example of =GAUSS?

Question 2 of 15 2/15

Which category does =GAUSS belong to?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Is argument “z” required in =GAUSS?

Question 5 of 15 5/15

What is the fix for #VALUE! in =GAUSS?

Question 6 of 15 6/15

What is the output type of =GAUSS?

Question 7 of 15 7/15

In =GAUSS, which is argument #1?

Question 8 of 15 8/15

How many arguments does =GAUSS have in total?

Question 9 of 15 9/15

Which statement about =GAUSS is correct?

Question 10 of 15 10/15

Which use case fits =GAUSS?

Question 11 of 15 11/15

Is =GAUSS volatile?

Question 12 of 15 12/15

How many required arguments does =GAUSS have?

Question 13 of 15 13/15

Which function is NOT related to =GAUSS?

Question 14 of 15 14/15

What usually causes #NUM! in =GAUSS?

Question 15 of 15 15/15

Since which Excel version is =GAUSS available?

Click a question to see the answer.

1. Which formula is a valid example of =GAUSS?

A. =STANDARDIZE(2)
B. =GAUSS(2) ✓
C. GAUSS(2)
D. =GAUSS(2, 0)

Explanation: Correct example: =GAUSS(2)

2. Which category does =GAUSS belong to?

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

Explanation: Category is “Statistical”.

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

A. برای z یک مقدار عددی معتبر وارد کنید. ✓
B. Only works in old versions
C. Select entire column for best performance
D. Output is always a dynamic array

Explanation: If z is not a valid number, GAUSS returns the #NUM! error value. — Fix: برای z یک مقدار عددی معتبر وارد کنید.

4. Is argument “z” required in =GAUSS?

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

Explanation: “z” is required.

5. What is the fix for #VALUE! in =GAUSS?

A. Check that the inputs are real numbers, not text ✓
B. Requires add-in
C. Select entire column for best performance
D. Output is always a dynamic array

Explanation: If z is not a valid data type, GAUSS returns the #VALUE! error value. — Fix: Check that the inputs are real numbers, not text

6. What is the output type of =GAUSS?

A. Date
B. Reference
C. Number ✓
D. Value

Explanation: Output is “Number”.

7. In =GAUSS, which is argument #1?

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

Explanation: Argument #1 is “z”.

8. How many arguments does =GAUSS have in total?

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

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

9. Which statement about =GAUSS is correct?

A. Volatile and recalculates every time
B. Text is always ignored
C. Because NORM.S.DIST(0,True) always returns 0.5, GAUSS (z) will always be 0.5 less than NORM.S.DIST(z,True). ✓
D. Output is always a dynamic array

Explanation: Correct: Because NORM.S.DIST(0,True) always returns 0.5, GAUSS (z) will always be 0.5 less than NORM.S.DIST(z,True).

10. Which use case fits =GAUSS?

A. Lookup & Retrieval
B. Probability & Hypothesis Testing ✓
C. Securities & Bonds
D. Workdays & Due Dates

Explanation: Use case “Probability & Hypothesis Testing” fits GAUSS.

11. Is =GAUSS volatile?

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

Explanation: GAUSS is not volatile.

12. How many required arguments does =GAUSS have?

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

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

13. Which function is NOT related to =GAUSS?

A. NORM-S-DIST
B. STANDARDIZE
C. PHI
D. CHISQ.DIST ✓

Explanation: “CHISQ.DIST” is not related to GAUSS.

14. What usually causes #NUM! in =GAUSS?

A. If z is not a valid number, GAUSS returns the #NUM! error value. ✓
B. Select entire column for best performance
C. Volatile and recalculates every time
D. Text is always ignored

Explanation: If z is not a valid number, GAUSS returns the #NUM! error value. — Fix: برای z یک مقدار عددی معتبر وارد کنید.

15. Since which Excel version is =GAUSS available?

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

Explanation: Version: “Excel 2013”.