MS Excel Data Types Quiz

Which data type in Excel is used to store numerical data such as integers, whole numbers, decimals, percentages, etc.?

• Logical/Boolean Data Type

• Number Data Type

• Error Data Type

• Text Data Type

What does the Date and Time data type in Excel allow us to show?

• Time only

• Dates only

• Dates and Time

• Numbers

What type of characters does the Text Data Type in Excel hold?

• Alphabets, numerical, and special symbols

• Special symbols only

• Numerical symbols only

• Alphabets only

What values can be stored in the Logical/Boolean Data Type in Excel?

• Only TRUE

• Only FALSE

• Both TRUE and FALSE

• Numbers

When would Excel display an Error Data Type?

• When dividing by zero

• When adding numbers

• When merging cells

• When formatting text

What is the primary difference between a number and text data type in Excel?

• You can perform calculations on text data but not number data

• You can perform calculations on number data but not text data

• Both can perform calculations

• Neither can perform calculations

What does the Error data type in Excel store?

• Correct values

• Error values

• Text values

• Logical values

What does the logical data type in Excel store?

• Only TRUE values

• Only FALSE values

• Error values

• Both TRUE and FALSE values

What does the Text Data Type in Excel hold?

• Only numbers

• Only dates

• Alphabets, numerical, and special symbols

• Only text

What is the purpose of the Date and Time Data Types in Excel?

• To store only time

• To store numbers

• To store dates and time

• To store only dates