Data Types

Which data type in Excel is used for storing text or alphanumeric characters?

• Number
• Date
• Boolean
• Text

In Access, which data type is suitable for storing long descriptions or notes?

• Long Text
• Date/Time
• Number
• Short Text

Which data type in Excel is used the value of 67%?

• Percentage
• Whole Number
• Fraction
• Decimal

What is the data type in Access that automatically generates a unique number for each record?

• RecordNumber
• AutoNumber
• UniqueID
• SequenceNumber

Which Excel data type can display errors like #DIV/0! or #VALUE!?

• Text
• Number
• Error
• Date

In Access, which data type is used for storing values in an 'Amount outstanding' field?

• Currency
• Text
• Date/Time
• Integer

Which Excel data type is used to store values in a "Date of Arrival" field?

• Boolean
• Number
• Text
• Date

Which Access data type is used to store web addresses or file paths like in an "Email Address" field?

• Memo
• Text
• Number
• Hyperlink

Which of the following would you use to store accurate scientific values such as a number between 1 and 0

• Integer data type
• String data type
• Boolean data type
• Floating-point data type

In Excel, which data type is used to store logical values in a field (Absent/Present or TRUE or FALSE)?

• Integer
• String
• Date
• Boolean