BIS155 Summit Ridge Mountain Resort Advanced Analysis

This criterion is linked to a Learning OutcomeSTEP 1a: Insert nested function for pet deposit

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 1b: Insert nested function for Remodeling Status

5.0 pts

This criterion is linked to a Learning OutcomeSTEP1c: Apply professional formatting to data, headers, etc.

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a, b: Use the INDEX and MATCH functions to give the rental price based on unit #

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 2c: Apply professional formatting to data, headers, etc.

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 3a: Loan Amortization: Complete Summary Calculations based on data provided in Input area

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 3a: Loan Amortization: Calculate Monthly Payment and Total Interest over the life of the loan

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 3b: Loan Amortization: In the loan amortization table., Use a date function for the Payment Date and financial functions for Interest and principle

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 3b: Loan Amortization: Calculate the ending and beginning balance and then copy the rows down to complete at least 10 months of the amortization schedule

5.0 pts

This criterion is linked to a Learning OutcomeSTEP3b: Calculate the ending and beginning balance and then copy the rows down to complete the amortization schedule

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 4a,b: Conditional Functions: On the Employee Satisfaction worksheet, calculate the average job satisfaction for each role in the company

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 4c, d: Conditional Functions: Calculate the Average salary for all employee types

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 4e: Conditional Functions: Calculate Number and Average salary for Sales & Marketing Directors with >=4 Satisfaction

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 4g: Conditional Functions: Apply Count and average salary to Managers

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 4h: Conditional Functions: Create a Pivot Table based on employee role to compare satisfaction and salary averages

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 5a,c Add and complete a Documentation sheet with all required information, including sheet descriptions

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 5b: Ensure tabs have descriptive names and distinct colors

4.0 pts

This criterion is linked to a Learning OutcomeCOMMENT: What you learned from completing this Lab

5.0 pts