Question

Given the following spreadsheet write the appropriate formula for expression function to be used for e2e he had formula to calculate the total quantity in Celsius be write the feature used for arranging the price from highest to lowest third to find the products maximum price to be written and son beaten to find average quantity to be written in cell C9 write formula to calculate the total amount in cell E
8

Answer 1

Total Quantity : =SUM( CELL RANGE)

Sort feature is used for arranging the price from highest to lowest.

Maximum Quantity : =MAX(Cell Range)

Average: = AVG ( CELL RANGE)

TOTAL AMOUNT : = SUM ( CELL RANGE)