Question

31
Observe the given below spreadsheet and answer the following questions:
A
D
7
26
Price
Amount
Product code
P101
P102
Departmental Store
Product Name Quantity
Shirt
5
Suit
1
Jeans
6
650
5
P103
P104
2150
1125
550
1500
6
Kurta
2
7
P105
0
9
Sarees
Minimum
Maximum
Average
Total
70
77
a) Write formula to calculate total quantity in cell C11
b) Write formula to find minimum price in cell D8
c) Write formula to find maximum price in cell D9
d) Write formula to calculate average quantity in cell C10.
e) Write the formula to calculate total amount for product sarees in cell E7
48​

Answer 1

Answer:

i am not getting the data because of formatting but i can surely tell you above formulas:

1. sum(start cell:end cell) in cell c11

2. min(start cell:end cell) in cell d8

3. max(start cell:end cell) in cell d9

4. avg(start cell:end cell) in cell c10

5. sum(start cell: end cell) in cell e7

each formula should start with =

Explanation:

cell number is combination of column number and row number