Basics of a Spreadsheet

 
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 Basics of a Spreadsheet N

So let's get started digging into what makes a spreadsheet work. Spreadsheets are made up of

  • columns
  • rows
  • and their intersections are called cells
In each cell there may be the following types of data
  • text (labels)
  • number data (constants)
  • formulas (mathematical equations that do all the work)
Take a look at the explanations of each of these.
Remember there will be a short quiz later on so if there is something you need to take notes on,
TAKE NOTES ON IT!

198

  info@exceltalk.net