2024 Can someone complete by deadline Assignment Help
NEED DONE IN 2 HRS Question 2 My supervisor Sally likes my charts however she instructs me to 2023
NEED DONE IN 2 HRS Question 2. My supervisor, Sally, likes my charts; however, she instructs me to take more time planning my charts before creating the actual chart itself. Why is planning the creation and development of a chart so important? My supervisor, John, ask me to chart some comparative data but my first attempt with a column chart did not illustrate the data as well as he would have liked. What type of chart is ideal and best to illustrate comparative data of individual items in a data series and why? My supervisor, Jessica, asked me to project future data trends using a chart. Most of the data is associated with sales and depending on the nature of what is sold, data either fluctuates or increases quickly. What chart feature added to a column chart can help project these data trends and why? My supervisor, Thomas, asked me to add some creativity with color and enhancements on all charts used during weekly meetings. What should I consider to avoid being overly creative and why is this important? Question 3. Group all of sheets (1-5) at one time Group only sheets 2-4 Group only sheets 1, 3, and 5 Part 2 (20 points) 3D references Next, you’d like to total up the values of cell A1 from sheets 2, 3, and 4 onto a summary sheet (sheet 5). Sheets 2, 3, & 4 are named “East Warehouse”, “Central Warehouse”, and “West Warehouse” respectively. Explain what formula you would enter in to add up cell A1 from these sheets. After entering the formula, explain how you could repeat this for cells A2:A20 on the summary sheet (sheet 5). Question 4. John Bob Ruth Using the three worksheets shown above, you will create a new worksheet called “2014” which will consolidate and summarize the information from the stores of John, Bob, and Ruth. The new worksheet will look similar to what you see below. 2014 Part 1. Write out a 3-D formula using the SUM function as if it were in (Cell B2) of worksheet “2014” that will calculate the Total Shirt Sales for John, Bob, and Ruth. Write the formula so that it may be copied to the month of February (Cell B3) without modification. Part 2. Write out a worksheet reference formula without the SUM function as if it were in (Cell C2) of worksheet “2014” that will calculate the Total Pant Sales for John, Bob, and Ruth. Write the formula so that it may be copied to the month of February (Cell C3) without modification. Part 3. Now that there are Total Shirt Sales and Total Pant Sales for January and February in the “2014” worksheet, it is time to calculate CLOTHING TOTAL in all four worksheets (“John”, “Bob”, “Ruth”, and “2014”). Explain how you will complete this step without retyping the formula in each worksheet. Discuss the advantages of doing it this way and describe any pitfalls that might take place. Part 4. Write out a formula using the SUM function as if it were in (Cell D2) of ALL worksheets that will calculate the CLOTHING TOTAL. Write the formula so that it may be copied to the month of February (Cell D3) and to the CLOTHING TOTAL YEARLY TOTAL (Cell D4) without modification. Also, write out a formula using the SUM function as if it were in (Cell B4) of ALL worksheets that will calculate the YEARLY TOTAL for Total Shirt Sales. Write the formula so that it may be copied to YEARLY TOTAL for Total Pant Sales (Cell C4) without modification. Part 5. You are interested in viewing the contents of all four worksheets (John, Bob, Ruth, and 2014) side-by-side on the screen. Describe the steps that will arrange the worksheet tabs this way and discuss the advantages of doing this. Question 5.