Which Excel function determines whether a cell contains text, a number, a…
2024
Which Excel function determines whether a cell contains text, a number, a logical value, an array or an error?
- A.
CELLTYPE
- B.
TYPE
- C.
VALUETYPE
- D.
FORMULATYPE
Attempted by 58 students.
Show answer & explanation
Correct answer: B
The TYPE function is an Information function in Microsoft Excel used to identify the data type of a value or the contents of a specific cell. It is particularly useful when working with arguments that accept different types of data.
Syntax:
=TYPE(value)
The function accepts a single argument (value) and returns a corresponding integer mapping as shown below: