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

Is argument “value” required in =TYPE?

Question 2 of 10 2/10

Which function is NOT related to =TYPE?

Question 3 of 10 3/10

Since which Excel version is =TYPE available?

Question 4 of 10 4/10

What is the output type of =TYPE?

Question 5 of 10 5/10

Which use case fits =TYPE?

Question 6 of 10 6/10

Which function is related to =TYPE?

Question 7 of 10 7/10

Which statement about =TYPE is correct?

Question 8 of 10 8/10

In =TYPE, which is argument #1?

Question 9 of 10 9/10

Which category does =TYPE belong to?

Question 10 of 10 10/10

Which is the correct syntax of =TYPE?

Click a question to see the answer.

1. Is argument “value” required in =TYPE?

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

Explanation: “value” is required.

2. Which function is NOT related to =TYPE?

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

Explanation: “VDB” is not related to TYPE.

3. Since which Excel version is =TYPE available?

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

Explanation: Version: “All versions”.

4. What is the output type of =TYPE?

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

Explanation: Output is “Number”.

5. Which use case fits =TYPE?

A. Error Handling ✓
B. Lookup & Retrieval
C. Dynamic Ranges & Dashboards
D. External Data, Web & Cube

Explanation: Use case “Error Handling” fits TYPE.

6. Which function is related to =TYPE?

A. HYPGEOMDIST
B. ERROR-TYPE ✓
C. MINUTE
D. CLEAN

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

7. Which statement about =TYPE is correct?

A. Volatile and recalculates every time
B. Text is always ignored
C. 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. ✓
D. You cannot use TYPE to determine whether a cell contains a formula. TYPE only determines the type of the resulting, or displayed, value. If value is a cell reference to a cell that contains a formula, TYPE returns the type of the formula's resulting value.

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. In =TYPE, which is argument #1?

A. criteria
B. range
C. lookup_value
D. value ✓

Explanation: Argument #1 is “value”.

9. Which category does =TYPE belong to?

A. Cube
B. Compatibility
C. Logical
D. Information ✓

Explanation: Category is “Information”.

10. Which is the correct syntax of =TYPE?

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

Explanation: Correct syntax: =TYPE(value)