Which of the following structures of the eye is responsible…
Questions
Which оf the fоllоwing structures of the eye is responsible for producing the аqueous humor?
Summit Outfitters is а regiоnаl оutdоor equipment аnd apparel retailer with store locations across the United States. On Monday at 9am, you received this email from your supervisor: "Attached is the Excel file containing sales data from the past few years. Please use PivotTables and PivotCharts to analyze the data in order to answer the following questions: Annual Sales: What are the annual Sales of Equipment by Region? -- Also create a PivotChart from the PivotTable. Equipment is one of the product categories. Discount Analysis: What are the Average Discount % for order with promotions applied breakdown by SalesRep and Product Category? -- The PromoApplied field indicate whether the discounted was applied to that order. The analysis should include only orders where the promotion was applied. Customer Analysis: What are total Revenue generated by each customer in 2024? For each customer, please also list the total units sold and Average Gross Margin %. I need your analysis by noon so I can review it before presenting to the board this afternoon. Also, you're coming with me to this presentation and be prepared to answer questions based on your analysis." Attachment: SOSD2326.xlsx Please complete the following steps: Download and open the Attachment file. Save the file using a meaningful file name. (2 points) Go through the data in each column and comprehend what data in each one represents. Using data from the provided data file, create ONE PivotTable that can be used to answer the questions for EACH analysis. There should be THREE PivotTables overall, i.e., one for each analysis listed above. For Analysis 1, annual sales, please also create a PivotChart (based on the PivotTable) to visually compare the information. For Analysis 2, show the average discount % by SalesRep and ProductCategory, and limit the analysis to those where the PromoApplied is Yes. For Analysis 3, customer analysis, the PivotTable should include CustomerName along with the total revenue generated by each customer, total units sold to that customer, and average gross margin %. Add a Slicer or a Filter that can be used to show the information specifically for each Region. Sort data in the PivotTable to help with your analyses. Each PivotTable should... contain all required information (5 points) be well structured in order to easily locate information and provide accurate and complete answer(s) to the question. (5 points) use clear and meaningful title, headings and labels (2 points) utilize appropriate number format (2 points) be placed on its own worksheet with an appropriate worksheet (i.e., tab) name. (2 points) The PivotChart (for Analysis 1) should be on the same worksheet as the PivotTable. Make sure to use an appropriate chart type with complete and meaningful chart elements (e.g., chart title, data labels, legend keys, etc.) and use clear and appropriate titles and labels without being too cluttered. (5 points) Don't for get to save the file before submitting.