Logical =IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)

Quiz =IFS — 15 Questions

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

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

← IFS ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many required arguments does =IFS have?

Question 2 of 15 2/15

What is the type of argument “logical_test2…logical_test127” in =IFS?

Question 3 of 15 3/15

Is argument “value_if_true2…value_if_true127” required in =IFS?

Question 4 of 15 4/15

Is =IFS volatile?

Question 5 of 15 5/15

Is argument “logical_test1” required in =IFS?

Question 6 of 15 6/15

Which is the correct syntax of =IFS?

Question 7 of 15 7/15

In =IFS, which is argument #1?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Is argument “logical_test2…logical_test127” required in =IFS?

Question 10 of 15 10/15

What usually causes #VALUE! in =IFS?

Question 11 of 15 11/15

How many arguments does =IFS have in total?

Question 12 of 15 12/15

Is argument “value_if_true1” required in =IFS?

Question 13 of 15 13/15

What is the type of argument “value_if_true1” in =IFS?

Question 14 of 15 14/15

Which function is NOT related to =IFS?

Question 15 of 15 15/15

Which category does =IFS belong to?

Click a question to see the answer.

1. How many required arguments does =IFS have?

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

Explanation: =IFS has 2 required, 2 optional (4 total).

2. What is the type of argument “logical_test2…logical_test127” in =IFS?

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

Explanation: Type of “logical_test2…logical_test127” is “Logical”.

3. Is argument “value_if_true2…value_if_true127” required in =IFS?

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

Explanation: “value_if_true2…value_if_true127” is optional.

4. Is =IFS volatile?

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

Explanation: IFS is not volatile.

5. Is argument “logical_test1” required in =IFS?

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

Explanation: “logical_test1” is required.

6. Which is the correct syntax of =IFS?

A. =IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3) ✓
B. =AND([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)
C. =IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3, 0)
D. IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)

Explanation: Correct syntax: =IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)

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

A. criteria
B. range
C. logical_test2…logical_test127
D. logical_test1 ✓

Explanation: Argument #1 is “logical_test1”.

8. What is the fix for #VALUE! in =IFS?

A. مطمئن شوید هر شرط منطقی نتیجه TRUE یا FALSE می‌دهد؛ فرمول شرط را اصلاح کنید. ✓
B. Only works in old versions
C. Select entire column for best performance
D. Output is always a dynamic array

Explanation: If a logical_test argument is evaluated and resolves to a value other than TRUE or FALSE, this function returns a #VALUE! error. — Fix: مطمئن شوید هر شرط منطقی نتیجه TRUE یا FALSE می‌دهد؛ فرمول شرط را اصلاح کنید.

9. Is argument “logical_test2…logical_test127” required in =IFS?

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

Explanation: “logical_test2…logical_test127” is optional.

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

A. Select entire column for best performance
B. If a logical_test argument is evaluated and resolves to a value other than TRUE or FALSE, this function returns a #VALUE! error. ✓
C. Volatile and recalculates every time
D. Requires add-in

11. How many arguments does =IFS have in total?

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

Explanation: =IFS has 2 required, 2 optional (4 total).

12. Is argument “value_if_true1” required in =IFS?

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

Explanation: “value_if_true1” is required.

13. What is the type of argument “value_if_true1” in =IFS?

A. Value
B. Text
C. Any type ✓
D. Number

Explanation: Type of “value_if_true1” is “Any type”.

14. Which function is NOT related to =IFS?

A. AND
B. IF
C. SWITCH
D. SKEW.P ✓

Explanation: “SKEW.P” is not related to IFS.

15. Which category does =IFS belong to?

A. Logical ✓
B. Engineering
C. Math & Trig
D. Compatibility

Explanation: Category is “Logical”.