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

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.