MS Excel
Not what you're looking for?
1.The Orange colored cells on the worksheet indicate places where you will put in the formulas and functions.
2.Calculate the total Gross Pay for each employee. Keep in mind that employees are paid time and a half for all over-time hours. Here is an example formula that demonstrates how you would make such a calculation: =b4*d4+b4*c4*1.5 These must be formulas and will be entered into the range E11:E14.
3.In #5, #6, and #7 below you must include an absolute reference cell in each formula!!! Imagine while you are completing these steps that there were 150 employees at the company.
4.Calculate the total amount each employee must pay in Federal Taxes in the range F11:F14. These calculations must be completed using formulas. These formulas MUST contain an absolute reference to the cell holding the percentage amount. The percentage is above Federal in cell F9.
5.Calculate the total amount each employee must pay in State Taxes in the range G11:G14. These calculations must be completed using formulas. These formulas MUST contain an absolute reference to the cell holding the percentage amount. The percentage is above State in cell G9.
6.Calculate the total amount each employee must pay in Social Security Taxes in the range H11:H14. These calculations must be completed using formulas. These formulas MUST contain an absolute reference to the cell holding the percentage amount. The percentage is above Social in cell H9.
7.Calculate the total Net Pay for each employee in the range: I11:I14. These calculations must be completed using a formula.
8.Calculate the totals for all of the employee hours and pay categories in the range: B16:I16. These calculations must be completed using SUM functions.
9.Format all of the cells that represent a dollar amount as Currency with 2 decimal places.
Purchase this Solution
Solution Summary
This posting contains answers to the given questions.
Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Javscript Basics
Quiz on basics of javascript programming language.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.