Information =ISOMITTED(argument)

Quiz =ISOMITTED — 10 Questions

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

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

← ISOMITTED ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is =ISOMITTED volatile?

Question 2 of 10 2/10

Since which Excel version is =ISOMITTED available?

Question 3 of 10 3/10

How many required arguments does =ISOMITTED have?

Question 4 of 10 4/10

Which function is related to =ISOMITTED?

Question 5 of 10 5/10

What is the type of argument “argument” in =ISOMITTED?

Question 6 of 10 6/10

What is the output type of =ISOMITTED?

Question 7 of 10 7/10

Does =ISOMITTED return a dynamic array?

Question 8 of 10 8/10

Which use case fits =ISOMITTED?

Question 9 of 10 9/10

Which formula is a valid example of =ISOMITTED?

Question 10 of 10 10/10

Which function is NOT related to =ISOMITTED?

Click a question to see the answer.

1. Is =ISOMITTED volatile?

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

Explanation: ISOMITTED is not volatile.

2. Since which Excel version is =ISOMITTED available?

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

Explanation: Version: “Excel 365”.

3. How many required arguments does =ISOMITTED have?

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

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

4. Which function is related to =ISOMITTED?

A. MODE.MULT
B. IF ✓
C. MATCH
D. LEFTB

Explanation: “IF” is related to ISOMITTED.

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

A. Any type ✓
B. Date
C. Mixed
D. Reference

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

6. What is the output type of =ISOMITTED?

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

Explanation: Output is “Logical”.

7. Does =ISOMITTED return a dynamic array?

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

Explanation: ISOMITTED does not spill.

8. Which use case fits =ISOMITTED?

A. Advanced Formulas
B. Error Handling ✓
C. External Data, Web & Cube
D. Depreciation

Explanation: Use case “Error Handling” fits ISOMITTED.

9. Which formula is a valid example of =ISOMITTED?

A. =LAMBDA(x, [y], IF(ISOMITTED(y), x, x + y))(5, 0)
B. LAMBDA(x, [y], IF(ISOMITTED(y), x, x + y))(5)
C. =LAMBDA(x, [y], IF(IF(y), x, x + y))(5)
D. =LAMBDA(x, [y], IF(ISOMITTED(y), x, x + y))(5) ✓

Explanation: Correct example: =LAMBDA(x, [y], IF(ISOMITTED(y), x, x + y))(5)

10. Which function is NOT related to =ISOMITTED?

A. ISBLANK
B. IF
C. BESSELJ ✓
D. LAMBDA

Explanation: “BESSELJ” is not related to ISOMITTED.