Western Governors University (WGU) BUIT2200 C268 Spreadsheets Practice Exam

What should be done to calculate total merchandise sales for events with an 'Excellent' crowd size?

Use the Type field as Rows and sum values from Attendance Use the Crowd Size field as a Row label Use the Type field as a report filter and sum values from Merchandise Use the Event field for filtering

Correct Answer:

Use the Type field as a report filter and sum values from Merchandise

Explanation:

To calculate total merchandise sales for events with an 'Excellent' crowd size, filtering is essential to narrow down the data to only the relevant subset. Using the Type field as a report filter allows you to specifically include only those records that meet your criteria. Once the data is filtered by crowd size, you can then sum the values from the Merchandise field to get the total sales only for the desired crowd size category. This method ensures that you’re focused on the relevant events without interference from other crowd sizes, allowing for accurate and meaningful analysis. By just filtering for 'Excellent', you can isolate the results needed for your analysis without mixing in data from other crowd sizes.

Access more questions from this quiz

Continue to Western Governors University (WGU) BUIT2200 C268 Spreadsheets Practice Exam for more practice questions and the full quiz experience.

Access More Questions