Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

20 Excel for Accounting Chapter 7: Payroll Register Extend Your Skills EAZ-E1 Complete a Payroll Register for Ashley's Auto Sales In this exercise, you will

image text in transcribed
20 Excel for Accounting Chapter 7: Payroll Register Extend Your Skills EAZ-E1 Complete a Payroll Register for Ashley's Auto Sales In this exercise, you will complete a payroll register for Ashley's Auto Sales. You will use the techniques from this chapter to enter earnings, deduction, and net pay data. You will also modify the payroll register to ensure optimal layout and formatting Open EA7-E1-Payroll. Use an IF function to populate the Overtime Earnings and Total Earnings columns. Ensure that N/A is displayed in the Overtime Earnings column for employees who did not work overtime hours during the period. Populate the FWT and SWT columns using these figures. FWT SWT Check Number $24 $18 $12 683 Employee Name Stanley,J $16 682 Campbell, Y Raimi, A $12 8684 $33 $22 685 $16 $10 686 Williams, N McCann,V Create a nested IF function to calculate Social Security tax and a separate formula to calculate Medicare tax for each employee. Use absolute formatting as appropriate. Use the appropriate LOOKUP function to calculate the charitable contributions and medical plan payment amounts for each employee. Note that the percentages in the range C2 represent the percent of total earnings contributed to the respective voluntary withholdings. Use these in your LOOKUP function. Complete the payroll register by entering the check numbers and creating a formula to calculate each employee's net pay. Adjust the worksheet layout by adding borders around distinct sets of data, adjusting column widths and/or row heights between sets of data, and minimizing blank space between data sets. Last, use appropriate formatting to distinguish the headers in rows 6-8 from the data below and conditional formatting to highlight the two largest Net Pay amounts. EA7-E2 Complete a Payroll Register for Brochure Specialists In this exercise, vou will completen 20 Excel for Accounting Chapter 7: Payroll Register Extend Your Skills EAZ-E1 Complete a Payroll Register for Ashley's Auto Sales In this exercise, you will complete a payroll register for Ashley's Auto Sales. You will use the techniques from this chapter to enter earnings, deduction, and net pay data. You will also modify the payroll register to ensure optimal layout and formatting Open EA7-E1-Payroll. Use an IF function to populate the Overtime Earnings and Total Earnings columns. Ensure that N/A is displayed in the Overtime Earnings column for employees who did not work overtime hours during the period. Populate the FWT and SWT columns using these figures. FWT SWT Check Number $24 $18 $12 683 Employee Name Stanley,J $16 682 Campbell, Y Raimi, A $12 8684 $33 $22 685 $16 $10 686 Williams, N McCann,V Create a nested IF function to calculate Social Security tax and a separate formula to calculate Medicare tax for each employee. Use absolute formatting as appropriate. Use the appropriate LOOKUP function to calculate the charitable contributions and medical plan payment amounts for each employee. Note that the percentages in the range C2 represent the percent of total earnings contributed to the respective voluntary withholdings. Use these in your LOOKUP function. Complete the payroll register by entering the check numbers and creating a formula to calculate each employee's net pay. Adjust the worksheet layout by adding borders around distinct sets of data, adjusting column widths and/or row heights between sets of data, and minimizing blank space between data sets. Last, use appropriate formatting to distinguish the headers in rows 6-8 from the data below and conditional formatting to highlight the two largest Net Pay amounts. EA7-E2 Complete a Payroll Register for Brochure Specialists In this exercise, vou will completen

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Keys To Reading An Annual Report

Authors: George T. Friedlob, Ralph E. Welton

4th Edition

0764139150, 978-0764139154

More Books

Students also viewed these Accounting questions

Question

Group Size and Communication

Answered: 1 week ago

Question

Understanding Group Roles

Answered: 1 week ago