Download the attached excel sheet titled E$-$Commerce Data.xlsx$.$

E$-$Commerce Data.xIsx

The excel sheet has information for the total number of shipment units and number of e$-$

commerce shipments for various manufacturing sectors for the year $2017$ and $2018.$

Prepare the excel sheet to achieve the below objectives

Calculate the total shipment for $2018$ and $2017$ using formula

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

Create a column that calculates the year to year percentage change for total shipment $($i$.$e$.,$ change

$\%$ between $2017$ and $2018)$

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

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

for $2017$

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

for $2018$

Create a column to calculate the percentage distribution of the e$-$commerce shipments for each

sector for year $2017($Hint: The total percentage should add up to $100\%$ for $2017.$ You MUST use

absolute references$)$

Create a column to calculate the percentage distribution of the e$-$commerce shipments for each

sector for year $2018($Hint: The total percentage should add up to $100\%$ for $2018.$ You MUST use

absolute references$)$