5. The data section called Inventory Tracker shows how many of each boxed set component has been ordered by the company each month. Use AutoFill with the values in the range B15:015 to extend the series of months to the range E15:M15. 6. 7. In cell 016, create a formula using the MAX function to find the peak inventory number for the Bars/Clusters component (the range B16:M16). Copy the formula from cell 016 to fill the range 017:023 without formatting. Switch to the Product Lookup worksheet. This worksheet shows information on the boxed sets and the components that come in each set. The last person to work on the workbook mistakenly pasted "one hundred" into cell B10, which created an error in cell B14. Change the value in cell B10 from "one hundred" to 100 to eliminate the error message in cell B14. 8. The data section called Boxed Set Information is incomplete. In cell B16, create a formula using the SUM function to find the total calories in the Munchie Madness boxed set by totaling the calories from Baked Goods (cell B5), Bars/Clusters (cell B6), Granola (cell B9), and Popcorn (cell B11). In cell C14, create a formula using the COUNTA function to count the number of components in the Fit Bits boxed set (the range B20:F20). Copy the formula from cell C14 to fill the range C15:C17 without formatting to count the number of components for the rest of the boxed sets. 9. The data section called Product Information Lookup uses a mix of user input cells, output cells, and calculated cells to display various information for a single boxed set. Format the section as follows: Apply the Input cell style to cell 15. Apply the output cell style to the range 16:18. Apply the Galculation dell style to cena a b. B E F G H J K L M N O P A 7/5/2021 13:46 AWNIN Jan Feb Jul Oct Nov Dec Most Ordered Least Ordered Mar 555 Apr 494 May 569 Jun 1026 Aug 1408 Sep 1047 Total 9513 305 380 1302 954 712 761 1408 4 Transaction Growth 5 Orders 6 Fit Bits 7 Great Grains 8 Munchie Madness 9 Sweet Stuff 10 Total Orders 67 547 897 1097 826 473 943 1122 1501 1248 1262 1629 11612 1408 1408 112 129 422 181 540 136 256 482 919 817 1150 790 1274 1143 9176 1408 891 3421 778 2881 508 1183 1934 2510 2212 2649 3035 3822 3457 3111 30723 1408 11 Jan Mar 4935 5097 Total 48318 Peak Inventory Lowest Stock 2032 6198 2032 2660 2503 2126 2488 6152 5074 3277 2940 44435 1933 5650 2818 Average Monthly 12 Fulfillment 13 14 Inventory Tracker 15 Components 16 Bars/Clusters 5728 17 Popcorn 3826 18 Baked Goods 19 Chips/Pretzels 1893 20 Nuts 4202 21 Granola 1922 22 Dried Fruit 6800 23 Total Inventory 26304 24 Average Monthly Documentation 6975 Feb 3090 2514 2532 3273 3538 4553 2951 3292 1673 1994 2906 2030 4978 4433 5592 2162 6366 3937 3260 5922 5682 1561 2943 1622 4926 2155 6576 1960 6185 2149 5490 3679 6461 5208 3238 6887 33112 5153 2739 2838 6767 4863 2991 6657 32008 6315 1700 6816 2682 29806 2709 1543 2162 1622 1561 1700 1543 45417 50320 43190 44199 48245 324124 6838 3366 4641 3585 1996 4074 2834 26663 2661 4999 26271 3222 24314 1763 2045 1763 30154 3380 29338 22451 21960 21743 21743 ndows Product Lookup Orders Fintar