Statistical =STANDARDIZE(x, mean, standard_dev)

Quiz =STANDARDIZE — 15 Questions

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

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

← STANDARDIZE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the output type of =STANDARDIZE?

Question 2 of 15 2/15

Which category does =STANDARDIZE belong to?

Question 3 of 15 3/15

How many optional arguments does =STANDARDIZE have?

Question 4 of 15 4/15

In =STANDARDIZE, which is argument #1?

Question 5 of 15 5/15

What is the type of argument “x” in =STANDARDIZE?

Question 6 of 15 6/15

How many arguments does =STANDARDIZE have in total?

Question 7 of 15 7/15

Which function is related to =STANDARDIZE?

Question 8 of 15 8/15

What usually causes #NUM! in =STANDARDIZE?

Question 9 of 15 9/15

Which statement about =STANDARDIZE is correct?

Question 10 of 15 10/15

Since which Excel version is =STANDARDIZE available?

Question 11 of 15 11/15

Which formula is a valid example of =STANDARDIZE?

Question 12 of 15 12/15

What is the type of argument “mean” in =STANDARDIZE?

Question 13 of 15 13/15

Does =STANDARDIZE return a dynamic array?

Question 14 of 15 14/15

Is argument “x” required in =STANDARDIZE?

Question 15 of 15 15/15

What is the type of argument “standard_dev” in =STANDARDIZE?

Click a question to see the answer.

1. What is the output type of =STANDARDIZE?

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

Explanation: Output is “Number”.

2. Which category does =STANDARDIZE belong to?

A. Lookup & Reference
B. Math & Trig
C. Logical
D. Statistical ✓

Explanation: Category is “Statistical”.

3. How many optional arguments does =STANDARDIZE have?

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

Explanation: =STANDARDIZE has 3 required, 0 optional (3 total).

4. In =STANDARDIZE, which is argument #1?

A. value
B. x ✓
C. lookup_value
D. mean

Explanation: Argument #1 is “x”.

5. What is the type of argument “x” in =STANDARDIZE?

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

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

6. How many arguments does =STANDARDIZE have in total?

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

Explanation: =STANDARDIZE has 3 required, 0 optional (3 total).

7. Which function is related to =STANDARDIZE?

A. MDURATION
B. RANDARRAY
C. AVERAGE ✓
D. REDUCE

Explanation: “AVERAGE” is related to STANDARDIZE.

8. What usually causes #NUM! in =STANDARDIZE?

A. Output is always a dynamic array
B. Text is always ignored
C. Requires add-in
D. If standard_dev ≤ 0, STANDARDIZE returns the #NUM! error value. ✓

Explanation: If standard_dev ≤ 0, STANDARDIZE returns the #NUM! error value. — Fix: Correct the input value

9. Which statement about =STANDARDIZE is correct?

A. Text is always ignored
B. Volatile and recalculates every time
C. The equation for the normalized value is: ✓
D. Only works in old versions

Explanation: Correct: The equation for the normalized value is:

10. Since which Excel version is =STANDARDIZE available?

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

Explanation: Version: “All versions”.

11. Which formula is a valid example of =STANDARDIZE?

A. =AVERAGE(A2,A3,A4)
B. STANDARDIZE(A2,A3,A4)
C. =STANDARDIZE(A2,A3,A4) ✓
D. =STANDARDIZE(A2,A3,A4, 0)

Explanation: Correct example: =STANDARDIZE(A2,A3,A4)

12. What is the type of argument “mean” in =STANDARDIZE?

A. Text
B. Number ✓
C. Array
D. Reference

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

13. Does =STANDARDIZE return a dynamic array?

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

Explanation: STANDARDIZE does not spill.

14. Is argument “x” required in =STANDARDIZE?

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

Explanation: “x” is required.

15. What is the type of argument “standard_dev” in =STANDARDIZE?

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

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