Chuntao Huang is a senior consultant at Slate Blue Technology, a consulting firm in Santa Clara, California specializing in technology services. She is using an Excel workbook to track the sales of the company's consulting services to California clients. She asks for your help in creating PivotTables and PivotCharts to provide an overview of the revenue by month, city, and department.

Go to the California worksheet, which contains a table of data named Revenue. Chuntao wants to display the revenue amounts by department. Insert the Sum of Revenue by Department recommended PivotTable on a new worksheet, using Revenue by Department as the name of the worksheet.