# please follow the instruction carefully we re using week 1 lab assignment to complete the work

Summit Ridge Mountain Resort: Shop Analysis. Basic instructions are located in the Lab Overview page. Be sure to watch the hands-on exercise tutorials at the end of the lesson for guidance on completing this assignment.

COURSE: BIS155 Lab 2

COURSE: BIS155 Lab 2

Criteria Ratings Pts

This criterion is linked to a Learning OutcomeSTEP 1a: Copy Daily Sales to new worksheet

 3.0 pts Full Marks 0.0 pts No Marks

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 1b: Add Total Quantity Sold column and calculate

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 1b: Add Totals Row and enter totals for each day

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 1c: Add column and calculation for percentage of sales

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 1d: Add chart and use Statistical functions to calculate highest selling, lowest selling, and average quantity sold

 6.0 pts Full Marks 0.0 pts No Marks

6.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a: Create a 2D Bar Chart to show total quantity sold for each item

 5.0 pts Full Marks 0.0 pts No Marks

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 2b: Move chart to new worksheet

 3.0 pts Full Marks 0.0 pts No Marks

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 2c: Change the title of the chart and the worksheet tab

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 3a: Create a 3-D Pie Chart showing percentage of sales for each item

 5.0 pts Full Marks 0.0 pts No Marks

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 3b: Move to new worksheet

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 3c: Display item names and percentages on pie slices

 5.0 pts Full Marks 0.0 pts No Marks

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 3d: Title and tab named

 3.0 pts Full Marks 0.0 pts No Marks

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 4a: Copy Daily Sales to new worksheet

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 4b: Calculate profit per item using reference to Sales-Data worksheet

 3.0 pts Full Marks 0.0 pts No Marks

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 4c: Create a second worksheet area with items and dates

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 4c/d: Calculate profit for each item and autofill table by using mixed references

 7.0 pts Full Marks 0.0 pts No Marks

7.0 pts

This criterion is linked to a Learning OutcomeSTEP 4e: Create Line Chart

 5.0 pts Full Marks 0.0 pts No Marks

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 4f: Title and tab named

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 5a: Update the documentation sheet to add names and descriptions for each sheet

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 5b: Add a custom page header to all data worksheets and set orientation to landscape (not to chart sheets)

 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