4. The worksheet will also show the average number of orders fulfilled for each column in the section above. In cell B12, create a nested formula using the AVERAGE and ROUND functions to first find the average number of clothing sets sold in January (the range B6:39), and then round the answer to 0 digits. Copy the formula from cell B12 to the range C12:N12. File Home Page Layout Fermulas Data Rey We Help Acrobat X IS Cathe ' ' 3 Wrap Text Share BI- A- Menge a Center - $ % 9 Conditional formats Chipboard Font Sort Find a Alt 010 X CH des R D 1 2 L M N lan Feb 337 Mar 451 402 24 260 Ape 538 373 May 1057 232 un 147 Nov 1909 Aug 2146 315 Sep 1790 463 1142 Dec 812 1990 555 Oct 961 154 214 1107 2639 28 632 660 1699 936 19 Tota 12742 529 1539 9785 2015 50 Most Ordered Least Ordered 2147 2 13 237 809 214 1269 3733 612 828 1759 1003 2872 7 445 516 62 2731 1269 373 809 582 3005 1073 3329 3209 211 566 616 586 632 957 1241 1070 1110 4 Transaction Growth 5 Orders 6 Bizzy Car 7 High Society 8 Retro Ft 9 Weekend Wanderer 10 Total Orders 11 Average Monthly 12 Fulfillment 13 14 inventory Tracker 15 Components 16 Shirt/Blouse 17 Pants/Shorts 18 Dress/Skirt 19 Sweater/Vest 20 Socks 21 Underwear 22 Accessories 23 Total Inventory 24 650 683 767 7354 lan 2717 3226 3292 1567 Aug 1657 2374 Oct 4042 4527 Nov 2417 6865 Feb 6270 1500 4705 2643 2446 3603 4263 25433 lun 4204 5214 5019 3672 4731 6383 Mar 5158 6691 5221 6590 5900 2666 6197 38453 Apr 3580 68S 4328 3506 5999 2166 1881 28905 May 5974 3610 1757 4054 1414 3160 4187 26216 Jul 6511 5725 4118 6107 6888 4569 2311 36229 Sep 5867 1572 2422 6773 4533 2431 6719 30370 II ILI 1576 5097 6909 2000 30596 Dec 6280 3610 5504 2387 2021 1610 2036 23478 2661 Total Peak Inventory lowest Stock 57272 6511 2417 51862 1500 50658 6 1757 6773 1567 52031 2001 46121 60 1610 0502 6719 1881 350017 38453 18562 5499 262 4488 3727 30385 2273 4092 6100 6271 2413 656 IIIIII 18562 1990 29734 Graded Summary Report Documentation Product Lookup Orders D