3w lecture excel by 7Q3g0n

VIEWS: 0 PAGES: 7

									Why do you need a spreadsheet program?
          organizing capabilities
          calculating capabilities
          charting capabilities

Starting excel 97 from win95
Mousing around
          top                                   left: title bar       right: sizing button
          menu bar                              pull-down menu
          standard tool bar                     each button a tool
          formatting tool bar
          formula bar                           cell address and current content

          sheet tab

          dialog box
          online help

Creating a spreadsheet from scratch
          a workbook contains 3 blank worksheets
          display of address position          3 ways
          only enter or edit the info in the cell that is current

          data types                            text      value       formula
          enter formula                         typing    pointng
          function
          editing cell                          3 ways
          further editing, menu bar

Creating Charts
          Purpose: heighten interest, illustrate trends and anomalies
          Chart Wizard                        4 steps
          Editing the chart with Chart toolbar
student number   grade
    324789         87
    324790         69
    324791         72
    324792         46
    324793         37
    324794         83
    324795         62
    324796         82
    324797         62
        1            100        100
        2            200        101
        3            300        102
        4            400        103
        5            500        104
        6            600        105
        7            700        106
        8            800        107
        9            900        108
       10           1000        109




1200                                                                    110

1000                                                                    108

800                                                                     106

600                                                           Series1   104

400                                                                     102

200                                                                     100

   0                                                                     98
            1   2   3   4   5   6   7   8   9   10 11 12 13                   1   2   3   4   5
                                  Series1




5   6   7   8   9   10 11 12 13
     Control       Drug
DS             1          2   8
HN             4          3
                              7
KE             3          4
                              6
ID             4          5
LE             5          4   5
ME             6          6   4
GC             7          2   3
                              2
                              1
                              0
Excel Exercises

Question 1
Plot the distribution of the grades in a course. The data follow.

Grade          # of students
A                       11
B                       27
C                       33
D                       16
Fail                     6


Question 2
A financial manager in a firm wants to know how profit margins have done for the past 16 quarters.
The data follow

Quarter        Profit Margin
           1          5.05
           2          4.10
           3          5.15
           4          5.20
           5          6.75
           6          5.30
           7          5.35
           8          5.40
           9          5.95
          10          5.50
          11          5.15
          12          5.60
          13          5.65
          14          6.70
          15          5.75
          16          5.80

a. Develop a line graph
b. Smooth the data using a Moving Average (create a separate column using formulas).
hint: A period's moving average value is
             the mean of the values for that period, the period before, and the period after.
c. In the above line graph (see a), plot the moving average of the profit margin

								
To top