Which one of the following is not a valid data type in Excel?

CURRENCY

VARIANT

CHARACTER

DATE

Data types in Excel are

BYTE Number from 0 to 255 for storing binary data

INTEGER Integer from -32 768 to 32 767.

LONG Integer from -2 147 483 648 to 2 147 483 647

SINGLE Numeric data type with float precision to 6 decimal digits

DOUBLE Numeric data type with float precision with double precision in calculatons

CURRENCY A number with fixed 4 decimal digits

DECIMAL Numeric data type with fixed precision and scale (accuracy upto 28).

STRING Text strings. Flexible length or 64 kilobytes

BOOLEAN Logical value (true or false)

DATE The date in the range from 1.1.100 to 31.12.9999

OBJECT Reference to an object.

VARIANT Basic type. May contain special value Null, numeric value, text, reference to object or variable array.

Strengthen Your Practice with our comprehensive question bank.

Get Expert Advice for Free: Register for Your Free Consultation Now!

Full Name

Phone Number

Select Language

Select Course

Please leave this field empty.