Isabel has a PivotTable listing revenue from 100 campground rentals, with campgrounds listed by capacity. She wants to display campgrounds with capacity of 1-20, 21-40, and so on. How can she do so?
A) Group the campgrounds by reservation date.
B) Group the campgrounds by capacity.
C) Sort the campgrounds by revenue.
D) Filter the campgrounds by capacity.

Question

Quizplus · Accepted Answer

To display the campgrounds by capacity ranges, Isabel should group the campgrounds by capacity. This will allow her to easily create categories for 1-20, 21-40, and so on based on the capacity of each campground. Grouping by reservation date, sorting by revenue, or filtering by capacity will not provide the desired display of the data.

Isabel Has a PivotTable Listing Revenue from 100 Campground Rentals