5. In column I, Jayden wants to display a reminder to reorder plants if the store has 10 or fewer plants on hand. In cell I5, insert a formula using the IF function that tests whether the number of plants on hand (cell D5) is less than or equal to 10. If the store has 10 or fewer plants on hand, display "Y" in cell I5. Otherwise, display "N" in cell I5. Fill the range I6:I15 with the formula in cell I5, filling the range without formatting. 6. Jayden puts plants on sale if they have been in inventory for 40 days or more and the store is not reordering more plants of that type. In column J, Jayden wants to display whether to put a type of plant on sale based on these criteria. In cell J5, insert a formula using the AND function that returns TRUE if the reordering indicator (cell I5) is equal to "N" and if the days in inventory (cell H5) is greater than 40. Use the Fill Handle to fill the range J6:J15 with the formula in cell J5, filling the range without formatting. 7. Jayden rates plants as A, B, or C depending on their quality, with "A" being the highest rating. If a plant type has an "A" rating or is being reordered to fill inventory, Jayden offers it at a discount to the store's garden club. In column L, Jayden wants to display whether to offer a type of plant to the garden club based on these criteria. In cell L5, insert a formula using the OR function that returns TRUE if the quality rating (cell K5) equals "A" or the reorder indicator (cell I5) equals "Y". Fill the range L6:L15 with the formula in cell L5, filling the range without formatting. 8. Jayden likes to track details about all the plants in inventory. In cell C18, enter a formula using the COUNTA function that counts the number of plant types (range A5:A15). 9. In cell C19, enter a formula using the AVERAGE function that averages the on hand amounts (range D5:D15). 10. In cell C20, enter a formula using the ROUNDUP and AVERAGE functions that averages the retail prices (range F5:F15) and rounds the result up to 1 decimal place. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.   Final Figure 1: Inventory Worksheet

L A B D E F G H Lawii anu Garden Departmen K L 23 Store 124 3 Date 5/5/2021 Markup 1.35 On Hand 4 Plant Type Wholesale Price Sold by On Hand Value Retail Price In Stock Date 5 Rose bush 10.50 each 20 $ 210.00 $ 14.18 4/2/21 Days in Inventory 33 Quality Garden Reorder? Discount? Rating Club? A 6 Hydrangea 15.09 each 10 $ 150.90 $ 20.37 3/12/21 54 B 7 Daylily 8 Petunia 5.89 each 15 $ 88.35 $ 7.95 3/18/21 48 B 30.59 flat 9 $ 275.31 $ 41.30 4/5/21 30 A 9 Daisy 1.24 each 10 $ 12.40 $ 1.67 4/17/21 18 C 10 Geranium 32.59 flat 12 $ 391.08 $ 44.00 3/24/21 42 11 Impatiens 24.60 flat 15 $ 369.00 $ 33.21 4/28/21 7 12 Lavender 4.38 each 15 $ 65.70 $ 5.91 3/8/21 58 13 Hosta 5.23 each 25 $ 130.75 $ 7.06 3/10/21 56 14 Peony 9.95 each 10 $ 99.50 $ 13.43 3/20/21 46 CAABB + 15 Pansy 24.34 flat 8 $ 194.72 $ 32.86 3/1/21 65 Total $1,987.71 16. 17 18 Number of items: 19 Average number on hand: 20 Average price: 21