In Excel, open a blank worksheet.
In cell A1, type Payroll- 2019. Make the font bold, 14 point (The type face is your choice).
In A2, type Weekly Payroll- 9/20 – 9/26 12 point, not bold.
In line 3 type the following:
A3, type Last Name,
tab to B3 and type First Name, continue to press tab to move to each cell to the right.
C3 Dependents
D3 Pay Rate
E3 Hours Worked
F3 Gross Pay
G3 Federal Tax
H3 State Tax
I3 Net Pay
In the records for lines 4 through 9, fill in the data that you make up with six employee names, the number of dependents (children), the pay per hour and the number of hours worked for the week. The rest of the cells remain blank. You will use formulas to generate the data for these.
Once you have data in columns C through E, use the following formulas.
In cell F4, Gross Pay type =D4*E4 You are multiplying the pay rate and hours worked. The * is the multiplication sign. Always begin a formula with the equal sign =.
In cell G4, type =0.22* (F4-C4*24.32). This gives a tax credit for each dependent.
In cell H4, type = 0.04*F4.
In cell I4, type =F4-(G4+H4) Study each formula to understand what cells the data is from.
Once the data is generated for one cell, you can fill the formulas for rest of the column using the Fill Handle. Click on cell F4 and a green box appears. In the lower right corner is a little green box. Hover your curser until it turns into a solid + Left click and hold, then drag to the bottom of the employee list. Fill in the data for the rest of the columns F through I.
Next, you will generate totals for each column.
Click cell E11, just below the last employee in the hours worked column and click the Auto Sum in the Editing tool (far right) on the Home Tab. See the screen shot for where we are up to this step.
Click the cell with the sum and drag the Fill Handleto the right to sum all columns.
Now you will use the Conditional Formatting tool to analyze the data.
Select the Pay Rate data for all employees, excluding the sum total.
From the Home tab, go to Styles and click the down arrow for the Conditional Formatting tab.
Select Top/Bottom Rules, Top 10%. You will find who earns the highest hourly rate. This is especially helpful for a spreadsheet with many employees.
Use at least two more of the conditional formation options and choose different color schemes for each.
Select the Gross Pay column, excluding the sum total. On the Home Tab, go to the E or Sum symbol on the Editing Tab and select the Average option. Do the same with the Maximum and Minimumoptions. See the screen shot below.
Now, you make the spreadsheet look better.
Left select cell A1, hold the mouse and drag to cell I1. On the Home tab Alignment tab, choose Merge & Center. Do the same with row A2.
Fill the rows A1 and A2 with colors of your choice.
Add a bottom border from the Font Tab.
We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.
Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.
Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.
Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.
Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.
Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.
We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.
Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.
You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.
Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.
Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.
You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.
You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.
Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.
We create perfect papers according to the guidelines.
We seamlessly edit out errors from your papers.
We thoroughly read your final draft to identify errors.
Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!
Dedication. Quality. Commitment. Punctuality
Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.
We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.
We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.
We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.
We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.