Math & Trig =MDETERM(array)

Quiz =MDETERM — 10 Questions

10 quiz questions about =MDETERM — test syntax, arguments, examples & errors!

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

← MDETERM ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is related to =MDETERM?

Question 2 of 10 2/10

What usually causes #VALUE! in =MDETERM?

Question 3 of 10 3/10

Which is the correct syntax of =MDETERM?

Question 4 of 10 4/10

Is argument “array” required in =MDETERM?

Question 5 of 10 5/10

Which category does =MDETERM belong to?

Question 6 of 10 6/10

How many arguments does =MDETERM have in total?

Question 7 of 10 7/10

In =MDETERM, which is argument #1?

Question 8 of 10 8/10

Which use case fits =MDETERM?

Question 9 of 10 9/10

Which function is NOT related to =MDETERM?

Question 10 of 10 10/10

Which formula is a valid example of =MDETERM?

Click a question to see the answer.

1. Which function is related to =MDETERM?

A. ABS ✓
B. ISERROR
C. IMSQRT
D. AMORDEGRC

Explanation: “ABS” is related to MDETERM.

2. What usually causes #VALUE! in =MDETERM?

A. Volatile and recalculates every time
B. Only works in old versions
C. Select entire column for best performance
D. MDETERM returns the #VALUE! error when: Any cells in array are empty or contain text. ✓

Explanation: MDETERM returns the #VALUE! error when: Any cells in array are empty or contain text. — Fix: Use a square numeric array

3. Which is the correct syntax of =MDETERM?

A. =MDETERM(array, 0)
B. =ABS(array)
C. =MDETERM(array) ✓
D. MDETERM(array)

Explanation: Correct syntax: =MDETERM(array)

4. Is argument “array” required in =MDETERM?

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

Explanation: “array” is required.

5. Which category does =MDETERM belong to?

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

Explanation: Category is “Math & Trig”.

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

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

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

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

A. array ✓
B. range
C. criteria
D. value

Explanation: Argument #1 is “array”.

8. Which use case fits =MDETERM?

A. Numbering & Sample Data
B. Dynamic Ranges & Dashboards
C. Daily Tasks
D. Rounding & Numeric ✓

Explanation: Use case “Rounding & Numeric” fits MDETERM.

9. Which function is NOT related to =MDETERM?

A. VALUE ✓
B. ARABIC
C. AGGREGATE
D. ABS

Explanation: “VALUE” is not related to MDETERM.

10. Which formula is a valid example of =MDETERM?

A. MDETERM(A2:D5)
B. =MDETERM(A2:D5, 0)
C. =MDETERM(A2:D5) ✓
D. =ABS(A2:D5)

Explanation: Correct example: =MDETERM(A2:D5)