BIS 155 WEEK 3 LAB 3 LATEST-DEVRY

Visit Below Link, To Download This Course:

http://bit.ly/2SJEcZU

BIS 155 Week 3 Lab 3 Latest-DeVry

BIS155

BIS 155 Week 3 Lab 3 Latest-DeVry

Lab Overview

Listen

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.

Listen

Deliverables

NOTE

Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructions.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

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
5c	Set up conditional formatting rules	2
5d	Sort by color	2
6	Pivot Table
6a	Select Data and Name Range of Cells	2
6b	Create Pivot table	3
6c	Formatting	2
7	Draw conclusion	5
	Documentation sheet completed	4
	Is the slogan a true statement?	4
Comment in Dropbox: What you learned from completing this Lab		5
TOTAL POINTS		60	0

Week 3 Grading Rubric

When submitting the workbook, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity. Make certain you compare your finished work with the Grading Rubric included here.

Listen

Lab Resources

Microsoft Office: Excel 2016

Options for Accessing Microsoft Excel 2016

1. Use a personal copy on your PC. You can request a copy of Microsoft Office 2016 via the Student Software Store icon on the Course Resources page.
2. If you are a MAC user, click to read the MAC User Information.
3. If you do not have Excel 2016 installed locally, then access the software by going to the Course Resources page, Lab Resources section, and click the Virtual Lab Citrix icon.

Listen

Lab Steps

Listen

Preparation

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.

Listen

Begin: Opening and Saving

Download the spreadsheet Week 3 Lab – Summit Ridge Mountain Resort Student.xslx. 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,

• open the workbook in Excel 2016; and
• in Excel, click File then Save as and rename it as lastname_first initial_Week3_Lab.xlsx (Jane Doe would save the file as Doe_J_Week3_Lab.xlsx).

Listen

Step 1: Add Formulas, Functions, and Formatting to Condo Sales Data Worksheet

Now we need to begin working on the worksheet 1. Let’s begin by renaming sheet 1 to Condo Sales Data.

1. Create the formula needed to calculate the percent of asking price.

Column H: Selling Price/ Asking Price

1. Format the data on this sheet for currency, percent, and so forth.
2. Format the title rows and center them across the column selection. Format the column headings appropriately.

An example of what your Condo Sales worksheet might look like isbelow.