Snackin-Pak
Transaction Growth
Orders	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total	Most Ordered	Least Ordered
Fit Bits	305	380	555	494	569	1026	1302	1408	1047	954	712	761	9513	1408
Great Grains	67	547	897	1097	826	473	943	1122	1501	1248	1262	1629	11612	1408
Munchie Madness										112	129	181	422	1408
Sweet Stuff	136	256	482	919	817	1150	790	891	1274	1143	778	540	9176	1408
Total Orders	508	1183	1934	2510	2212	2649	3035	3421	3822	3457	2881	3111	30723	1408
Average Monthly Fulfillment
Inventory Tracker
Components	Jan	Feb	Mar										Total	Peak Inventory	Lowest Stock
Bars/Clusters	5728	3090	4935	2126	6198	2032	2660	2503	5592	6152	2149	5153	48318		2032
Popcorn	3826	2514	5097	2488	3277	2906	2940	5922	2162	5074	5490	2739	44435		2162
Baked Goods	1933	2532	3292	5650	2818	2030	1622	5682	6366	6975	3679	2838	45417		1622
Chips/Pretzels	1893	3273	1673	6576	6315	4978	4926	1561	3937	1960	6461	6767	50320		1561
Nuts	4202	3538	1994	2709	1700	4433	2155	2943	3260	6185	5208	4863	43190		1700
Granola	1922	4553	6838	1543	6816	3585	3366	2661	4641	2045	3238	2991	44199		1543
Dried Fruit	6800	2951	2834	3222	2682	1996	4074	4999	3380	1763	6887	6657	48245		1763
Total Inventory	26304	22451	26663	24314	29806	21960	21743	26271	29338	30154	33112	32008	324124		21743
Average Monthly Inventory	3758	3207	3809	3473	4258	3137	3106	3753	4191	4308	4730	4573	46303

I am a bit puzzled in this and what I am suppose to do. Any help is appreciated! This work is done on excel.

2. The data section called Transaction Growth shows how many boxed sets were sold each month. Keith entered a formula into the range O6:O10 to calculate the highest amount of each set sold over the course of the year. He notices that all of the values in the range are 1,408, even though more boxed sets than this were sold in some months.

Edit the formula in cell O6 so that it uses relative references instead of absolute references for the range B6:M6, and then copy the formula from cell O6 to fill the range O7:O10 without formatting

3. In cell P6, create a formula using the MIN function to find the lowest number of the Fit Bits boxed set ordered (the range B6:M6). Copy the formula from cell P6 to fill the range P7:P10 without formatting.