Section-D
5x 2-10
21. Given the following Spreadsheet, Write the appropriate Formula/
Expression/Function to be used for (a) to (e)
QTY
2 Departmental Store
Prodcode PNAME
P101 BAT
P102 RACKET
P103 BALL
2104 GLOVES
TOTAL
AVERAGE
MAXIMUM
PRICE AMOUNT
55 1250
700
150
50 300
a. Write formula to calculate the Total Qty (C4:07) in cell C8
b. Write the feature used for arranging the Price from Highest to
Lowest
c. To find the Maximum Price to be written in Cell Dio
d. To find the Average Qty to be written in cell C9
e. Write formula to calculate the Total Amount in cell E8
Answers
Answered by
0
Answer:
sorry I don't know the answer
Similar questions