Study the worksheet below and answer the questions that follow: i) Write functions that can be entered to get total, maximum, and average of each region. ii) Write...

      

Study the worksheet below and answer the questions that follow:
fig66620191227.png
i) Write functions that can be entered to get total, maximum, and average of
each region.
ii) Write down the function that returns the number of sales in the four regions
whose value is greater than or equal to 2000.
iii) The function = sum (B4:E4) is entered at F5 and then copied to F8. Write down the function as it appears in the destination cell.

  

Answers


Kavungya
i)Total = Sum (B4:B8)
Maximum: = Max (B4:B8)
Average: = Average (B4: B8)

ii)= SUMIF (B4:E4, “>=2000”)

iii)= sum (B7:E7)
Kavungya answered the question on June 6, 2019 at 09:28


Next: What is a chart wizard in spreadsheets?
Previous: A worksheet contains the data shown below: State the value displayed in G1

View More Computer Studies Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions