Question

Someone Answer this please​

Answer 1

Answer:

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)

MARK ME AS BRAINLIEST !!