In Excel, open a blank worksheet. In cell A1, type . Make the font (The type face is your choice). In A2, type 12 point, not bold. In line 3 type the following: A3, type , tab to B3 and type 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 You are multiplying the pay rate and hours worked. The * is the multiplication 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 . Click on cell F4 and a green box appears. In the lower right corner is a little gr
een 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 in the tool (far right) on the Tab. for where we are up to this step. Click the cell with the sum and drag the to the right to sum all columns. Now you will use the tool to analyze the data. Select the Pay Rate data for all employees, total. From the tab, go to and click the down arrow for the tab. Select , . 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 column, l. On the , go to the or on the and select the option. Do the same with the and options. 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 tab Alignment tab, choose . Do the same with row A2. Fill the rows A1 and A2 with of your choice. Add a from the