Information =ERROR.TYPE(error_val)

Quiz =ERROR.TYPE — 15 Questions

15 quiz questions about =ERROR.TYPE — test syntax, arguments, examples & errors!

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

← ERROR.TYPE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which function is related to =ERROR.TYPE?

Question 2 of 15 2/15

Which category does =ERROR.TYPE belong to?

Question 3 of 15 3/15

Since which Excel version is =ERROR.TYPE available?

Question 4 of 15 4/15

What usually causes #NUM! in =ERROR.TYPE?

Question 5 of 15 5/15

Which function is NOT related to =ERROR.TYPE?

Question 6 of 15 6/15

What usually causes #NAME? in =ERROR.TYPE?

Question 7 of 15 7/15

What usually causes #N/A in =ERROR.TYPE?

Question 8 of 15 8/15

Which is the correct syntax of =ERROR.TYPE?

Question 9 of 15 9/15

What is the type of argument “error_val” in =ERROR.TYPE?

Question 10 of 15 10/15

How many required arguments does =ERROR.TYPE have?

Question 11 of 15 11/15

Is =ERROR.TYPE volatile?

Question 12 of 15 12/15

Does =ERROR.TYPE return a dynamic array?

Question 13 of 15 13/15

Which use case fits =ERROR.TYPE?

Question 14 of 15 14/15

What usually causes #VALUE! in =ERROR.TYPE?

Question 15 of 15 15/15

What is the fix for #NULL! in =ERROR.TYPE?

Click a question to see the answer.

1. Which function is related to =ERROR.TYPE?

A. TEXTBEFORE
B. PROPER
C. DATEVALUE
D. CHOOSE ✓

Explanation: “CHOOSE” is related to ERROR.TYPE.

2. Which category does =ERROR.TYPE belong to?

A. Compatibility
B. Information ✓
C. Statistical
D. Financial

Explanation: Category is “Information”.

3. Since which Excel version is =ERROR.TYPE available?

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

Explanation: Version: “All versions”.

4. What usually causes #NUM! in =ERROR.TYPE?

A. Volatile and recalculates every time
B. #NULL! = 1; #DIV/0! = 2; #VALUE! = 3; #REF! = 4; #NAME? = 5; #NUM! = 6; #N/A = 7; #GETTING_DATA = 8; Anything else = #N/A. ✓
C. مقدار ‎#NULL!‎ برابر ۱ است؛ نگاشت کامل خطاها: ‎#NULL!=۱، ‎#DIV/0!=۲، ‎#VALUE!=۳، ‎#REF!=۴، ‎#NAME?=۵، ‎#NUM!=۶، ‎#N/A=۷، ‎#GETTING_DATA=۸ و هر مقدار دیگر ‎#N/A برمی‌گرداند.
D. Text is always ignored

Explanation: #NULL! = 1; #DIV/0! = 2; #VALUE! = 3; #REF! = 4; #NAME? = 5; #NUM! = 6; #N/A = 7; #GETTING_DATA = 8; Anything else = #N/A. — Fix: بررسی کنید اعداد در محدوده مجاز تابع باشند و تکرار محاسبات همگرا شود.

5. Which function is NOT related to =ERROR.TYPE?

A. CHOOSE
B. ISERROR
C. IMSINH ✓
D. IFNA

Explanation: “IMSINH” is not related to ERROR.TYPE.

6. What usually causes #NAME? in =ERROR.TYPE?

A. مقدار ‎#VALUE!‎ برابر ۳ است؛ نگاشت کامل خطاها به بالا مراجعه کنید.
B. مقدار ‎#NUM!‎ برابر ۶ است؛ نگاشت کامل خطاها به بالا مراجعه کنید.
C. #NULL! = 1; #DIV/0! = 2; #VALUE! = 3; #REF! = 4; #NAME? = 5; #NUM! = 6; #N/A = 7; #GETTING_DATA = 8; Anything else = #N/A. ✓
D. Output is always a dynamic array

Explanation: #NULL! = 1; #DIV/0! = 2; #VALUE! = 3; #REF! = 4; #NAME? = 5; #NUM! = 6; #N/A = 7; #GETTING_DATA = 8; Anything else = #N/A. — Fix: نام تابع یا محدوده نام‌گذاری‌شده را از نظر املایی بررسی کنید و متن‌ها را داخل گیومه بگذارید.

7. What usually causes #N/A in =ERROR.TYPE?

A. Output is always a dynamic array
B. #NULL! = 1; #DIV/0! = 2; #VALUE! = 3; #REF! = 4; #NAME? = 5; #NUM! = 6; #N/A = 7; #GETTING_DATA = 8; Anything else = #N/A. ✓
C. Requires add-in
D. مقدار ‎#NUM!‎ برابر ۶ است؛ نگاشت کامل خطاها به بالا مراجعه کنید.

Explanation: #NULL! = 1; #DIV/0! = 2; #VALUE! = 3; #REF! = 4; #NAME? = 5; #NUM! = 6; #N/A = 7; #GETTING_DATA = 8; Anything else = #N/A. — Fix: Check with ISERROR before using

8. Which is the correct syntax of =ERROR.TYPE?

A. =CHOOSE(error_val)
B. =ERROR.TYPE(error_val, 0)
C. =ERROR.TYPE(error_val) ✓
D. ERROR.TYPE(error_val)

Explanation: Correct syntax: =ERROR.TYPE(error_val)

9. What is the type of argument “error_val” in =ERROR.TYPE?

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

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

10. How many required arguments does =ERROR.TYPE have?

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

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

11. Is =ERROR.TYPE volatile?

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

Explanation: ERROR.TYPE is not volatile.

12. Does =ERROR.TYPE return a dynamic array?

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

Explanation: ERROR.TYPE does not spill.

13. Which use case fits =ERROR.TYPE?

A. Securities & Bonds
B. Conditional Logic
C. Error Handling ✓
D. Conditional Aggregation

Explanation: Use case “Error Handling” fits ERROR.TYPE.

14. What usually causes #VALUE! in =ERROR.TYPE?

A. Only works in old versions
B. مقدار ‎#NUM!‎ برابر ۶ است؛ نگاشت کامل خطاها به بالا مراجعه کنید.
C. Text is always ignored
D. #NULL! = 1; #DIV/0! = 2; #VALUE! = 3; #REF! = 4; #NAME? = 5; #NUM! = 6; #N/A = 7; #GETTING_DATA = 8; Anything else = #N/A. ✓

Explanation: #NULL! = 1; #DIV/0! = 2; #VALUE! = 3; #REF! = 4; #NAME? = 5; #NUM! = 6; #N/A = 7; #GETTING_DATA = 8; Anything else = #N/A. — Fix: بررسی کنید آرگومان‌ها نوع داده مناسب داشته باشند و تبدیل متن به عدد ممکن باشد.

15. What is the fix for #NULL! in =ERROR.TYPE?

A. مقدار ‎#NAME?‎ برابر ۵ است؛ نگاشت کامل خطاها به بالا مراجعه کنید.
B. مقدار ‎#N/A‎ برابر ۷ است؛ هر مقدار غیرخطا نیز ‎#N/A برمی‌گرداند.
C. بررسی کنید آیا فرمول واقعاً خطای ‎#NULL!‎ تولید می‌کند؛ برای رفع آن مرجع‌ها را با کاما یا عملگر مناسب جدا کنید. ✓
D. مقدار ‎#REF!‎ برابر ۴ است؛ نگاشت کامل خطاها به بالا مراجعه کنید.

Explanation: #NULL! = 1; #DIV/0! = 2; #VALUE! = 3; #REF! = 4; #NAME? = 5; #NUM! = 6; #N/A = 7; #GETTING_DATA = 8; Anything else = #N/A. — Fix: بررسی کنید آیا فرمول واقعاً خطای ‎#NULL!‎ تولید می‌کند؛ برای رفع آن مرجع‌ها را با کاما یا عملگر مناسب جدا کنید.