Options for Accessing Microsoft Excel 2016
You will be using Microsoft Excel 2016 for this lab.
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.
Download the spreadsheet Week 6 Lab – Summit Ridge Mountain Resort Student.xslx. (Links to an external site.)Links to an external site. You will be prompted to save the file. Click yes.
Open the saved file from your Download folder on your computer.
Note: If you are using the Remote Lab environment, you will need to follow the instructions for uploading the file. These instructions can be found on the Lab page when you click on the Lab icon on Course Resources.
To save the spreadsheet with a new file name,
It is time to build the formulas needed to complete the income statement. Begin working on the Income Statement worksheet and complete formulas for all of the cells marked in gray.
Income Statement
Now that the Income Statement is complete, begin to address the questions about the condo rentals and ski lift tickets.
One-Variable Data Tables
Once the one-variable data tables are complete, begin to address the questions about the X Games tickets sold.
You addressed quite a few questions. Now it is time to create a Scenario Summary.
Completed Scenarios
Select the Warming Hut Sales Worksheet. You notice the data are not formatted or organized well.
Clean up the formatting of your Excel workbook, taking into account professional appearance.
The Minimum Requirement (per the Grading Rubric)
Save your Excel file. Make sure you are aware as to where your files are physically saved. Saving your file often is good practice (Ctrl + s).
Your Excel file should contain seven 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_Week6_Lab.xlsx.