Spreadsheets by IT4921X

VIEWS: 18 PAGES: 13

									Spreadsheets
Spreadsheets
 Software program capable of performing
  many calculations, functions, graphs
 Arranged in rows (by number) and
  columns (letters)
 Intersection of a row and column is the cell
  reference, e.g., B4
Basic Calculations
 Sum a row or column of numbers
 Method 1: use the Auto sum
 Method 2: key using formula bar:




   Notice the “range” inside the brackets
    More Calculations
   =E9-E8 Subtract the value in E8 from E9
   =G3*F2 Multiplies G3 by F2
   =K3/C4 Divides K3 by C4
   =AVERAGE(E1:E8) Finds the average value in this
    range
   =MIN(E1:E8) Finds the lowest value in this range
   =MAX(E1:E8) Finds the largest value in this range
   =COUNT(E1:E8) Reports the quantity of entries in
    this range
Growth Formulas
 Useful to show increase in value
 Example 1: =B4+B4*0.05 (fair)
 Example 2: =B4*1.05 (better)
 Example 3: =B4*$K$1 (best)
     Where   $K$1 contains % you can change!
Useful Tips
  Control~         Shows formula view

  Widen Columns    Hold left mouse key
                   over line to move

  Merge Cells

  Format Numbers   Right-click, Format
Fill Feature
   Create a formula and “drag” lower right corner
    to apply across or down (click the pic!)
IF Formula
 =IF(B9>-1,"Profit","Loss")
 Show the word "profit" if the value is zero
  or higher, otherwise shows the word
  "Loss"
Absolute Cell Referencing
 By default copied or filled formulas reflect
  related cells
 What if we need % of one total?




   $ signs in cells signify the cell is constant
Graphing
 By default column A is the x-axis and B, C,
  D, etc. are for values (Y-axes)
 Use the graph icon
 Name the series to create proper legends
 Excel graphs are drab … spice them up!
Graphing: Bar Graph
   Suitable for comparing values

                               Rain in Oakville


                 70

                 60

                 50

                 40
            mm
                 30

                 20

                 10

                 0
                      Winter   Spring            Summer   Fall
                                        Season
Graphing: Line Graph
Suitable for showing trends, often over time

                     Taylor's Marks
         100

         90

         80
     %




         70

         60

         50
               Feb   Mar     Apr      May   Jun
                            Month
Graphing: Pie Graph
•Useful for showing parts of a whole


                                         Rain in Oakville

                        70
                        60
                        50
           Rain in mm




                        40
                        30
                        20
                        10
                        0

                                te
                                     r              g            er        ll
                              in             r in               m     Fa
                             W             Sp               m
                                                          Su
                                                        Months

								
To top