Information =TYPE(value)

Quiz =TYPE — 10 Questions

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

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

← TYPE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the output type of =TYPE?

Question 2 of 10 2/10

Since which Excel version is =TYPE available?

Question 3 of 10 3/10

Is =TYPE volatile?

Question 4 of 10 4/10

What is the type of argument “value” in =TYPE?

Question 5 of 10 5/10

Which formula is a valid example of =TYPE?

Question 6 of 10 6/10

Which category does =TYPE belong to?

Question 7 of 10 7/10

Which statement about =TYPE is correct?

Question 8 of 10 8/10

How many required arguments does =TYPE have?

Question 9 of 10 9/10

How many arguments does =TYPE have in total?

Question 10 of 10 10/10

Which function is NOT related to =TYPE?

Click a question to see the answer.

1. What is the output type of =TYPE?

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

Explanation: Output is “Number”.

2. Since which Excel version is =TYPE available?

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

Explanation: Version: “All versions”.

3. Is =TYPE volatile?

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

Explanation: TYPE is not volatile.

4. What is the type of argument “value” in =TYPE?

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

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

5. Which formula is a valid example of =TYPE?

A. TYPE(A2)
B. =TYPE(A2) ✓
C. =TYPE(A2, 0)
D. =ERROR-TYPE(A2)

Explanation: Correct example: =TYPE(A2)

6. Which category does =TYPE belong to?

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

Explanation: Category is “Information”.

7. Which statement about =TYPE is correct?

A. Only works in old versions
B. Text is always ignored
C. Select entire column for best performance
D. TYPE is most useful when you are using functions that can accept different types of data, such as ARGUMENT and INPUT. Use TYPE to find out what type of data is returned by a function or formula. ✓

Explanation: Correct: TYPE is most useful when you are using functions that can accept different types of data, such as ARGUMENT and INPUT. Use TYPE to find out what type of data is returned by a function or formula.

8. How many required arguments does =TYPE have?

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

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

9. How many arguments does =TYPE have in total?

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

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

10. Which function is NOT related to =TYPE?

A. ISLOGICAL
B. ERROR-TYPE
C. HIDDEN ✓
D. ISFORMULA

Explanation: “HIDDEN” is not related to TYPE.