56.5k views
0 votes
Create a PivotTable using the current worksheet's data to display the Quarterly Sales by Territory. True or False?

User Chh
by
7.1k points

1 Answer

3 votes

False. A PivotTable can be utilized to present Quarterly Sales by Territory by selecting the relevant data range, including columns with Territory and Sales data, and then using the PivotTable tool to group Sales by Quarter within the selected Territory.

How to explain

This tool allows a summarized view of sales across territories quarterly, but simply having data on the current worksheet isn't sufficient.

Creating a PivotTable involves using the PivotTable functionality within spreadsheet applications like Excel or G o o gle Sheets to organize and summarize the specified data.

User Rwat
by
7.3k points