Download the attached excel sheet titled E$-$Cornmerce Dalaxlsx.

ECommeice Data xlsx

a$.$ The excel sheet has information for the total number of shipment units and number of e commerce shipments for various manufacturing sectors for theyear $2017$ arid $201$ B$.$

Prepare the exolisheet to achieve the below objectives

$1$ Calculste the total shipmenn for $2018$ and $2017$ using formula

Calculate the total e$-$commerce shipment for $2017$ arki $2018$ using formula

Greate a column that calcuiates the year to year percentage change for total shipment if e$,$ chanpe $46$ between $2017$ and $2018)$

Create a column that calculated the year to year pescentape change for e$-$commerce shipments

Create a colunn tor the e$-$commeroe shipment as a percertsge of total shipment for each sectar for $2017$

Create a column for the e$-$commerce shipment as a percentage of fotal shipment for each sector for $2018$

$7.$ Create a column to calculate the percentage distritution of the e$-$comumerce sh pments for each sector fat year $2017($Hint$.$ The tolal percentage shwuid ack! up to $100\%$ for $2017.$ You MUST use absolute references$)$

Create a columi to calculate the percentiage distribution of the of$-$cummerce shipments fre each sectar for year $2018(H{\displaystyle \underset{\phantom{}}{\overset{\phantom{}}{}}}.$ The total percentage should add of to $100\%$ for $2018.$ You MUST use absolide reterences$)$