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

Answers
Answered by
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
Similar questions