# Test for class EXCELL - repost

****************************It's a test I need done in two hour I can give you the login and you take it for me , You have to write out how you would complete worksheets example below it's 4-5 questions toatel need it by 1159:pm est TONIGHT!!!!!******************************

Question 1. 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions:

Note: This is a one part question.

• Each employee could have a standard hourly rate between \$10.00 and \$30.00 per hour.

• Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours.

• Each employee will have a standard 7.65% deduction for social security

• Each employee will have a standard 14.00% deduction for Federal Taxes

• Each employee will have a standard 5.33% deduction for State Taxes

Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula.

In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather keep the payroll running on one worksheet or by assigning a new worksheet for each week. Using your knowledge learned in this class, descriptively explain whether you would keep all weekly payrolls in one worksheet or assigned to new worksheets by week. Defend the approach you take based on what you have learned in this course.

( 0 reviews ) Bogor, Indonesia

Project ID: #5050013

## 15 freelancers are bidding on average \$135 for this job

hotline69

I have been performing my duties with a Teacher Training Institute as "Microsoft Unlimited Potential Course Instructor". I have vast knowledge of MS Excel, vba, etc. I can do this job for you. Regards,

\$157 USD in 1 day
(223 Reviews)
6.6
KatieHammond

Being an experience academic writer and well researcher. I am 100% confident I can do this project perfectly. I have already written PhD and Master's Level Paper for UK and US Students and I can easily work on it. Plea More

\$150 USD in 7 days
(74 Reviews)
5.9
javed1705

I am an ACCA , APA and Mcom finance You project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am fully competent in doing said assignment/job, a More

\$105 USD in 0 days
(69 Reviews)
5.9
naveed349

Hi, I am proficient academic writer and have a sound grasp over Excel and Databases. Please let me help you to solve/complete this payroll proforma. I assure you to provide perfect and accurate results within a couple More

\$75 USD in 0 days
(31 Reviews)
4.5
MasterExcel

I am Data Entry ,MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high More

\$147 USD in 3 days
(5 Reviews)
2.6
WAQAS1ACA

After reviewing your project details, I can assure you with great confidence that I can handle yours project because I already handled these types of projects practically in my professional accountancy career. I am ve More

\$61 USD in 0 days
(3 Reviews)
2.4
Aldo21

please send me the file so we can start to work right away----------------------------------------------------------------

\$35 USD in 0 days
(4 Reviews)
2.2
QasimAliZoaib

A walk in the park for me. I will try my level best to get you a good score in this test not a problem.

\$97 USD in 0 days
(0 Reviews)
0.0
sicortesjr

mym37: I am a Business Management Professional with twenty years experience. I possess superb editing and writing skills. I am an Excel superuser and I have processed in-house payroll (your assigment) for several cu More

\$189 USD in 1 day
(0 Reviews)
0.0
kartyesu

The writer has overall working experience of 40 years including 10 years Accounts working and salaries/pay roll for the organization.

\$177 USD in 3 days
(0 Reviews)
0.0
indragunaratne

Dear Sir, I am secretary for more than 25 years and I am very much thorough with such tasks. I have also done preparing wages and salaries for more than 100 employees with Overtime etc. I believe that I can fulfi More

\$155 USD in 3 days
(0 Reviews)
0.0
kikihrt

I 'm sure you can work on the project , because I have good data entry skills and good microsoft office also , and I have more time to complete this project on time , other than that this time I also worked as an IT st More

\$133 USD in 3 days
(0 Reviews)
0.0
romliramlee

We are a team of skilled dedicated people and our passion is simply to excite ourselves with every project that we do. Our team work experience is of more than 10 years combined while enthusiasm and fresh creative mind More

\$155 USD in 3 days
(0 Reviews)
0.0
ezgibyrktr

I have done homework and projects with similar work. I can complete it as soon as possible. I work efficiently. And my excel skills are very good.

\$277 USD in 3 days
(0 Reviews)
0.0
monish2002

Hi. Thanks for the opportunity extended. I understand the project needs and find myself confident to carry out the work in the stipulated time frame. What differentiates me from my competitors is the consistenc More

\$250 USD in 3 days
(0 Reviews)
0.0
fivesky55

Hi, I am graduate with certified in Accounting Certificate (L.C.C.I) certified by UK. Although my expertise are more in Finance such as Foreign Exchange and Metals, but I can do this job easily with all the formulas. More

\$142 USD in 3 days
(0 Reviews)
0.0