Accessibility tab summary: Transaction data is provided in rows $2$ to $1013.$

Consultant Region Customer Revenue Invoice Date Invoice No$.$ Country

Lauren Northwest Government $$28,6671/1$ Jan$-0001$ U$.$S$.$

Juan Southwest Residential $$8151/1$ Jan$-0002$ U$.$S$.$

Juan Southwest Government $$10,1711/1$ Jan$-0003$ U$.$S$.$

Juan Southwest Government $$31,2301/2$ Jan$-0004$ U$.$S$.$

Tom Northeast Commercial $$11,4321/2$ Jan$-0005$ U$.$S$.$

Forrest Southwest Commercial $$7,8181/3$ Jan$-0006$ U$.$S$.$

Olivia Northwest Government $$43,6351/3$ Jan$-0007$ U$.$S$.$

Xavion Southeast Residential $$1,0631/4$ Jan$-0008$ U$.$S$.$

Sandra Southeast Residential $$1,2311/4$ Jan$-0009$ U$.$S$.$

Juan Southwest Residential $$1,0811/4$ Jan$-0010$ U$.$S$.$

Minda Southwest Residential $$6051/5$ Jan$-0011$ U$.$S$.$

Forrest Southwest Residential $$7251/5$ Jan$-0012$ U$.$S$.$

Minda Southwest Residential $$1,4291/5$ Jan$-0013$ U$.$S$.$

Forrest Southwest Government $$10,4261/6$ Jan$-0014$ U$.$S$.$

Tom Northeast Commercial $$9,4941/7$ Jan$-0015$ U$.$S$.$

Becky Midwest Residential $$6521/9$ Jan$-0016$ U$.$S$.$

Lauren Northwest Government $$38,0241/10$ Jan$-0017$ U$.$S$.$

Juan Southwest Government $$34,3091/10$ Jan$-0018$ U$.$S$.$

Minda Southwest Government $$17,7701/11$ Jan$-0019$ U$.$S$.$

Chloe Southeast Residential $$1,2481/11$ Jan$-0020$ U$.$S$.$

Grace Northeast Residential $$7491/11$ Jan$-0021$ U$.$S$.$

Olivia Northwest Government $$20,9281/12$ Jan$-0022$ U$.$S$.$

George Northeast Residential $$1,1601/12$ Jan$-0023$ U$.$S$.$

Xavion Southeast Commercial $$8,4801/12$ Jan$-0024$ U$.$S$.$

George Northeast Residential $$1,2121/12$ Jan$-0025$ U$.$S$.$

Minda Southwest Residential $$1,4491/12$ Jan$-0026$ U$.$S$.$

Minda Southwest Residential $$5351/12$ Jan$-0027$ U$.$S$.$

Tom Northeast Commercial $$13,0271/13$ Jan$-0028$ U$.$S$.$

George Northeast Residential $$5911/13$ Jan$-0029$ U$.$S$.$

Olivia Northwest Residential $$5961/13$ Jan$-0030$ U$.$S$.$

Sandra Southeast Commercial $$14,7431/13$ Jan$-0031$ U$.$S$.$

Grace Northeast Commercial $$9,5131/13$ Jan$-0032$ U$.$S$.$

Kasey Midwest Government $$22,7441/14$ Jan$-0033$ U$.$S$.$

Olivia Northwest Government $$38,9321/14$ Jan$-0034$ U$.$S$.$

Grace Northeast Residential $$9581/14$ Jan$-0035$ U$.$S$.$

Juan Southwest Residential $$9361/15$ Jan$-0036$ U$.$S$.$

Tom Northeast Commercial $$9,3841/15$ Jan$-0037$ U$.$S$.$

Juan Southwest Government $$29,3321/15$ Jan$-0038$ U$.$S$.$

George Northeast Residential $$7561/15$ Jan$-0039$ U$.$S$.$

Becky Midwest Residential $$5081/15$ Jan$-0040$ U$.$S$.$

Grace Northeast Residential $$9321/16$ Jan$-0041$ U$.$S$.$

Chloe Southeast Residential $$8961/17$ Jan$-0042$ U$.$S$.$

Forrest Southwest Residential $$9141/17$ Jan$-0043$ U$.$S$.$

Tom Northeast Residential $$5981/17$ Jan$-0044$ U$.$S$.$

Xavion Southeast Residential $$5171/18$ Jan$-0045$ U$.$S$.$

Tom Northeast Commercial $$9,3351/19$ Jan$-0046$ U$.$S$.$

Chloe Southeast Commercial $$10,0461/19$ Jan$-0047$ U$.$S$.$

Grace Northeast Residential $$7101/19$ Jan$-0048$ U$.$S$.$

Minda Southwest Residential $$5321/19$ Jan$-0049$ U$.$S$.$

Kasey Midwest Residential $$6771/21$ Jan$-0050$ U$.$S$.$

Xavion Southeast Government $$21,6381/21$ Jan$-0051$ U$.$S$.$

Olivia Northwest Residential $$1,0041/21$ Jan$-0052$ U$.$S$.$

Olivia Northwest Residential $$6691/22$ Jan$-0053$ U$.$S$.$

Sandra Southeast Residential $$8321/22$ Jan$-0054$ U$.$S$.$

Becky Midwest Residential $$5661/22$ Jan$-0055$ U$.$S$.$

Minda Southwest Government $$18,3711/22$ Jan$-0056$ U$.$S$.$

Minda Southwest Residential $$7501/23$ Jan$-0057$ U$.$S$.$

George Northeast Residential $$9121/23$ Jan$-0058$ U$.$S$.$

Juan Southwest Residential $$1,2991/23$ Jan$-0059$ U$.$S$.$

Juan Southwest Government $$46,1651/24$ Jan$-0060$ U$.$S$.$

Juan Southwest Residential $$1,2661/24$ Jan$-0061$ U$.$S$.$

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.

Use the proper excel formula for every calucated requirements:

Required:

$1.$ What is the company's total revenue amount?

$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?