Please I keep receiving the following errors about filling the ranges. Please help me with step by step explanation. I need help with #2, 3,4,6, and 7; just how to fill the range in each case. Please provide me with step by step explanation. Below are the Excel copy and the result report. Thank you.

* AutoSave Off IL_EX19_EOM3-1_LOUQMANIDRISSOU_Report_2 - Search LOUQMAN IDRISSOU LI File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Comments Share X General # Insert Century Gothic 11 ~ AF = = 0 ale F WE AY e SX Delete Paste I MA Y === Conditional Formatting 2 Format as Table Cell Styles Styles $ % ) .00 soll 8 0 Number Sort & Find & Filter Select Analyze Sensitivity Data Format Y Undo Clipboard Font Alignment Cells Editing Analysis Sensitivity A1 VIX fx A D E E F G G H 1 J K L M M N 0 P C 24 B Copy a formula into a range. 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. . 5/10 25 26 27 In cell J5, 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 J6:J15 with the formula in cell J5, Filling the range without formatting. Create a formula using a function. X Copy a formula into a range. In the Inventory worksheet, the formatting from cell J5 should not be copied to the range J6:J15. 28 5/10 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. 29 30 31 In cell L5, insert a formula using the OR function that returns TRUE if the quality rating Icell K5) equals "A" or the reorder indicator (cell 15) equals "Y". Fill the range L6:L15 with the formula in cell L5, filling the range without formatting. Create a formula using a function. a X Copy a formula into a range. In the Inventory worksheet, the formatting from cell L5 should not be copied to the range 16:L15. 32 8. Jayden likes to track details about all the plants in inventory. 10/10 CALLY AL Graded Summary Report Documentation Inventory Ready 6 + 78% 27 0 ENG 1) O 9:43 AM 11/21/2021 AutoSave Off IL_EX19_EOM3-1_LOUQMANIDRISSOU_Report_2 - Search LOUQMAN IDRISSOU LI File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Comments Share X General # Insert Century Gothic 11 ~ AF F Conditional Formatting 2 Format as Table AY = = 0 ale WE e SX Delete Paste I A Y Sort & Find & Filter Select Sensitivity $ % ) .00 soll 8 0 Number Analyze Data Format Y Cell Styles Styles Undo Clipboard Font Alignment Cells Editing Analysis Sensitivity A1 A E E F G G H 1 J K L M M N 0 P C VIX fx B C Create a formula using a function. 2. In cell E5, insert a formula without using a function that multiplies the amount on hand (cell D5) by the wholesale price (cell B5). Fill the range E6:E15 with the formula in cell E5, filling the range without formatting. 9 5/10 10 11 12 Create a formula without using a function. X Copy a formula into a range. In the Inventory worksheet, the formatting from cell E5 should not be copied to the range E6:15. 13 5/10 14 15 16 3. In cell F5, insert a formula without using a function that multiplies the wholesale price (cell B5) by the markup amount (cell L3). Use an absolute reference to cell L3 in the formula. Copy the formula in cell F5 and paste only the formula and number formatting in the range F6:F15. Create a formula without using a function. X Copy a formula into a range. In the Inventory worksheet, the formatting from cell F5 should not be copied to the range F6:F15. 17 5/10 4. In column H. Jayden wants to display how long the plants have been in inventory, which is the number of days between the current date and the in stock date. 18 19 20 In cell H5, insert a formula without using a function that subtracts the in stock date (cell G5) from the current date (cell B3). Use an absolute reference to cell B3 in the formula. Fill the range H6:H15 with the formula in cell H5, filling the range without formatting. Create a formula without using a function. X Copy a formula into a range. In the Inventory worksheet, the formatting from cell H5 should not be copied to the range H6:H15. 21 10/10 5. In column I, Jayden wants to display a reminder to reorder plants if the store has 10 or fewer plants on Graded Summary Report Documentation Inventory | Ready 6 + 78% 27 0 ENG 1) O 9:43 AM 11/21/2021 6 AutoSave On IL_EX19_EOM3-1_LOUQMANIDRISSOU... - Last Modified: 22m ago Search LOUQMAN IDRISSOU File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Comments Share X General Calibri ~ AI = = 11 # Insert abe AY @ e $ % ) 2X Delete Paste B I U A Conditional Formatting Format as Table Cell Styles Styles Analyze Data Sensitivity Sort & Find & Filter Select Editing Format Undo Clipboard Font Alignment Number Cells Analysis Sensitivity L5 =OR(K5="A",15="Y") A L M N o P 1 2 3 Date D E F G H J K Lawn and Garden Department Store 124 5/5/2021 Markup Wholesale On Hand Retail In Stock Days in Quality Price Sold by On Hand Value Price Date Inventory Reorder? Discount? Rating 10.50 each 20 $ 210.00 $ 14.18 4/2/2021 33 FALSE A 15.09 each 10 $ 150.90 $ 20.37 3/12/2021 54 Y FALSE B 5.89 each 15 $ 88.35 $ 7.95 3/18/2021 48 N TRUE B 30.59 flat 9 $ 275.31 $ 41.30 4/5/2021 30 FALSE A 1.24 each 10 $ 12.40 $ 1.67 4/17/2021 18 FALSE 32.59 flat 12 $ 391.08 $ 44.00 3/24/2021 42 TRUE B 24.60 flat 15 $ 369.00 $ 33.21 4/28/2021 7 N FALSE 4.38 each 15 $ 65.70 $ 5.91 3/8/2021 58 TRUE A 5.23 each 25 $ 130.75 $ 7.06 3/10/2021 56 TRUE A 9.95 each 10 $ 99.50 $ 13.43 3/20/2021 46 FALSE B 24.34 flat 8 $ 194.72 $ 32.86 3/1/2021 65 FALSE B Total $1,987.71 1.35 Garden Club? TRUE TRUE FALSE TRUE TRUE 4 Plant Type 5 Rose bush 6 Hydrangea 7 Daylily 8 Petunia 9 Daisy 10 Geranium 11 Impatiens 12 Lavender 13 Hosta 14 Peony 15 Pansy 16