Information =ERROR.TYPE(error_val)

Quiz =ERROR.TYPE — 10 Questions

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

Question 1 of 10 1/10

Is argument “error_val” required in =ERROR.TYPE?

Question 2 of 10 2/10

Which use case fits =ERROR.TYPE?

Question 3 of 10 3/10

Which function is NOT related to =ERROR.TYPE?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which category does =ERROR.TYPE belong to?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Is =ERROR.TYPE volatile?

Question 8 of 10 8/10

What is the fix for #N/A in =ERROR.TYPE?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Since which Excel version is =ERROR.TYPE available?

Click a question to see the answer.

1. Is argument “error_val” required in =ERROR.TYPE?

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

Explanation: “error_val” is required.

2. Which use case fits =ERROR.TYPE?

A. Error Handling ✓
B. Text Manipulation
C. Daily Tasks
D. Sort, Filter & Dedupe

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

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

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

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

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

A. Output is always a dynamic array
B. مقدار ‎#NULL!‎ برابر ۱ است؛ نگاشت کامل خطاها: ‎#NULL!=۱، ‎#DIV/0!=۲، ‎#VALUE!=۳، ‎#REF!=۴، ‎#NAME?=۵، ‎#NUM!=۶، ‎#N/A=۷، ‎#GETTING_DATA=۸ و هر مقدار دیگر ‎#N/A برمی‌گرداند.
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: بررسی کنید آرگومان‌ها نوع داده مناسب داشته باشند و تبدیل متن به عدد ممکن باشد.

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

A. Information ✓
B. Compatibility
C. Database
D. Text

Explanation: Category is “Information”.

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

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

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

7. Is =ERROR.TYPE volatile?

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

Explanation: ERROR.TYPE is not volatile.

8. What is the fix for #N/A in =ERROR.TYPE?

A. Text is always ignored
B. Volatile and recalculates every time
C. Check with ISERROR before using ✓
D. مقدار ‎#NAME?‎ برابر ۵ است؛ نگاشت کامل خطاها به بالا مراجعه کنید.

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

9. What usually causes #NULL! in =ERROR.TYPE?

A. مقدار ‎#N/A‎ برابر ۷ است؛ هر مقدار غیرخطا نیز ‎#N/A برمی‌گرداند.
B. Text is always ignored
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. Requires add-in

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!‎ تولید می‌کند؛ برای رفع آن مرجع‌ها را با کاما یا عملگر مناسب جدا کنید.

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

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

Explanation: Version: “All versions”.