Statistical =GAUSS(z)

Quiz =GAUSS — 10 Questions

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

Question 1 of 10 1/10

Which function is related to =GAUSS?

Question 2 of 10 2/10

What usually causes #NUM! in =GAUSS?

Question 3 of 10 3/10

How many optional arguments does =GAUSS have?

Question 4 of 10 4/10

Which category does =GAUSS belong to?

Question 5 of 10 5/10

How many required arguments does =GAUSS have?

Question 6 of 10 6/10

Is =GAUSS volatile?

Question 7 of 10 7/10

Which statement about =GAUSS is correct?

Question 8 of 10 8/10

Does =GAUSS return a dynamic array?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

What usually causes #VALUE! in =GAUSS?

Click a question to see the answer.

1. Which function is related to =GAUSS?

A. NOW
B. DETECTLANGUAGE
C. STANDARDIZE ✓
D. ACOSH

Explanation: “STANDARDIZE” is related to GAUSS.

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

A. Volatile and recalculates every time
B. Only works in old versions
C. If z is not a valid number, GAUSS returns the #NUM! error value. ✓
D. نوع داده z معتبر نیست.

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

3. How many optional arguments does =GAUSS have?

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

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

4. Which category does =GAUSS belong to?

A. Statistical ✓
B. Text
C. Logical
D. Financial

Explanation: Category is “Statistical”.

5. How many required arguments does =GAUSS have?

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

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

6. Is =GAUSS volatile?

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

Explanation: GAUSS is not volatile.

7. Which statement about =GAUSS is correct?

A. Volatile and recalculates every time
B. Only works in old versions
C. Select entire column for best performance
D. Because NORM.S.DIST(0,True) always returns 0.5, GAUSS (z) will always be 0.5 less than NORM.S.DIST(z,True). ✓

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).

8. Does =GAUSS return a dynamic array?

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

Explanation: GAUSS does not spill.

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

A. Check that the inputs are real numbers, not text ✓
B. Requires add-in
C. Volatile and recalculates every time
D. Select entire column for best performance

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

10. What usually causes #VALUE! in =GAUSS?

A. Text is always ignored
B. If z is not a valid data type, GAUSS returns the #VALUE! error value. ✓
C. مقدار z عدد معتبری نیست.
D. Select entire column for best performance

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