Question

. 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 1

a) =SUM (C4:C7)

b)SORT>Sort largest to smallest.

c)=PRODUCT (number1, number 2, ....number n)

d)=AVERAGE (Region01,Region 02, ....)

e)=SUM (number1,numbers, ....)

Answer 2

Explanation:

A) = sum (c4:c7)

b) sort>highest to lowest

c) =Max (D4:D7)

d)=Avg(C4:C7)

e)=sum (E4:E7)