ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
AVERAGE, AVERAGEIF
3
4
5
1Open 'Sheet 2'. Write a formula in cell N4 to calculate the average quantity produced of each model.
6
7
8
9
2Write a formula in cell N5 to calculate the average quantity of each model produced in Mexico.
10
11
12
13
3Write a formula in cell N6 to calculate the average quantity of each Nikon model produced in Mexico.
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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