1.

Given the following Spreadsheet, Write the appropriate Formula/ Expression/ Function to be used for (a) to (e)ABCDEF12Departmental store3ProdcodePNAMEQTYPRICEAMOUNT4P101BAT5512505P102RACKET407006P103BALL651507P104GLOVES503008TOTAL9AVERAGE10MAXIMUMa. 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»

a. = sum(C4:C7)

b. Sort in ‘Sort and Filter’ group under Data tab

c. = max(D4:D7)

d. = average( C4:C7)

e. = sum(E4: E7)



Discussion

No Comment Found

Related InterviewSolutions