Western Governors University (WGU) BUIT2200 C268 Spreadsheets Practice Exam

To view the data grouped by 'Type' and filtered by 'Crowd Size' in a PivotTable, one would set 'Type' as the Rows and 'Crowd Size' as Filters. This configuration allows for a clear organizational structure in the PivotTable.

When 'Type' is set as Rows, it establishes the categories along which the data will be summarized in rows. This allows for easy comparison and analysis of the various 'Type' entries. By setting 'Crowd Size' as a Filter, it enables the user to filter the displayed data based on specific crowd size criteria without altering the overall organization of the row data. This is essential for the analysis, as it allows the user to focus on only relevant subsets of the population based on crowd size, while still being able to examine the variations in 'Type'.

The other configurations, such as setting 'Type' or 'Crowd Size' as Values, wouldn't provide the necessary structure or filtering capability to meet the requirement of grouping by 'Type' while simultaneously applying a filter for 'Crowd Size'. Instead, they would muddle the intended analysis, misplacing the data in the PivotTable and potentially leading to misinterpretations.