Excel Data Types

In an excel spreadsheet there are three basic types of data that can be entered:

  • Constants – a number, a constant value
  • Labels – text with no numerical value
  • Formulas – a mathematical equation used to to calculate; all formulas begin with =
Examples:
Data Type Description Example
Constants Any number 23 or 10.5 or -75
Labels Name or Days or Month Anything that is just text
Formula Math Equation =10/2 or =match(A2,$C:$D,0)