Microsoft Exam 77-727 Topic 6 Question 17 Discussion

Actual exam question for Microsoft's exam

Question #: 17
Topic #: 6

SIMULATION

Project 6 of 7: Bike Tours

Overview

You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next six months.

In cell M10 on the ''Summer Bookings'' worksheet, insert a function that calculates the total amount of sales from the ''Total'' column for groups containing 12 or more people even if the order of the rows is changed.

A1. In cell M10 on the ''Summer Bookings'', insert the following SUMIF formula: ''=SUMIF(G6:G24, ''>= 12'', I6:I24).'''

B1. In cell M16 on the ''Summer Bookings'', insert the following SUMIF formula: ''=SUMIF(G6:G24, ''>= 12'', I6:I24).'''

Show Suggested Answer

Suggested Answer: A

References:

https://support.office.com/en-us/article/SUMIF-function-169B8C99-C05C-4483-A712-1697A653039B

by Sharika at May 05, 2022, 12:43 AM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!