PracticeSheet-Blank.xlsx

	A	B	C	D	E	G	H	I
1	ID	Product	Region	Sales in Rs.	Units Sold	Questions	Answer	Hint
2	1	Marker	South	263	30	Total Sale (Rs.)		SUM()
3	2	Notebook	North	234	40	Total Units Sold		SUM()
4	3	Marker	South	456	34	Average Sale (Rs.)		AVERAGE()
5	4	Pencil	North	350	39	Average Units Sold		AVERAGE()
6	5	Notebook	West	478	21	Round the Average Units Sold		ROUND()
7	6	Pen	East	453	10	Round the Average Units Sold to 1 Decimal Place		ROUND()
8	7	Pencil	North	233	37	Highest Units Sold		MAX()
9	8	Eraser	North	161	35	Lowest Units Sold		MIN()
10	9	Notebook	West	312	35	Count Total Number of Products		COUNT() - Work with numeric data only
11	10	Pencil	South	492	34	Count Total Number of South Region		COUNTIF()
12	11	Eraser	East	203	12	How many Units Sold are more than 50		COUNTIF()
13	12	Marker	North	460	55	Good if Total Sale (Rs.) is more than 14000, otherwise Poor		IF()
14	13	Notebook	West	407	19
15	14	Eraser	South	430	31
16	15	Eraser	East	456	39	Print Today Date
17	16	Pen	East	138	28	Print Today Date and Time
18	17	Marker	West	184	28
19	18	Pen	North	235	27
20	19	Marker	South	93	25
21	20	Marker	East	388	40
22	21	Eraser	East	92	17
23	22	Pen	North	321	38
24	23	Pen	West	60	44
25	24	Pencil	East	313	20
26	25	Pen	South	312	56
27	26	Marker	West	81	45
28	27	Pencil	East	469	19
29	28	Eraser	North	486	41
30	29	Marker	East	452	21
31	30	Pencil	South	189	24
32	31	Eraser	East	262	33
33	32	Pencil	South	112	23
34	33	Pen	East	172	17
35	34	Marker	East	257	30
36	35	Eraser	South	108	29
37	36	Pen	South	99	30
38	37	Notebook	West	452	26
39	38	Eraser	North	406	13
40	39	Pen	West	93	50
41	40	Marker	North	95	13
42	41	Notebook	South	432	37
43	42	Notebook	North	332	12
44	43	Notebook	West	136	18
45	44	Pen	East	399	43
46	45	Notebook	North	370	50
47	46	Marker	East	489	10
48	47	Pencil	West	374	22
49	48	Marker	West	92	36
50	49	Pencil	South	462	43
51	50	Pencil	South	90	30
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