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

Quiz =IFS — 10 Questions

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

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Since which Excel version is =IFS available?

Question 3 of 10 3/10

How many arguments does =IFS have in total?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

What usually causes #VALUE! in =IFS?

Question 6 of 10 6/10

Is argument “value_if_true1” required in =IFS?

Question 7 of 10 7/10

Is argument “logical_test1” required in =IFS?

Question 8 of 10 8/10

Which is the correct syntax of =IFS?

Question 9 of 10 9/10

Does =IFS return a dynamic array?

Question 10 of 10 10/10

Which use case fits =IFS?

Click a question to see the answer.

1. What is the type of argument “logical_test1” in =IFS?

A. Value
B. Logical ✓
C. Reference
D. Any type

Explanation: Type of “logical_test1” is “Logical”.

2. Since which Excel version is =IFS available?

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

Explanation: Version: “Excel 2019”.

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

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

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

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

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

Explanation: “logical_test2…logical_test127” is optional.

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

A. هیچ شرط TRUE یافت نشد.
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. Requires add-in
D. Volatile and recalculates every time

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 می‌دهد؛ فرمول شرط را اصلاح کنید.

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

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

Explanation: “value_if_true1” is required.

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

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

Explanation: “logical_test1” is required.

8. 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, 0)
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) ✓
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)

9. Does =IFS return a dynamic array?

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

Explanation: IFS does not spill.

10. Which use case fits =IFS?

A. Scientific & Unit Conversion
B. Daily Tasks ✓
C. Comparation
D. Investment Appraisal

Explanation: Use case “Daily Tasks” fits IFS.