BIS155 DeVry Lab 2 Sales Data, Pie Chart And Daily Profits Excelsheet

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

3.0 pts

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

4.0 pts

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

4.0 pts

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

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

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

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

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

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

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

2.0 pts

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

5.0 pts

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

3.0 pts

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

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

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

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

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

5.0 pts

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

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

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

This criterion is linked to a Learning OutcomeCOMMENT: What you learned from completing this Lab

5.0 pts