Docstoc

Words or Text in a Spreadsheet

Document Sample
Words or Text in a Spreadsheet Powered By Docstoc
					Microsoft Excel
 Spreadsheets - organization of number data
  into columns and rows that helps people
  calculate number data
 Uses for Spreadsheets
   Businesses use spreadsheets to track how many
    hours employees work and the money they earn.
   Teachers use spreadsheets to track grades and
    attendance.
   Spreadsheets can answer “what if?” questions –
    “What if I make $13/day for 30 days?”
Spreadsheet Terminology
A column goes up and down the page.
  A spreadsheet contains hundreds of
                 columns.
Each column is identified by a letter – in
           alphabetical order.

                     Column
                Identifiers also
                called Column
                  Headings
Spreadsheet Terminology
    A row goes across the page.
  Rows are labeled in number order.

A cell is the box where
a column and row meet.


      Row Identifiers,
      also called Row
        Headings                  Active
                                   Cell
Spreadsheet Terminology
Spreadsheets have many worksheets
  or sheets. Each sheet has a name –
     sheets are Sheet1, Sheet2, etc.
  When you are working in Excel the
    Sheet numbers are located at the
  bottom of your screen and show you
    what sheet you are working with.
Spreadsheet Terminology
You can type numbers in
    cells. Numbers are
  called values. Values
  are used in calculations
  to figure out how much
        or how many.


In a spreadsheet, words
     are text or labels.
    Labels tell you what
    the data in the cells
           mean.
Spreadsheet Terminology
  An active cell is the cell you are
  working with and has a dark border
               around it.
               The cell address is the
                   location of the active
             cell you are working with.
               What is the cell address
                        in this example?
              Active
               Cell
Spreadsheet Terminology
  A spreadsheet uses
         formulas
    to calculate results.
Formulas begin with an
         equal sign.
A formula in a cell tells
  the spreadsheet to do
   math using numbers
  from other cells in the
        spreadsheet.
                                                 Column
                                                  Label

                                       Column
                  Numbers
                                      Headings
                  are called
                    values

  Row                                   The cell address
  Label                                for this active cell
                     Active Cell –       would be C9.
  Row               has dark border
Headings               around it



             Shows what
           worksheet you are
             working with

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:11/14/2010
language:English
pages:9
Description: Words or Text in a Spreadsheet document sample