Question

31.
Given the following spread
oiven the following Spreadsheet, write appropriate Formus! Du
Amount
PName
Quantity
55
oo a un WNH
Department Store
Prod Code
P101
P102
P103
P105
40
1250
700
150
300
65
L
Bat
Racket
Ball
Gloves
Total
Average
Maximum
i)
Write formula to calculate Total Quantity(04:07) in cell 08
so
ii) Write the feature used for arranging the price from Highest to Lowest
iii) To find the Maximum Price to be written in Cell D10 0
iv) To find Average Quantity to be written in cell C9
v) Write formula to calculate the Total Amount in cell E8​

Answer 1

Answer:

I did not understand the question