Can you help me woth formulas please? thank you
it goes all the way to 690
Make sure you are in the Data Set worksheet. Beginning in row 25, you see the raw data. Note that the currency is stated as Euros, not US dollars, since ARK Equipment is based in Belgium. ARK Equipment LLC would like to look at sales by market segment. The area A5:C11 has been set up to focus on this part of the analysis. 1. In cell B6, enter a function to calculate the total number of orders. In cell C6, enter a function to calculate the total Euro sales value of all orders. 2. In cell B7, enter a function to calculate the total number of orders from the Channel Partners market segment. Make sure to use appropriate cell referencing. Copy this function down to calculate the number of orders for the other market segments. 1 3. In cell C7, enter a function to compute the total Euro sales for the Channel Partners market segment. Make sure to use appropriate cell referencing. Copy this function down to calculate the total Euro sales for the other market segments. ARK Equipment LLC would also like to look at average profit by products. The area A15:C22 has been set up to focus on this part of the analysis. 4. In B17, enter a function to count the number of Punching Press products sold. Make sure to use appropriate cell referencing. Copy this function down for the rest of the products. 21 CHOW 5. In C17, enter a function to calculate the average profit for the Punching Press product. To do this, you cannot use a simple AVERAGE function. You will need to first determine the total profit for the given product. Then divide this value by the number of orders for that product. Make sure to use appropriate cell referencing. Copy this function down for the rest of the products. (If you have calculated this correctly, the value in C17 should be 90,661.) 6. Now, enter the appropriate functions in cells G15:G19 to calculate the requested measure as noted in F15:F19. 7. Now switch to the Annual Comparison worksheet. Here, you need to display the Average Profit for each product for 2019-20, as calculated above. In cell D7, this should be equal to the value of cell C17 in the Data Set worksheet. Once you have done this, copy the formula in cell D7 down for the rest of the products. I 8. On the Annual Comparison worksheet, in cell B13, enter a function to calculate the sum for all products in 2015-2016. Copy this function across for the other years. Part 2: Formatting - Enhance the Appearance of the Worksheet 1. On the Data Set worksheet, merge and center the worksheet headings found cells A1 and A2 across columns A - L. Increase the font size of the row 1 heading to 18 pt. Bold this heading. Increase the font size of the row 2 heading to 16 pt. Deplacemein Warith van name Part 2: Formatting - Enhance the Appearance of the Worksheet 1. On the Data Set worksheet, merge and center the worksheet headings found in cells A1 and A2 across columns A - L. Increase the font size of the row 1 heading to 18 pt. Bold this heading. Increase the font size of the row 2 heading to 16 pt. 2. Replace "your name" in row 2 with your own name. 3. Right-justify the column headings in columns E through L. 4. Format the values in C6:C11, C17:022 and G15:G19 to display Euro currency datatype with zero decimal places. 5. On the Annual Comparison worksheet, format the values in B7:013 to display Euro currency data type and zero decimal places. Part 3: Add a Chart 1. On the Data Set worksheet, add a column chart to show the average profit for each product. The chart should look similar to this: MAGMATICA D E G Sales Value Order Counts 570 93 96 290 92 92 1 ARK Equipment LLC 2 Prepared by Your Name 3 4 5 Market Segment Analysis 6 Total For All Orders 7 Channel Partners 8 Enterprise 9 Government 10 Midmarket 11 Small Business 12 13 14 15 Sales by Products 16 Products 17. Punching Press 18. CNC Lathe 19 CNC Turret Punch Press mr 20 Milling Machine 21 Gear Grinding Machine milz 22 Beveller 23 69,888 249,010 Number of Orders per Product Avg. Profit 0 Average COGS Median COGS Maximum Order Profit Minimum Order Profit Range of Profit Values Units Sold Discount Band None None 2 4 None 5 2 24 Segment 25 Government 25 Midmarket 2 Midmarket 28- Channel Partners 29 Government 30 Channel Partners 31 Midmarket 32 Enterprise 32. Small Business 34 Government 35 Enterprise 36 Midmarket Duti Set Country Germany Germany Germany Canada France Germany Mexico Canada Mexico Germany Canada United States of America Annual Comparison Product CNC Lathe CNC Lathe CNC Turret Punch Press CNC Turret Punch Press CNC Turret Punch Press CNC Turret Punch Press CNC Turret Punch Press CNC Turret Punch Press CNC Turret Punch Press CNC Turret Punch Press CNC Turret Punch Press CNC Turret Punch Press None None None None None None None Manufacturing Price 65.400 C5,400 C4,350 64,350 4,350 (4,350 4,350 C4,350 4,350 C4,350 4,350 C4,350 Sale Value 12.900 (12,900 8,500 8,500 C8,500 8.500 8,500 C8,500 8,500 8,500 (8,500 8.500 10 None None + Ready XV c G H 1 1 ARKE LLC Prepared by Your Name Sesue Market Set Analysis Total For Ni Orden Channel Parthen Esteren Cove Moment Small Busine Order Counts 570 93 36 250 92 92 1 69,880 49,010 Number of Ondere per Pro Avu. Prote 0 S by Product Pro 7 Punching CNC the 11 CNC Turret Punch 20 MA Makine T1 Grinding Machine 22ever Average COGS Medan COGS Maximum Order Profit Minimum Order Profit Range of protes 26 Sena 25 G 26 Meman 24 M 21 Porta 29 1 One Pas ma CY Germ GY German Canada DO Band None None None vo Units sold 3 2 Data) ing 10 3/1/23 mi 1/20 1/1/20 6/100 5 2 . 10 German Maite Canada MO Product CNC the CNC lathe CNC Turret Punchres CNC Turunch CNC Turret Punch Press CNC Tove Punch CNC turret Punch ONT Punch Press CNC Turunch CNC Turches CNC Twen Preis CNG Ture Ponch M MRI WMN Mil Machine Manting Price C5,400 C5,400 E MacBook Air SUMIF Alx G 0 $ H A 22 de Gover 14 Anton Low LON Low Free Canada Link Unika United UMAA we Me 29 28 18 15 12 12 22 10 C, 500 CISO 1 CIT 100 127,400 Low 112.00 France Canada Canada 50.050 CS150 61,435 41,225 EST C65.73 CH E MacBook Air SUMIF Alx G 0 $ H A 22 de Gover 14 Anton Low LON Low Free Canada Link Unika United UMAA we Me 29 28 18 15 12 12 22 10 C, 500 CISO 1 CIT 100 127,400 Low 112.00 France Canada Canada 50.050 CS150 61,435 41,225 EST C65.73 CH
