In Excel, which data type is stored in cells?

In Excel, which data type is stored in cells?

• A. Dates and times
• B. Numbers and text
• C. Formulas and macros
• D. Colors and fonts

Answer: (B)

In Excel, what you store directly in a cell are the values you work with: numbers and text. Dates and times aren’t a separate category of data here; they’re stored as numeric serial values and shown using date/time formatting. Formulas and macros are not the raw data in a cell—they’re instructions or code. Colors and fonts are formatting, not the stored data itself. So the best description is that cells hold numbers and text.

In Excel, what you store directly in a cell are the values you work with: numbers and text. Dates and times aren’t a separate category of data here; they’re stored as numeric serial values and shown using date/time formatting. Formulas and macros are not the raw data in a cell—they’re instructions or code. Colors and fonts are formatting, not the stored data itself. So the best description is that cells hold numbers and text.