ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ABC KIRANA SHOP
2
3
S.No.NamesPriceUnitQuantityAmount
4
1Cooking Oil1901 liter2
5
2Sona Munsuli Rice180030 kg3
6
3Soap351 pcs10
7
4Sugar891 kg5
8
9
Grand Total
10
11
12
a. Change the item name address B7 (i.e. Sugar) as Beaten Rice.

b. Add one record in row 8 as 5, Biscuit, 50, 1 pcs, 12 in column A, B, C, D and E respectively.

c. Add 'Liril' in front of 'Soap' of cell B6.

d. Change 'Sona Masuli Rice' of cell B5 as 'Basmati Rice' and price as 2400.

e. Calculate Amount (i.e. Column F) as the product of Price and Quantity and Grand Total in the cell F9.

13
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