Complete Lab 1: Summit Ridge Mountain Resort: Village Shops.

Be sure to review the tutorials at the end of this week’s lesson, in combination with the content of your assigned readings. These will provide you with the necessary tools to customize the Week 1 Summit Ridge Mountain Resort Student file located in the Lab Overview page.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

Submit your lab Excel file. Be sure to follow the proper file naming conventions included in your Syllabus (i.e., Doe_J Week1 Lab.xlsx).

COURSE: BIS155 Lab 1

COURSE: BIS155 Lab 1

Criteria Ratings Pts

This criterion is linked to a Learning OutcomeSTEP 1a: Insert new worksheet

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 1b: Rename worksheet tab (Documentation)

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 1b: Move documentation sheet to first sheet in workbook

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 1c: Enter identifying information: Name, Date, Purpose, Sheet documentation

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 1d: Format with appropriate title, borders, color, and column widths

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a: Use relative and absolute references appropriately

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeStep 2a: Calculate Net Selling Price for each item

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeStep 2a: Calculate the Total Sales for each item

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a: Calculate the Total Profit per item

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a: Calculate the Average Profit % for each item

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 2b: Calculate Total Profit to Date (B21)

 3.0 pts Full Marks 0.0 pts No Marks

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 2c: Calculate the Remaining Profit Need to meet the Goal (B22)

 3.0 pts Full Marks 0.0 pts No Marks

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 3a: Center the spreadsheet title rows across the selection A – R

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 3b: Apply text wrapping to column headings

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 3c: Change Font size and color of page heading

 3.0 pts Full Marks 0.0 pts No Marks

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 3d: Change shading and borders

 3.0 pts Full Marks 0.0 pts No Marks

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 3e: Format currency, percentages, and numbers appropriately

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 4a: Apply color to sheet tabs

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 4b: Hide columns D-M

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 4c: Create a custom header: Professor Names and Student Name

 5.0 pts Full Marks 0.0 pts No Marks

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 4d: Change the page orientation to landscape

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeCOMMENT: Provide a comment about what you learned from completing this lab.

 5.0 pts Full Marks 0.0 pts No Marks

5.0 pts

Total Points: 80.0