Create a complex formula.

a$.$ Open EX $2-2.$xlsx from the location where you store your Data Files,

then save it as DX: $2-$Constimction Supply Company Inventoyy.

b$.$ Select the range B$4$AB$8,$ click the Totals tab in the Quick Analysis tool,

then click the AutoSum button.

c$.$ Use the fill handle to copy the formula in cell B$9$ to cells C$9$:E$9.$

d$.$ In cell B$11,$ create a complex formula that calculates a $30\%$ decrease

in the total number of cases of pylons.

e$.$ Use the fill handle to copy this formula into cell C$11$ through cell

E$11.$

f$.$ Save your work.