ABCDEFGHIJKLMNOPQRSTUVWXY
1
Excel Lab# 1: SUM and AVERAGE functions
FUNCTION:
=SUM(Range of cells)==========>
Ex: =SUM(B13:B18)
2
=AVERAGE(Range of cells)
=========>
Ex: =AVG(B19:F19)
3
Other ways:
To Get Totals
4
ALT, + , Enter
5
Directions:
6
7
>Total all columns by using AutoSum function
8
>Complete the percentages for each column by: dividing Individual items sales by Total Monthly
9
* Do Not type 0's after the decimal point
10
* Do Not type dollar sign
11
JCP Computer Services Sales
12
1st Quater
Items Sales
January
Percentage
February
Percentage
March
Percentage
13
Monitors\$6,000.007.69%\$6,150.008%\$175.007%
14
Desktops\$12,000.0015.38%\$12,250.0015%\$275.0011%
15
Laptops\$18,000.0023.08%\$18,375.0023%\$375.0015%
16
2-in-one PCs\$24,000.0030.77%\$24,425.0031%\$475.0019%
17
Tablets\$6,000.007.69%\$6,125.008%\$575.0023%
18
Gaming PCs\$12,000.0015.38%\$12,250.0015%\$675.0026%
19
Monthly Total==>\$78,000.00\$79,575.00\$2,550.00\$53,375.00<======
=Average(B19:F19)
20
2nd Quarter
Items Sales
April
Percentage
May
Percentage
June
Percentage
21
Monitors\$111.25
22
Desktops\$212.50
23
Laptops\$313.75
24
2-in-one PCs\$414.95
25
Tablets\$515.25
26
Gaming PCs\$616.50
27
Monthly Total==>
<<<<<===
=Average( B27:F27)
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100