In this exercise, you will create a payroll register for Athletics Supply House using ROUND, IF,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In this exercise, you will create a payroll register for Athletics Supply House using ROUND, IF, and VLOOKUP functions. You will also modify the worksheet's layout and highlight key elements. Use this information to complete the payroll register. Employee Name FWT SWT Check Number Thomas, T $15 $10 118 Kirkpatrick, I $23 $36 119 T Fitzgerald, R $20 $14 120 Marshall, N $9 S6 121 Abbott, P $27 $9 122 1. Open EA7-A1-Payroll from your Chapter 07 folder and save it as BA7-A1-Payroll-[YourName). 2. In cell H9, create an IF function to display N/A for employees who do not work overtime and the overtime earnings for employees who do work overtime hours. 3. Copy the formula to the range H10:H13 4. In cell 19, nest an IF function within the ROUND function such that regular earnings and overtime earnings are added. 5. Copy the formula to the range 110:113 6. Enter the federal and state withholding tax figures in the range J9:K13. Use Nested IF Functions, Absolute Formatting, and Mixed Formatting 7. In cell L9, nest an IF function within the ROUND function to calculate Social Security tax using absolute and/or mixed references where.necessary. 8. Copy the formula to the range L10:L13. 9. In cell M9, enter a ROUND function to calculate Medicare tax using absolute and/or mixed references as necessary. 10. Copy the formula to the M10:M13. range Add a Lookup Function 11. Assign an appropriate define 825-D29 12. In cell N9, nest a LOOKUP function within the ROUND function to calculate the hospital donation amounts using absolute and/or mixed references as necessary. 13. Copy the formula to the range N10:N13 and then to cell 09, modifying it to properly calculate the school donation amounts. 14. Enter the appropriate check numbers into the range P9:P13. 15. In cell Q9, enter a formula to calculate the net pay; copy it to the range Q10:Q13. 16. Enter a formula to calculate all appropriate totals in row 16. Finalize the Worksheet 17. Move worksheet elements as necessary so they are appropriately aligned. 18. Apply borders and bold or italic formatting where necessary to distinguish sets of data and ensure that the headers stand out. 19. Apply conditional formatting to the Net Pay column such that the two largest checks are highlighted in Yellow Fill with Dark Yellow Text 20. Save and close your file. In this exercise, you will create a payroll register for Athletics Supply House using ROUND, IF, and VLOOKUP functions. You will also modify the worksheet's layout and highlight key elements. Use this information to complete the payroll register. Employee Name FWT SWT Check Number Thomas, T $15 $10 118 Kirkpatrick, I $23 $36 119 T Fitzgerald, R $20 $14 120 Marshall, N $9 S6 121 Abbott, P $27 $9 122 1. Open EA7-A1-Payroll from your Chapter 07 folder and save it as BA7-A1-Payroll-[YourName). 2. In cell H9, create an IF function to display N/A for employees who do not work overtime and the overtime earnings for employees who do work overtime hours. 3. Copy the formula to the range H10:H13 4. In cell 19, nest an IF function within the ROUND function such that regular earnings and overtime earnings are added. 5. Copy the formula to the range 110:113 6. Enter the federal and state withholding tax figures in the range J9:K13. Use Nested IF Functions, Absolute Formatting, and Mixed Formatting 7. In cell L9, nest an IF function within the ROUND function to calculate Social Security tax using absolute and/or mixed references where.necessary. 8. Copy the formula to the range L10:L13. 9. In cell M9, enter a ROUND function to calculate Medicare tax using absolute and/or mixed references as necessary. 10. Copy the formula to the M10:M13. range Add a Lookup Function 11. Assign an appropriate define 825-D29 12. In cell N9, nest a LOOKUP function within the ROUND function to calculate the hospital donation amounts using absolute and/or mixed references as necessary. 13. Copy the formula to the range N10:N13 and then to cell 09, modifying it to properly calculate the school donation amounts. 14. Enter the appropriate check numbers into the range P9:P13. 15. In cell Q9, enter a formula to calculate the net pay; copy it to the range Q10:Q13. 16. Enter a formula to calculate all appropriate totals in row 16. Finalize the Worksheet 17. Move worksheet elements as necessary so they are appropriately aligned. 18. Apply borders and bold or italic formatting where necessary to distinguish sets of data and ensure that the headers stand out. 19. Apply conditional formatting to the Net Pay column such that the two largest checks are highlighted in Yellow Fill with Dark Yellow Text 20. Save and close your file.
Expert Answer:
Answer rating: 100% (QA)
Payroll Register Earnings Deductions Employee Name Regular Hours ... View the full answer
Related Book For
Microeconomics An Intuitive Approach with Calculus
ISBN: 978-0538453257
1st edition
Authors: Thomas Nechyba
Posted Date:
Students also viewed these programming questions
-
In this exercise you will verify that when you have two sets of sample data, the t test for independent samples (assuming equal variances) and the ANOVA method of this section are equivalent. Refer...
-
In this exercise you will prove Theorem 9.8.2. a. Prove that the joint p.d.f. of the data given the parameters 1, 2, and can be written as a constant times b. Multiply the prior p.d.f. times the...
-
In this exercise you will observe the effect of a green house gas on temperature in a closed system You will use a large 500 mL 1000 mL glass jar to see whether carbon dioxide or air can trap more...
-
Write the C++ code for a function that receives an integer, a double number, and the address of a double variable from the calling statement. The function should multiply the integer by the double...
-
Refer to Exercise 10.33. The following information displays the education distribution of 1,000 jurors and the education distribution countywide. a. Display the above data using appropriate graphs....
-
he following situation involves Kevin Smith, staff accountant with the local CPA firm of Hobb, Mary and Khang (HM&K). The bookkeeper of Mirage Manufacturing Company resigned three months ago and has...
-
Consider the oscillation circuit shown in Figure 26.23. During the portion of the cycle when the capacitor's top plate is positive and the amount of charge is increasing, the current through the...
-
Leen Production Co. uses the job order cost system of accounting. The following information was taken from the companys books after all posting had been completed at the end of May: a. Compute the...
-
The average activity of air inside homes in the United States is about 1.5 pCi per liter. What is the average activity of a liter of air, in Bq? In decays per hour? SOLUTION SET UP We use the average...
-
Consider Sales & Operations planning. If the costs for hiring and firing employees are very small relative to the inventory holding costs, then which Sales & Operations plan is likely to have the...
-
Your manager asks you to find a potential and legitimate competitor to Microsoft Project for project scheduling with almost continual change that would be appropriate for your company. Identify the...
-
Refer to the facts in Problem 31. If a $10,000 distribution of income was made to a beneficiary during the 2019 tax year, what is the 2019 federal income tax liability of the estate? Assume that the...
-
What is the deliverable that is created once requirements analysis is completed? Why is this deliverable needed, and what does it include? Who are the audience and/or users of this deliverable, and...
-
Provide at least five of the critical success factors for JRP sessions.
-
What one thing should an analyst not do when beginning the fact-finding portion of requirements discovery, no matter how tempting?
-
In addition to encouraging user involvement, use-case modeling provides numerous other benefits. List the benefits that use-case modeling provides.
-
What are the four functions of money? Does cryptocurrency qualify for all four? (5 points) What are at the differences between currently used fiat money (such as dollar) and cryptocurrencies? (5...
-
The process of collaborative goal setting by a manager and subordinate, the extent to which goals are accomplished is a major factor in evaluating and rewarding the subordinate's performance. It is...
-
In our development of consumer theory, we made a big point about the fact that neoclassical economics does not put much stock in the idea of cardinally measuring utility (in terms of units of...
-
In this exercise we explore some technical aspects of general equilibrium theory in exchange economies and Robinson Crusoe economies. Unlike in other problems, parts A and B are applicable to both...
-
Exploring the Difference between Willingness to Pay and Willingness to Accept: Suppose you and I are identical in every way same exogenous income, same tastes over pizza and other goods. The only...
-
What is antisense RNA? How does it affect the translation of a complementary mRNA?
-
W hat is diauxic growth? Explain the roles of cAMP and CAP in this process.
-
What are the functions of activator proteins and repressor proteins in transcription? Explain how these proteins work at the molecular level.
Study smarter with the SolutionInn App