Question

Q.36. Given the following Spreadsheet, Write the appropriate Formula/

Expression/ Function to be used for (a) to (e) 1X5=5



a. Write formula to calculate the Total Qty(C4:C7)) 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 D10

d. To find the Average Qty to be written in cell C9

e. Write formula to calculate the Total Amount in cell E8​

Answer 1

Answer:

to find maximum price to be written in cell d10