Given the Following Spreadsheet, Write the appropriate Formula/ Expression/ Function to be used for (a) to (e)a) Write formula to calculate the Total Qty(C4:C7)) in cell C8b) Write the feature used for arranging the Price from Highest to Lowestc) To find the Product with Maximum Price to be written in Cell D10d) To find the Average Qty to be written in cell C9e) Write formula to calculate the Total Amount in cell E8

Given the Following Spreadsheet, Write the appropriate Formula/ Expres

1.	Given the Following Spreadsheet, Write the appropriate Formula/ Expression/ Function to be used for (a) to (e)a) Write formula to calculate the Total Qty(C4:C7)) in cell C8b) Write the feature used for arranging the Price from Highest to Lowestc) To find the Product with Maximum Price to be written in Cell D10d) To find the Average Qty to be written in cell C9e) Write formula to calculate the Total Amount in cell E8
Answer» to the cell C8. Then write the formula SUM(C4:C7). This formula will return the sum of the values present from cell C4 to C7.B) The FEATURE used for arranging the price from the highest to the lowest is called SORT. The formula is =LARGE(data, ROWS(exp_rng)).C) To FIND the product, MOVE to cell no. C10.Then use the formula = PRODUCT( num1, num2, ... num N )D) To find the average, move to cell no. C9Then write the formula =AVG(num1, num2, num3.....num n).E) To calculate the total amount, move to the cell E8, and write the formula = SUM(num1, num2, num3....num n).