Please follow the instructions carefully

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.

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

 

"Is this question part of your assignment? We Can Help!"