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 35, insert a formula using the AND function that returns TRUE if the reordering indicator (cell 15) is equal to "N" and if the days in inventory (cell H5) is greater than 40. Use the Fill Handle to fill the range 36:115 with the formula in cell 35, 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. 8. 9. In cell L5, insert a formula using the OR function that returns TRUE if the quality rating (cell KS) equals "A" or the reorder indicator (cell 15) equals "Y". Fill the range L6:L15 with the formula in cell LS, filling the range without formatting. 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). 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 FS:F15) and rounds the result up to 1 decimal place. Your whe