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:
>Open a blank spreadsheet on Google Sheets
6
>Enter all amounts below using only the keypad on your keyboard. Check your results.
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