Question

Given the following spreadsheet write the appropriate formula/ expression /function to be used from A to E

Answer 1

Answer:

a. In cell B15 write formula   =average(B5:B13)

b. In cell K5 write formula      =sum(B5:J5)

c. In cell E16 write formula   =max(E5:E13)

d. In cell J14 write formula   =min(J5:J13)

e. To arrange the activities column data in ascending and descending order use filter option under Home Tab in M. S. Excel

Explanation:

for find sum in a cell range use sum formula     =sum(Number1, Number2,......)

for find average in a cell range use average formula  =average(Number1, Number2,...........)

for find maximum value in a cell range  use  =max(value1, value2,..........)

for find minimum value in a cell range use   =min(value1, value2,..........)

thankyou