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 C8

b) Write the feature used for arranging the Price from Highest to Lowest

c) To find the Product with 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

a) Formula to calculate the Total Qty(C4:C7) in cell C8:

=SUM(C4,C7)

b) For arranging the Price from highest to lowest click on the first cell that you desired to select on the spreadsheet and then drag the mouse to the last cell that you want to select. Then right click on the selected range and click on ‘Sort’ option and then click on the option ‘Sort Largest to Smallest’.

c) Formula for finding the maximum price to be written in the cell D10:

=MAX(D4,CD,D6,D7)

d) Formula for finding the average Qty to be written in the cell C9:

=AVERAGE(C4,C5,C6,C7)

e) Formula for finding the total amount in E8:

=SUM(E4,E7)

Answer 2

Answer:

Explanation:

=sum(c4c7)