ABC Corporation-Container Division Regional Sales Analysis 2023 Sales \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{ Name: } \\ \hline & Qtr 1 & Qtr 2 & Qtr 3 & Qtr 4 & Year & Increase \\ \hline North & $125.00 & $126.00 & $145.00 & S. 158.00 & & \\ \hline Central & $214.80 & $204.80 & $215.40 & $258.20 & & \\ \hline East & $198.00 & $150.00 & $165.00 & $180.00 & & \\ \hline West & $252.27 & $184.27 & $195.13 & $220.73 & & \\ \hline Midwest & $288.77 & $196.27 & $205.13 & $231.73 & & \\ \hline West & $325.27 & $208.27 & $215.13 & S 242.73 & & \\ \hline Central & $361.77 & $220.27 & $225.13 & S 253.73 & & \\ \hline Midwest & $398.27 & $232.27 & $235.13 & S 264.73 & & \\ \hline East & $434.77$ & $244.27$24 & 5.13$275 & & & \\ \hline East & S 471.27 & $256.27 & S 255.13 & S 286.73 & & \\ \hline Atlantic & $507.77 & $268.27$ & 65.13 & $29773 & & \\ \hline West & $160.00 & $176.00 & $193.00 & S 225.00 & & \\ \hline TOTAL & & & & & XXXXXXX & XXXXXXXXXXX \\ \hline AVERAGE & & & & & XXXXXXX & XXXXXXXXXXX \\ \hline \end{tabular} Instructions: CENTRALIZE THE FIRST 3 TITLES BETWEEN COLUMNS Calculate YEAR ADD the quantities Horizontal Calculate Quantities Vertically CALCULATE THE AVERAGE (AVERAGE) OF EACH QTR Calculate Increase = Year 150% Create Pie Chart of the Year column Create Column Chart of the Increase column