Question $3$

$[22$ marks$]$

Having explored pivot tables for data summarisation and analysis in one of your recent course modules, you've found the topic captivating. Now, you've come across Makro's store data and are eager to leverage pivot charts and graphs to illustrate how Makro is faring across its various operating regions.

Note: Complete the following questions using the provided data sheet named HCLT$108-1-$July$-$Dec$2024-$FA$2-$Macro Data flile avallable on CoI Campus under the FA$2$ tab.

Required:

$3\mathrm{.}1$ Create a pivot table to show the total regional sales revenue.

$(3$ marks$)$

$3\mathrm{.}2$ Create a pivot table to show the total regional profit sales.

$(3$ marks$)$

$3\mathrm{.}3$ Create a pivot table to show the average expenses per store location and region.

$(3$ marks$)$

$3\mathrm{.}4$ Create a pivot table showng expenses compared between Makro stores in different regions.

$(3$ marks$)$

$3\mathrm{.}5$ Create a pivot table showing each store locaton's average sales, expenses, and revenue.

$(3$ marks$)$

$3\mathrm{.}6$ Create a Line with Markers, chart from the pivot table created in Q$3\mathrm{.}3.$

$(3$ marks$)$

$3\mathrm{.}7$

eate a Bar chart from the pivot table created in Q$3.4$ and provide a title for the chart