Assignment Instructions 2 3 Student Exon Capac Report downed with this project On the Net Sales worksheet, calculats total in the range F4F and F. Apply the Trial cell stye to the range F Using absolute cel references as necessary in o 04 construct a formula to calculate the percent that the Colorad Total is of Total Bains, and then acory Percent Style with aro decimals F the formula down through the range 06.08. the range it, insert Line sparkines to represent the end of each state acres the fur garters Do not include the ais Day Markers Set the range A3 E, and then use the Recommended Charta command to suggest an appropriate chart. Cook the frit Clustered Column chart that uses the state names the category Algh the upper left corner of the chart inside me per comer of cell A11, and then size the chart that we right comer is sighty inside oil H24. Apply chars Style 7 As the chart e, type Quarterly Net Sales by State Close 10 Xubmit nment for ading " c " 15 14 for Grad 19 20 23 23 Front Range Action Sports Annual Net Sales Quarter Q Quarter3 Quarter 4 Perf C 2178134 A CARZE 21381345 A " 213 Tow 1304421 1477912 T 4/21788 24 4845245 44214333 A 126 17 28 Saventory Denver inventory Aimal Experent "