150Data Types

 
Home
Excel Welcome
Spreadsheet Tutorial
Why on a Computer?
Basics of a Spreadsheet
COLUMN Defined
ROW Defined
CELL Defined
150Data Types
Labels in Excel
Constants in Excel
Formulas in Excel
Basic Formulas in Excel
Change in Formulas
Basic Math Functions
Methods of Selecting Cells
Sum Function
Average Function
Max Function
Min Function
Count Function
CountA Function
IF Function
PMT (loan stuff)
SIN COS TAN etc.
Function Wizard
Copying Formulas
Fill Down
Absolute Positioning
Fill Right
Formatting Text
I P Types of Data N


In a spreadsheet there are three basic types of data that can be entered.

  • labels - (text with no numerical value)
  • constants - (just a number -- constant value)
  • formulas* - (a mathematical equation used to calculate)

 

 
data types examples descriptions
LABEL Name or Wage or Days anything that is just text
CONSTANT 5 or 3.75 or -7.4 any number
FORMULA =5+3 or = 8*5+3 math equation


*ALL formulas MUST begin with an equal sign (=).

1548959


  info@exceltalk.net