Information =TYPE(value)

Quiz =TYPE — 15 Questions

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

Question 1 of 15 1/15

How many optional arguments does =TYPE have?

Question 2 of 15 2/15

Does =TYPE return a dynamic array?

Question 3 of 15 3/15

Which function is related to =TYPE?

Question 4 of 15 4/15

How many arguments does =TYPE have in total?

Question 5 of 15 5/15

Since which Excel version is =TYPE available?

Question 6 of 15 6/15

In =TYPE, which is argument #1?

Question 7 of 15 7/15

Which category does =TYPE belong to?

Question 8 of 15 8/15

Which use case fits =TYPE?

Question 9 of 15 9/15

Which formula is a valid example of =TYPE?

Question 10 of 15 10/15

Is =TYPE volatile?

Question 11 of 15 11/15

Which is the correct syntax of =TYPE?

Question 12 of 15 12/15

How many required arguments does =TYPE have?

Question 13 of 15 13/15

Is argument “value” required in =TYPE?

Question 14 of 15 14/15

Which statement about =TYPE is correct?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. How many optional arguments does =TYPE have?

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

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

2. Does =TYPE return a dynamic array?

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

Explanation: TYPE does not spill.

3. Which function is related to =TYPE?

A. INT
B. PERCENTILE.INC
C. F.INV.RT
D. ERROR-TYPE ✓

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

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

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

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

5. Since which Excel version is =TYPE available?

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

Explanation: Version: “All versions”.

6. In =TYPE, which is argument #1?

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

Explanation: Argument #1 is “value”.

7. Which category does =TYPE belong to?

A. Text
B. Compatibility
C. Lookup & Reference
D. Information ✓

Explanation: Category is “Information”.

8. Which use case fits =TYPE?

A. Error Handling ✓
B. Reporting
C. Numbering & Sample Data
D. Depreciation

Explanation: Use case “Error Handling” fits TYPE.

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

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

Explanation: Correct example: =TYPE(A2)

10. Is =TYPE volatile?

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

Explanation: TYPE is not volatile.

11. Which is the correct syntax of =TYPE?

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

Explanation: Correct syntax: =TYPE(value)

12. How many required arguments does =TYPE have?

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

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

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

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

Explanation: “value” is required.

14. Which statement about =TYPE is correct?

A. 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.
B. 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. ✓
C. Only works in old versions
D. Select entire column for best performance

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.

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

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

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