Analyze the claim made by the Condos at Summit Ridge Mountain.
Description
Scenario/Summary
You are becoming more confident in your new position at
Summit Ridge Mountain Resort. You are still meeting new coworkers and slowly
but surely being asked to use more of your Excel skills for different
departments at the resort. The manager handling sales for all of the condos in
the Summit Ridge Mountain Village needs some help with his sales analysis. This
report needs to clearly list and summarize all new loans for condominium sales
and incorporate advanced functions and state loan statistics. In addition, you
have been asked to investigate the claim made by the financing company to
determine the true track record of the company in selling condos for the asking
price. This will require advanced analysis techniques.
Deliverables
After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week3_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week3_Lab.xlsx.
|
Lab 3 Luxury
Condo Sales | ||||
|
Step |
Task |
Points
Possible |
Points
Received |
Comments |
|
1 |
Condo Sales Worksheet |
|||
|
1a |
Calculate % of asking price |
2 |
||
|
1b, c |
Format worksheet (column width, headings, colors,
data types) |
4 |
||
|
2 |
Loan Data Worksheet |
|||
|
2a |
VLOOKUP for Interest Rate and Down Payment |
3 |
||
|
Calculate Amount Financed |
2 |
|||
|
PMT function for Monthly Payment and functions
for loan statistics |
4 |
|||
|
2b, c, d |
Format worksheet (column width, headings, colors,
data types) |
2 |
||
|
3 |
Sort and Create Summary Report and Chart |
|||
|
3a, b |
Create Sorted Data worksheet |
2 |
||
|
3c |
Sort and Order Sorted Data |
2 |
||
|
3d,e |
Create a summary report and a column chart |
3 |
||
|
4 |
Filter the Data |
|||
|
4a |
Create Filtered Data worksheet |
2 |
||
|
4b, c, d |
Filter the Data |
3 |
||
|
5 |
Conditional Formatting |
|||
|
5a, b |
Create Conditional Format worksheet and Insert a
table |
2 |
BIS 155 Week 3 iLab | Summit Ridge Mountain Resort
Related ProductsTags: BIS 155 Week 3 iLab, BIS155 Week3 iLab, BIS 155 Week 3 iLab Summit Ridge Mountain Resort, BIS 155 Week 3 Summit Ridge Mountain Resort, BIS 155 Week 3 iLab selling condos. MessageAll members who signed up before 2023 are requested to register again. | |