Recreate Excel spreadsheet using instructions and final product example.
waterdawg77
NP_EX16_1a_MirielleWhite_1.xlsxDocumentation
| New Perspectives Excel 2016 | Module 1: SAM Project 1a | |
| Pepito's Supermarkets | |
| GETTING STARTED WITH EXCEL | |
| Author: | Mirielle White |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Payroll
| Pepito's Supermarkets | |||
| Payroll - March 1-7, 2018 | |||
| Employee Name | Salary | DOB | Employee ID |
| John Charles | $375.58 | 1/2/80 | JC1280 |
| Meryl Love | $421.59 | 3/5/83 | |
| Carl Duette | $410.69 | 7/9/65 | |
| Sandy James | $298.76 | 4/8/52 | |
| Patricia Prutt | $312.35 | 6/3/60 | |
| Katie Brisker | $258.98 | 1/4/48 | |
| Jason Ballin | $325.95 | 2/9/92 | |
| Rose Bullock | |||
| Melissa Martin | |||
| Shannon Smith | |||
| Number of Employees | |||
Profit
| Pepito's Supermarkets | |||
| March 1-7, 2018 | |||
| Downtown | Green Hills | West Ridge | Total |
| Sales | $ 35,875.67 | $ 28,967.24 | $ 36,874.59 |
| Expenses | $ 15,236.78 | $ 12,658.47 | $ 17,895.36 |
| Profit | |||
| Note: All calculations are done weekly. | |||
| As of March 8, 2018 | |||
