S
EXCEL – BUSINESS PACKET PROJECT
BIM
INSTRUCTIONS:
1. ( Enter the above data in the same cells on your spreadsheet.
( Create a header/footer for the above worksheet.
2. ( Center the title in Rows 1 and 2 over all columns of the worksheet.
(highlight A1:F1, Format Cells, Alignment tab, Merge Cells)
3. ( Adjust the width of all columns to fit the longest item in the column.
4. ( Center and Bold rows 4 and 5.
5. ( Remember that all $ amounts have 2 decimal places and commas.
6. ( In Column F, find the balance for each day. (There should be a formula for each row.)
Balance=Previous balance-checks+deposits
7. ( Rename the Sheet1 tab to CHECK REGISTER and color the tab yellow.
8. ( Save the Workbook as EXCEL BUSINESS PACKET and move on to the next sheet.
INSTRUCTIONS:
1. ( Create the above worksheet in Sheet2 of the Excel Business Packet.
2. ( Create a header/footer for the above worksheet.
3. ( Center the titles in rows 1 and 2 over all the columns of the worksheet (A thru G).
4. ( Column A should be left aligned. All other columns contain values and are right aligned.
5. ( Adjust column widths as needed.
6. ( Center all of Column E.
7. ( Center and Bold Row 4.
8. ( Total Columns B, C, D, F, and G (use formulas, of course).
9. ( Find the formulas for Subtotal, Sales Tax, & Total. Copy each formula to the appropriate cells.
a. ( Subtotal (column D) – add together Labor and Parts
b. ( Sales Tax (column F) – multiply Subtotal and % Sales Tax
c. ( Total (column G) – add together Subtotal and Sales Tax
10. ( Save your work so far.
11. ( Take a copy of the entire table (title through totals) down through Row 18. (A1 through G18)
12. ( Paste what you have copied starting on Row 34 (You will now have a copy of the worksheet at the top of the page and another copy of the worksheet starting on Row 34).
13. ( ON THE BOTTOM COPY ONLY, delete the entire row for bills #99282 and #99286 (Rows 44 and 48).
14. ( ON THE BOTTOM COPY ONLY, change the sales tax to 7%.
15. ( Recheck worksheet appearance for alignment, decimals, commas, currency, etc.
16. ( Rename the Sheet2 tab to ARTIE’S AUTO REPAIR and color the tab green.
17. ( Save your work.
INSTRUCTIONS:
1. ( Create the above worksheet in Sheet3 of the Excel Business Packet.
2. ( Create a header.
3. ( Center the worksheet horizontally on the page.
4. ( Center the title over all the columns of the worksheet.
5. ( Adjust column widths as needed.
6. ( Column A should be left aligned. All other columns contain values and are right aligned and have 2 decimal places and commas.
7. ( Center and Bold rows 3, 4, 5.
8. ( Create a formula to calculate FICA TAX DEDUCTION in column D.
FICA TAX DEDUCTION= TOTAL EARNINGS * 6%.
9. ( Create a formula to calculate TOTAL DEDUCTIONS in column F.
TOTAL DEDUCTIONS = Federal income tax deduct + Fica Tax Deduct + Hospital Insurance Deduct
10. ( Create a formula to calculate NET PAY in column G.
NET PAY = TOTAL EARNINGS – TOTAL DEDUCTIONS.
11. ( In Row 16, total Columns B through G.
12. ( Make sure all amounts have currency, commas, and 2 decimal places.
13. ( Save your work so far.
14. ( Copy the worksheet (title through totals) through row 16, and paste beginning on row 33. (A1:G16)
15. ( ON THE BOTTOM COPY ONLY, delete the row for Lu Chung.
16. ( ON THE BOTTOM COPY ONLY, alphabetize the names.
(Highlight range A38:G45, Data menu, Sort, Sort by Column A).
17. ( Check worksheet appearance.
18. ( Rename the Sheet3 tab to PAYROLL REGISTER and color the tab blue.
19. ( Save your work.
INSTRUCTIONS:
1. ( Create the above worksheet in Sheet4 of the Excel Business Packet.
2. ( Create a header/footer.
3. ( Center the worksheet horizontally on the page.
4. ( Center the title in Row 1 over all columns of the worksheet.
5. ( Left align all of Column A. All other columns will be right aligned.
6. ( Bold and Center rows 3, 4, 5.
7. ( Adjust all column widths as necessary.
8. ( Use a formula to calculate FICA TAX DEDUCTION using 6%.
(Look at how you did this on the Payroll Register worksheet).
9. ( Use a formula to calculate TOTAL DEDUCTIONS. You have to add up the FEDERAL INCOME TAX DEDUCTION and FICA TAX DEDUCTION.
10. ( Use a formula to calculate NET PAY.
(Look at how you did this on the Payroll Register worksheet).
11. ( In Row 15, total columns B through G.
12. ( For NUMBER OF PAY PERIODS, type in the value 6 in cell F17.
13. ( For HIGHEST NET PAY, use a MAX formula to calculate the highest Net Pay that John had in column F.
14. ( For LOWEST NET PAY, use a MIN formula to calculate the lowest Net Pay that John had in column F.
15. ( For AVERAGE NET PAY, use the AVERAGE formula to calculate the average Net Pay that John had on column F.
16. ( Format the worksheet as needed with currency, commas, decimals, etc.
17. ( Rename the Sheet4 tab to EARNING RECORD and color the tab.
18. ( Save your work and email your entire EXCEL BUSINESS PACKET to Mrs. Tompkins. Turn in packet!!
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.