1. Enter a formula in cell J4 that divides cell I4 by I2. Place an absolute reference on cell I2.
2. Copy cell J4 and paste it into the range J5:J27.
3. Enter an IF function in cell M4 to determine if a store is a high growth exception. If the value in cell K4 is greater than 5%, then the output of the function should be the word Growth. Otherwise, there should be no output for the function. The logical_test argument should be K4>5%. The value_if_true argument should be the word Growth and must be enclosed in quotations. The value_if_false argument should be two quotations to leave the cell blank.
4. Copy cell M4 and paste it into the range M5:M27.
5. Begin an IF function in cell N4 on the Sales and Inventory worksheet. The purpose of this function is to determine if it is OK to deliver inventory to a store or if the delivery should be postponed. It can be a problem for smaller stores if too much inventory is delivered. For this company, a small store is 10,000 square feet.

Please show excel formulas

A1 XV fx Weekly Sales and Inventory Data by Store A B C D E F G 1 K M N O P a Weekly Sales and Inventory Data by Store Region Inventory Ship Status Status City Priority 2 Region 3 Number 4 1 5 2 6 1 7 1 8 1 9 3 10 1 11 2 12 2 13 3 1 1 15 1 15 1 17 4 18 3 19 4 1 21 2 3 23 4 24 1 3 25 3 4 28 29 Store Number State 3284 NJ 3255 MD 3216 NY 3412 NJ 3582 PA 3766 OH 3637 NJ 3744 FL 3636 GA 3911 OH 4100 MA 3816 NJ 4310 RI 4474 CA 4085 PA 4365 CA 4160 PA 4077 MD 4555 IL 4709 TX 4072 NY 4521 OH 4655 MI 4750 WA Company Results Size Sales Sales Percent of Total Change in Weeks of Growth (square feet) Inventory Value Last Year This Year Company Sales Supply Stores 10,000 $ 2,464,100 $ 821,000 $ 919,520 12.00% 2.68 25,000 1 $ 4,106,200 $ 694,167 $ 732,058 7.00% 5.61 10,000 $ 3,613.700$ 722,480 $ 952,526 18.00% 4.24 10,000 $ 2,053,900 $ 228,056 $ 216,653 -5.00% 9.471 20,000 $ 3,942,300 $ 562,971 $ 608,009 8.00% 6,481 25,000 $ 4,517,100 $ 564,4395 615,237 9.00% 7.34 15,000 $ 3,573 050 $ 396,817 $ 420,626 6.00% 8.49 10,000 $ 5,749 800 $ 478 917 $ 517.220 8.00% 11.11 20,000 $ 3,698 400 $ 389,450 $ 362,081 -2.00% 10.201 15,000 $ 3,286.000 $ 410,500 $ 410,500 0.00% 8.00 10,000 $ S 2,793 500 $ 232,617 $ 223,312 4.00% 12.50 25,000 $ 3,696.700 $ 461,813 $ 489,521 B.00% % 7.55 10,000 $ 2,793.700 $ 279,140 $ 273,557 -2.00% 10.20 10,000 $ 4,517.700 $ 301,033 273,940 9.00% 16.43 25,000 $ 5,543.850 $ 791,679 $ 839,179 5.00% 6.60 25,000 $ 4,189.100 $ 465,233 $ 451,276 -3.00% 9.28 10,000 $ 2,957.500 $ 328,400 $ 328,400 0.00% 9.00 15,000 $ 2,629.000 $ 525,440 $ 556,966 6.00% 4.721 10,000 $ 3,039,400 $ 253,142 $ 240,495 -5.00% 12.63 20,000 $ $ 252,615$ 229,880 -9.00% 14.29 15,000 $ 2.464.500 $ 615,750 $ 665,010 . 8.00% % 3.70 10,000 $ 1,643.400 547,333$ 613,013 12.00% 2.68 20,000 $ 4,599,900 $ 328,400 $ 302,128 -8.00% 15.22 15,000 $ 2,864 2005 318,111$ 316.111 0.00% % 9.00 3,285.000 31