Submit one workbook. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity.
File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week2_Lab.xlsx.
Make certain you compare your finished work with the Grading Rubric included here.Â
| Lab 2 – Shop Analysis |
| Step |
Task |
Points Possible |
Points Received |
Comments |
| Â |
Documentation sheet completed |
5 |
 |
 |
| 1 |
Daily Item Totals worksheet |
| 1a |
Copy Daily Sales to new worksheet |
2 |
 |
 |
| 1b |
SUM function for items |
2 |
 |
 |
| Â |
SUM function for dates |
2 |
 |
 |
| 1c |
Formula percentage of sales |
3 |
 |
 |
| 1d |
Statistical functions for sales |
3 |
 |
 |
| 1e |
Formula profit per item |
2 |
 |
 |
| 2 |
Create Bar Chart |
| 2a |
2D Bar Chart |
5 |
 |
 |
| 2b |
On new worksheet |
2 |
 |
 |
| 2c |
Title and tab named |
2 |
 |
 |
| 3 |
Create Pie Chart |
| 3a |
Pie Chart |
5 |
 |
 |
| 3b |
On new worksheet |
2 |
 |
 |
| 3c |
Title and tab named |
2 |
 |
 |
| 4 |
Create Weekly Profits |
| 4a |
Copy Daily Sales to new worksheet |
2 |
 |
 |
| 4b |
Calculate profit per item |
2 |
 |
 |
| 4c |
Calculate profits for each item |
4 |
 |
 |
| 4d |
Autofill profits for all items |
3 |
 |
 |
| 4e |
Create Line Chart |
5 |
 |
 |
| 4f |
Title and tab named |
2 |
 |
 |
| Comment: What you learned from completing this Lab |
5 |
 |
 |
| TOTAL POINTS |
60 |
0 |
 |
Week 2 Grading Rubric