Question 5
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 M9 on the “Summer Bookings” worksheet, insert a function that calculates the number of groups containing 12 or more people even if the order of the rows is changed.
- See explanation below.
Correct answer: 1
Explanation:
1. In cell M9, on the “Summer Bookings” worksheet, insert the following COUNTIF formula: “=COUNTIF(G6:G24, >= 12”)”References:https://support.office.com/en-us/article/count-numbers-greater-than-or-less-than-a-number-453b0ccc-cfaa-4332-ad02-6e148e01aa0a
1. In cell M9, on the “Summer Bookings” worksheet, insert the following COUNTIF formula: “=COUNTIF(G6:G24, >= 12”)”
References:
https://support.office.com/en-us/article/count-numbers-greater-than-or-less-than-a-number-453b0ccc-cfaa-4332-ad02-6e148e01aa0a