Question

please answer this question briefly with correct explaination otherwise i m gonna report your answer. plzz answer it​

Answer 1

Answer:

(a) =SUM(C4:C7)

(b) Sorting

This feature in MS Excel is found in the Sort & Filter group in the Data tab.

(c) =MAX(D4:D7)

(d) =AVERAGE(C4:C7)

(e) =SUM(E4:E7)

[Note: before applying the formula in E8, we need to fill the E4, E5, E6 and E7 cells with the respective formulas of =C4*D4, =C5*D5, =C6*D6 and =C7*D7]

Hope it Helps!!

Answer 2

Answer:

a) =SUM(C4:C7)

b) Sorting

command, Data menu -----> Sort option(in OpenOffice calc)

c) =MAX(D4:D7)

d) =AVERAGE (C4:C7)

e) =SUM(E4:E7)

HOPE IT WILL HELP