After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week1_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week1_Lab.xlsx.
When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity. Make certain you compare your finished work with the Grading Rubric included here.Â
| Lab 1 – Village Shop Sales |
| Step |
Task |
Points Possible |
Points Received |
Comments |
| 1 |
Documentation sheet |
| 1a |
Insert new worksheet |
1 |
 |
 |
| 1b |
Rename worksheet tab |
1 |
 |
 |
| 1c |
Enter identifying information |
2 |
 |
 |
| 1d |
Format with text wrapping & color formatting |
2 |
 |
 |
| 2 |
Calculations |
| 2a |
Calculate Net Selling Price for each item |
3 |
 |
 |
| Â |
Calculate the Total Sales for each item |
3 |
 |
 |
| Â |
Calculate the Total Profit per item |
3 |
 |
 |
| Â |
Calculate the Average Profit % for each item |
3 |
 |
 |
| 2b |
Calculate Total Profit to Date |
3 |
 |
 |
| 2c |
Calculate the Remaining Profit Need to meet the Goal |
3 |
 |
 |
| 3 |
Formatting |
| 3a |
Center the spreadsheet title rows across the selection A - R |
4 |
 |
 |
| 3b |
Apply text wrapping to column headings |
4 |
 |
 |
| 3c |
Change Font size and color |
2 |
 |
 |
| 3d |
Change shading and borders |
2 |
 |
 |
| 3e |
Format currency and percentages |
3 |
 |
 |
| 4 |
Professional Appearance (Cleanup) |
| 4a |
Tab color and names |
4 |
 |
 |
| 4b |
Hide columns D-M |
4 |
 |
 |
| 4c |
Custom header: Professor Names and Student Name |
5 |
 |
 |
| 4d |
Page orientation |
3 |
 |
 |
| Comment: What you learned from completing this Lab |
5 |
 |
 |
| TOTAL POINTS |
60 |
0 |
 |
| Week 1 Lab Grading Rubric |
