Spreadsheet Project
Part 1 – 40 pts. for each Report. Download, “save as”, and complete the attached files. The Word (.docx) file gives the details and numbers you need to complete the
attached Excel files. Use the two Excel sheets to input and calculate the necessary reports. You can actually do the calculations one-by-one on your cell phone or
calculator, but your numbers will be slightly different than my numbers. The main objective of the assignment is for you to get comfortable using Excel or similar
spreadsheet.
Part 2 – Format 20 pts. Format will be critical, as I want to receive just three (3) pages for your completed assignment. Page 1 will be the the first page of
Directions / Word doc. as a cover sheet, page 2 will be the Annual Payroll Report, and page 3 sheet will be the Inventory Report. If you need assistance formatting
the Excel tables to print on one sheet each, let me know. Be sure to put your name on each paper. Do not use the “Insert Text Box” tool on the Excel sheets to copy
the Word document, but rather insert the two Excel files into the Word document.
202 Project-2.docx (2 pages) see upload
202 Project-1.xlsx (2 sheets)see upload