# 3w lecture excel by 7Q3g0n

VIEWS: 0 PAGES: 7

• pg 1
```									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
standard tool bar                     each button a tool
formatting tool bar
formula bar                           cell address and current content

sheet tab

dialog box

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

Creating Charts
Purpose: heighten interest, illustrate trends and anomalies
Chart Wizard                        4 steps
Editing the chart with Chart toolbar
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.

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