Excel - Advanced Cell Formatting

1. Open the ExcelPractice3JohnDoe spreadsheet.
2. Enter a simple formula to add the number of hours for Employee 256 by clicking in Cell G3 and keying in +B3+C3+D3+E3+F3. After you have keyed in the formula press the enter key.  Please note that this formula using relative cell addresses.  Relative cell addresses automatically change when they are copied vertically or horizontally.

1. Click on Cell G3. Move the cursor to the bottom right corner of Cell G3.  The cursor will change to a black + sign. After you get the black + sign, double-click your mouse.  This will auto fill the formula for the rest of the employees.
2. Enter a formula to multiply the Total Hours worked by Hourly Wage for Employee 256 by clicking in Cell I3 and keying in +G3*H3. After you have keyed in the formula press the enter key.  Please note that the formula is using relative cell addresses.

1. Click on Cell I3. Move the cursor to the bottom right corner of Cell I3.  The cursor will change to a black + sign. After you get the black + sign, double-click your mouse.  This will auto fill the formula for the rest of the employees.
2. Enter a formula to multiply the Gross Pay by the Tax Rate for Employee 256 by clicking in Cell J3 and keying in +I3*$B$10. After you have keyed in the formula press the enter key.  Please note that the formula is using one relative cell address and one absolute cell address.  The dollar signs before the cell letter and cell number marks the cell as an absolute cell.   Absolute cell addresses do not automatically change when they are copied vertically or horizontally.

1. Click on Cell J3. Move the cursor to the bottom right corner of Cell J3.  The cursor will change to a black + sign. After you get the black + sign, double-click your mouse.  This will auto fill the formula for the rest of the employees.
2. Enter a formula to subtract the Taxes from Gross Pay for Employee 256 by clicking in Cell K3 and keying in +I3-J3. After you have keyed in the formula press the enter key.  Please note that the formula is using relative cell addresses.

1. Click on Cell K3. Move the cursor to the bottom right corner of Cell K3.  The cursor will change to a black + sign. After you get the black + sign, double-click your mouse.  This will auto fill the formula for the rest of the employees.
2. Select the Range H3:K7 by clicking on Cell H3, hold down the shift key, then click on Cell K7.
3. On the Home tab, in the number group, click on the Accounting Number Format button.

1. Enter a sum function in Cell K9 to find the Total Net Pay. Click on Cell K9.  Key in =sum(K3:K7).  Press the enter key.

1. Enter an average function in Cell K10 to find the Average Net Pay. Click on Cell K10.  Key in =average(K3:K7).  Press the enter key.

1. Enter a minimum function in Cell K11 to find the Minimum Net Pay. Click on Cell K11.  Key in =min(K3:K7).  Press the enter key.

1. Enter a maximum function in Cell K12 to find the Maximum Net Pay. Click on Cell K12.  Key in =max(K3:K7).  Press the enter key.

1. Rename the worksheet to Week 1. Right-click on the sheet tab and select Rename from the pop-up menu. 

1. Click the backspace key to delete Sheet1 and key in Week 1.

1. Make a copy of the Week 1 worksheet. Right-click on the Week 1 worksheet.  Select Move or Copy from the pop-up menu.

1. From the dialog box, select move to end, create a copy, and click OK.

1. Right-click on the new worksheet and rename it Week 2.
2. Add a new worksheet by clicking on the New Sheet Button.

1. Click on the file tab, click the Save As option, select a location to save you file, change the filename to ExcelPractice3FirstNameLastName (replace your FirstNameLastName with your name).