Management at Summit Ridge Mountain Resort is very pleased with your initial report. This week, management has asked that you add to the prior analysis and incorporate some visual images concerning the Village Shop sales. This new analysis will require the use of new formulas, new functions, and several charts to graphically depict the report findings. This updated Excel workbook will be used for a presentation to the board of directors. Submit one workbook. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity. File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week2_Lab.xlsx. Make certain you compare your finished work with the Grading Rubric included here. Options for Accessing Microsoft Excel 2016 This lab will use Microsoft Excel 2016. Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab. Please do not rely solely on the hands-on exercise videos to complete this week’s lab. The videos provide detailed examples, walking you through the hands-on exercises. Applying the hands-on exercise examples will provide both practice and instruction of what to complete. For example, your final assignment file should include six worksheets (Documentation, Sales Data, Daily Item Totals, Total Items Bar Chart, Percent of Sales Pie Chart, and Profits by Da
y Line Chart). Please open the Week 1 Lab submitted and make any corrections or modifications. Save this new Excel workbook as Doe_J_Week2_Lab.xlsx. Follow the lab steps to create formulas, utilize functions, and add charts to graphically depict the sales over time and by product. Click on the Sales Data worksheet. We need to see all of the hidden data, so unhide all hidden columns. Once you can see all the hidden data, we need to select data to copy to a new worksheet. Sort your data in A to Z order. Select the accessories data in column A, hold your control key down, and then select the daily sales data in columns D through M. Copy this selected data to a new sheet. Create daily totals using the SUM function for each day and for each item. Make these pronounced by adding a bold font and some color formatting. Cleanup the formatting of your Excel workbook, taking into account professional appearance. The Minimum Requirement (per the Grading Rubric) Remember, professional appearance doesn’t only promote better readability of your report but represents you as a professional. Save your Excel file. Saving your file often is good practice (Ctrl + s). Your Excel file should contain six worksheets. Submit one workbook. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity. File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week2_Lab.xlsx.