Applying Integrated Excel Project: Using Pivot Tables to Analyze Revenue\ 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.\ \ Required:\ What is the company's total revenue amount?\ Which region has the highest total revenue amount and what is that amount?\ Which region has the highest average revenue per transaction and what is that amount?\ Which type of customer has the highest average revenue per transaction and what is that amount?\ Which type of customer has the highest total revenue amount and what is that amount?\ In the Southeast region, which type of customer has the highest total revenue amount and what is that amount?\ In the Midwest region, which consultant has the highest total revenue amount and what is that amount?\ In the Southwest region, which consultant has the largest number of separate revenue transactions and what is that number?\