AutoSave OFF HES 5 Cell Reference Homework Two Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 = = v % Conditional Formatting v Format as Table HL H 5 Y Paste BI U A A. Number Cells Editing Ideas y Sensitivity 112 Cell Styles S14 X A B D E F H J L M N P Q R 5 Jan Feb March April May June July Aug Sept Oct Nov Dec Price $60 $25 Reduced price by Month Jeans Shirts 1 Product 2 Jeans 3 Shirts 4 5 Month 6 Reduction 7 B Jan April July Dec Feb 20% March 40% 60% May 15% June 10% Aug 10% Sept 0% Oct 15% Nov 15% 15% 25% 20% Instructions: ABC Store sells Jeans and Shirts for a regular price of $600 for jeans and $25 for shirts. However, most months, they offer a percent reduction on the regular price of the clothes as outlined above i.e. In January, the items are discounted by 20%. Find the reduced price (NOT the amount of the discount) of each itern for each month of the year using cell references only. -0 -1 -2 3 -4 -5 .6 -7 -8 -9 CO 1 2 3 24 25 C6 7 28 9 =0 -1 2 3