BIS155 Summit Ridge Mountain Resort Advanced Analysis

Would you like us to handle your paper? Use our company for better grades and meet your deadlines.


Order a Similar Paper Order a Different Paper

Complete Lab 5: Summit Ridge Mountain Resort: Advanced Analysis.

COURSE: BIS155 Lab 5 v2

COURSE: BIS155 Lab 5 v2

Criteria Ratings Pts

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

5.0 pts

Full Marks

0.0 pts

No Marks

5.0 pts

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

5.0 pts

Full Marks

0.0 pts

No Marks

5.0 pts

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

3.0 pts

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

5.0 pts

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

3.0 pts

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

5.0 pts

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

5.0 pts

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

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

Full Marks

0.0 pts

No Marks

4.0 pts

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

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

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper