Enter a SUM function in cell G$2$ on the Sales and Inventory worksheet. The SUM function should sum the values in the Inventory Value column. Add cell capacity to the function to include Row $40.$

Copy cell G$2$ and paste it into cells H$2$ and I$2.$

Enter an HLOOKUP function in cell B$4$ on the Sales and Inventory worksheet that will show the region name from the Region Plan worksheet. The $$lookup$\_$value$$ argument should be defined with cell A$4$ on the Sales and Inventory worksheet. The $$table$\_$array$$ argument should be the range B$2$:E$5$ on the Region Plan worksheet. Place an absolute reference on this range. The $$row$\_$index$\_$num$$ argument should be the number $2$ and the $$range$\_$lookup$$ argument should be the word $$FALSE$.$

Copy cell B$4$ and paste it into the range B$5$:B$27.$

Enter a VLOOKUP function in cell E$4$ on the Sales and Inventory worksheet that will show the city for each store from the Store Details worksheet. The $$lookup$\_$value$$ argument should be defined with cell C$4$ on the Sales and Inventory worksheet. The $$table$\_$array$$ argument should be the range A$3$:F$26$ on the Store Details worksheet. Place an absolute reference on this range. The $$col$\_$index$\_$num$$ argument should be the number $5$ and the $$range$\_$lookup$$ argument should be the word $$FALSE$.$

Copy cell E$4$ and paste it into the range E$5$:E$27.$

Enter a formula in cell J$4$ that divides cell I$4$ by I$2.$ Place an absolute reference on cell I$2.$

Copy cell J$4$ and paste it into the range J$5$:J$27.$

Enter an IF function in cell M$4$ to determine if a store is a high growth exception. If the value in cell K$4$ 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 K$4>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.

Copy cell M$4$ and paste it into the range M$5$:M$27.$

Begin an IF function in cell N$4$ 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.

Define the $$logical$\_$test$$ argument of the IF function by using the AND function. The first logical test of the AND function should determine if cell F$4$ is equal to $10000.$ The second logical test of the AND function should determine if cell L$4$ is greater than $8.$ Cell L$4$ contains the weeks of supply which is a calculation that shows how fast the store is selling its current inventory. A high weeks of supply indicates that a store may have too much inventory relative to sales.

Define that $$value$\_$if$\_$true$$ argument of the IF function with the word $$Hold$.$ Based on the results of the AND function, if a store is $10,000$ square feet and the weeks of supply is greater than $8,$ the output of the function should be the word $$Hold$.$

Define the $$value$\_$if$\_$false$$ argument with the word $$OK$.$

Copy cell N$4$ and paste it into the range N$5$:N$27.$

Enter a nested IF function in cell O$4$ to identify the inventory status for each store. The inventory status will be determined based on the value in the Weeks of Supply column. The logical test of the first IF function should determine if cell L$4$ is less than $4.$ If this logical test is true, the output of the function should be the word $$Low$.$ Start a second IF function in the $$value$\_$if$\_$false$$ argument of the first IF function. The logical test of the second IF function should determine if the value in cell L$4$ is greater than $8.$ If this logical test is true, the output of the function should be the word $$High$.$ If this logical test is not true, the function should output the word $$Normal$.$ The word $$Normal$$ should be used to define the $$value$\_$if$\_$false$$ argument of the second IF function.

Copy cell O$4$ and paste it into the range O$5$:O$27.$

Enter an IF function in cell P$4$ that determines if a store should be identified as a priority delivery. Use the OR function to define the $$logical$\_$test$$ argument of the IF function. The first logical test of the OR function should determine if cell K$4$ is greater than $8\%.$ T

Copy cell P$4$ and paste it into the range P$5$:P$27.$

Enter an IF function in cell A$2$ that will alert the user if data has been added to the worksheet that exceeds the cell capacity in the SUM functions in the range G$2$:I$2.$ Use the ISBLANK function in the $$logical$\_$test$$ argument of the IF function. The ISBLANK function should determine if cell A$41$ is blank. If the output of the ISB