Lab Insight: Apply the same steps in Lab $7\mathrm{.}2$ to the Alt Lab $7\mathrm{.}2$ Data.xlsx dataset.

Required:

Create a pivot table for total sales revenue, average selling price, average process time, and total gross profit by table size, year, and quarter.

Create a pivot chart for total sales revenue and total gross profit by table size, year, and quarter.

Data: Alt Lab $7-2$ Data.xlsx

Specify the Question: What are total sales, average selling price, average process time, and total gross profit by table size, year, and quarter?

Analyze the Data: Refer to lab $7\mathrm{.}2$ in your text for additional instructions and steps.

Answer the following questions based on the details computed.

$\backslash$table$[[$Question$,$Answer$],[1.$ What is average process time for a small table in $2022?,],[2.$ What is total sales revenue for $2018-2022?($Round to the nearest dollar.$),],[3.$ What is the average selling price of a medium table in $2021?($Round to $2$ decimal places.$),],[4.$ How many sales transactions took place in $2018?,],[\backslash$table$[[5.$ Based on the pivot chart, what phrase best describes LeTable Incorporated's net income over the time$],[$analyzed $($assume there are no other expenses$)?]],]]$