'A company provides sustainability consulting to commercial, residential, and government clients. The company separates its 'operations into different regions of the U.S., and tracks sales data for each of its consultants. The details provided in the "Transaction Data" worksheet consist of transactions for the current year ended December 31. Using the \"scratch_sheet\" worksheet, we are asked to create and work with pivot tables to complete the following requirements. Requirements : 2. Which region has the highest total revenue amount and what is that amount? 3. Which region has the highest average revenue per transaction and what is that amount? 4. Which type of customer has the highest average revenue per transaction and what is that amount? 5. Which type of customer has the highest total revenue amount and what is that amount? 6. In the Southeast region, which type of customer has the highest total revenue amount and what is that amount? 7. In the Midwest region, which consultant has the highest total revenue amount and what is that amount? 8. In the Southwest region, which consultant has the largest number of separate revenue transactions and what is that number