BIS155 Lab 3 Devry Condos at Summit Ridge Mountain data analysis Complete Lab 3: Summit Ridge Mountain Resort: Luxury Condo Sales. Basic instructions are i
BIS155 Lab 3 Devry Condos at Summit Ridge Mountain data analysis Complete Lab 3: Summit Ridge Mountain Resort: Luxury Condo Sales. Basic instructions are in the Lab Overview page. You will be required to use your skills from the text and tutorials to complete the lab. Be sure to watch and work through the hands-on exercise videos in the lesson for guidance on completing this assignment.
COURSE: BIS155 Lab 3
Don't use plagiarized sources. Get Your Custom Essay on
BIS155 Lab 3 Devry Condos at Summit Ridge Mountain data analysis Complete Lab 3: Summit Ridge Mountain Resort: Luxury Condo Sales. Basic instructions are i
For $10/Page 0nly
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeSTEP 1a: Calculate % of asking price on Condo Sales Wkst
3.0 pts
Full Marks
0.0 pts
No Marks
3.0 pts
This criterion is linked to a Learning OutcomeSTEP 1b, c: Format Condo Sales worksheet (column width, headings, colors, data types)
3.0 pts
Full Marks
0.0 pts
No Marks
3.0 pts
This criterion is linked to a Learning OutcomeSTEP 2a: Loan Data Worksheet: VLOOKUP for Interest Rate
4.0 pts
Full Marks
0.0 pts
No Marks
4.0 pts
This criterion is linked to a Learning OutcomeSTEP 2a: Loan Data Worksheet: VLOOKUP for Down Payment
4.0 pts
Full Marks
0.0 pts
No Marks
4.0 pts
This criterion is linked to a Learning OutcomeSTEP 2a: Loan Data Worksheet: Calculate Amount Financed
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 2a: Loan Data Worksheet: PMT function for Monthly Payment
4.0 pts
Full Marks
0.0 pts
No Marks
4.0 pts
This criterion is linked to a Learning OutcomeSTEP 2a: Loan Data Worksheet: COUNT, MIN, MAX & SUM to complete loan statistics
3.0 pts
Full Marks
0.0 pts
No Marks
3.0 pts
This criterion is linked to a Learning OutcomeSTEP 2b, c, d: Format data types (percents, currency, etc.)
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 2b, c, d: Format page headings with font, color, size
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 2b, c, d: Format Loan Term Data and statistics with borders, color, etc. to separate it from the rest of the worksheet
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 3: a,b: Create Sorted Data worksheet
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 3c: Sort data by selling agent and then asking price
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 3d, e: Create a summary report using subtotals and outline levels
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 3d, e: Create a column chart to compare asking price vs selling price by agent
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 4a: Create new worksheet with Sales Data and name Filtered Data
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 4b: Convert filtered data into table
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 4d,e: Filter data to show only sales by Langston in Pagosa
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 5a,b: Create Conditional Format worksheet and Insert a table
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP 5c: Set up conditional formatting rules for the % of Asking Price column
4.0 pts
Full Marks
0.0 pts
No Marks
4.0 pts
This criterion is linked to a Learning OutcomeSTEP 5d: Sort data smallest to largest
2.0 pts
Full Marks
0.0 pts
No Marks
2.0 pts
This criterion is linked to a Learning OutcomeSTEP6a: Pivot Table: Select Data and Name Range of Cells (A3 through J33)
3.0 pts
Full Marks
0.0 pts
No Marks
3.0 pts
This criterion is linked to a Learning OutcomeSTEP6b: Pivot Table: Insert Pivot table using Named Range
3.0 pts
Full Marks
0.0 pts
No Marks
3.0 pts
This criterion is linked to a Learning OutcomeSTEP6c: Pivot Table: Create the Pivot Table with selling agent (row), City (column), and Percent asking price as values
3.0 pts
Full Marks
0.0 pts
No Marks
3.0 pts
This criterion is linked to a Learning OutcomeSTEP6d: Pivot Table: Change values to AVERAGE and apply formatting to cells and all labels
4.0 pts
Full Marks
0.0 pts
No Marks
4.0 pts
This criterion is linked to a Learning OutcomeSTEP6e: Pivot Table: Apply data bars, hide field headers, rename and move sheet
3.0 pts
Full Marks
0.0 pts
No Marks
3.0 pts
This criterion is linked to a Learning OutcomeSTEP 7: Documentation sheet completed
4.0 pts
Full Marks
0.0 pts
No Marks
4.0 pts
This criterion is linked to a Learning OutcomeSTEP 7: Is the slogan a true statement?
4.0 pts
Full Marks
0.0 pts
No Marks
4.0 pts
This criterion is linked to a Learning OutcomeCOMMENT: What you learned from completing this Lab
5.0 pts
Full Marks
0.0 pts
No Marks
5.0 pts
Calculator
Our features
We've got everything to become your favourite writing service
Money back guarantee
Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.
Confidentiality
We don’t share your private information with anyone. What happens on our website stays on our website.
Our service is legit
We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.
Get a plagiarism-free paper
We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.
We can help with urgent tasks
Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.
Pay a fair price
Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.