Docstoc

Spreadsheet

Document Sample
Spreadsheet Powered By Docstoc
					Digital Communication Systems



Spreadsheet Fundamentals
Spreadsheet . . .
  a program that allows you to use ROWS and COLUMNS of data to
     manage, predict, and present information.



                           A         B
                 1       BIRTHDAY GIFTS
                 2
                 3        GIFT      COST
                 4    CD Player     $48.00
                 5    Nike Jacket   $99.75
                 6    Gap Jeans     $59.00
                      Computer                ROW
                 7    Game           $68.50
                 8    Three CD's     $31.25
                 9
                 10   Total Cost    $306.50

                 COLUMN
Advantages of Computer
Spreadsheets

  Fast and Accurate

  Can answer “What Is….?”

  Can Answer “What If….?”
     Can Answer “What Is….?”
 students’ current grade (school)

 individual athlete statistics (sports)

 transportation schedules (business)

 current $ available for spending (personal)

 census results
     Can Answer “What If….?
 student population increases (school)

 win/loss record changes (sports)

 product sales decrease (business)

 hourly wage rate changes (personal)
   Uses of Computer
   Spreadsheets
 School
   student grades
   payroll
   class sizes
   schedules         Sports
                        individual and team
                         statistics
                        current and future budgets
   Uses of Computer Spreadsheets,
   cont’d
 Personal
   checkbook
   household expenses
   investments
   income taxes
                          Business
                              payroll
                              investments
                              inventory
                              product sales
                              delivery
  Uses of Computer
  Spreadsheets, cont’d

 Government
   Taxes
   Census
   Loans
   Investments
   budgets
                        Title Bar                 Menu Bar
Cell Reference Box



                                                                   Toolbar
                                                                 Formatting toolbar


                                    Formula bar
                     Active Cell




                Worksheet Tabs




                       Status Bar                  Scroll Bars     Task Plane
     Spreadsheet Terms

 Active Cell - The cell ready for data entry.
 Alignment - When data is entered into a cell,
  the default alignment is labels to the left and
  values to the right.
 Cell - Intersection of a row and column and is
  identified by a cell reference.
 Cell range - A selected group of cells that
  form a rectangle
    Spreadsheet Terms, cont’d.

 Cell reference - The column letter and the
  row number. Example: B12
 Column - Identified by letters that appear at
  the top of the spreadsheet. (Vertical)
 Formula - Equations with symbols for math
 operations. Example =B6+B7+B8+B9
 Function - Special formulas that do not use
 operators to calculate a result. i.e. A shortcut
 formula. Example: =sum(A6:A9)
    Spreadsheet Terms, cont’d.
 Label - Text, symbols, dates, or numbers not
  used in calculations.
 Rows - Identified by numbers on the left side
  of the spreadsheet. (Horizontal)
 Spreadsheet - A program that allows you to
  use rows and columns of data to manage,
  predict, and present information.
 Value - A number entered into a spreadsheet
  cell that will be used for calculations
       Spreadsheet Terms
                A         B
      1       BIRTHDAY GIFTS                  Cell (B3)
      2                              Intersection of a row and a
      3        GIFT        COST                column
      4    CD Player       $48.00
      5    Nike Jacket     $99.75
      6    Gap Jeans       $59.00
                                               Value
           Computer
                                       A number entered on a
     7     Game             $68.50
                                      spreadsheet and used for
     8     Three CD's       $31.25          calculations
     9
     10    Total Cost      $306.50


         Label                              Formula
Text, Symbols, dates, or             An equation with symbols
  numbers not used in                  for math operations
      calculations                     B4+B5+B6+B7+B8
More Terms
          A         B
1       BIRTHDAY GIFTS
2
3        GIFT         COST
4    CD Player        $48.00
5    Nike Jacket      $99.75
6    Gap Jeans        $59.00    Range (B4:B8)
                                A block of cells
     Computer
7    Game              $68.50
8    Three CD's        $31.25
9
                                   Functions
10   Total Cost       $306.50   Shortcut formulas
                                  Sum(B4:b8)
    Sum….Adds the range
 Average….averages the range
            Is it a Value, Label, Function, or Formula?
22
Number
A3*D6
$2,300.00
355-6961
AVG(C6:C10
27834 (zip code)
Social Security Number
NAME
The total of expenses
Commission * Rate
The sum of the range G2-G25
Column headings
15%
522 S. Saunders Street
    Writing a Formula
    Text                                 What is the formula?
 Multiply F3 times C4                    =F3 * C4
 Add A2 and A3.                          =A2+A3
 Subtract D4 from D3.                    =D3-D4
 Divide E3 by C1.                        =E3/C1
 Add the range B2-B10                    =sum(B2:B10)
 Add C6 through C10 then subtract C5.    =sum(C6:C10)-C5
 Add A3 and A4 then divide by C10        =(A3+A4)/C10
 Find the average of D1through D10.      =average(D1:D10)
Formulas . . .
A tool for making calculations with the numbers
              on your spreadsheet

       Four Basic Calculations
 Add                 +            A1+B1
 Subtract            -            C3-D4
 Multiply            *            B6*A2
 Divide              /            F1/F3
Order of Operations

You can also use parenthesis in your calculations
where the order of operations is completed first:
               (A1+A2)*(B7/D4)
                  (7+11)*(4/2)
                      18*2
                       36
Function-Shortcut formula

                                     SUM function will add all
     1       BIRTHDAY GIFTS
                                     numbers in a range
     2
     3       GIFT         COST
     4   CD Player         $48.00
     5   Nike Jacket       $99.75
     6   Gap Jeans         $59.00
                                           Range=(B4:B8)
         Computer
    7    Game              $68.50
    8    Three CD's        $31.25
    9
    10   Total Cost     sum(B4:B8)


                       Function
Function-Shortcut formula

    1        BIRTHDAY GIFTS            Average (avg) function
    2                                 averages all numbers in a
                                                range
    3        GIFT        COST
    4    CD Player        $48.00
    5    Nike Jacket      $99.75
    6    Gap Jeans        $59.00
         Computer                         Range
    7    Game                $68.50
    8    Three CD's          $31.25
    9
    10   Total Cost    avg(B4:B8)

                  Function

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:2/17/2012
language:English
pages:20