Step 1: (Multiply) Determine Regular weekly camings by multipling cel B11 by C11 in cel D11. To do this type -811'C11 in cel D11 or you use linking by clicking on the cele as described below 0 Hours Hourly rate Regular camings 40 725 In D11 type = then click on B11, then then click on C11 then hit Enter 1, then he Enter WN Step 2: (Divide) Divide a weekly salary by 40 hours to determine hourly rate by dividing B17 by C17 in cel D17. To do this type - 817 / C17 in cel D17 or link cols described 14 below Hours Hourly rate Weekly salary 500 4 0 in 017 type = then click on B17 then / then click on C17 and then hit Enter 18 20 Step 3: Add) Add regular and overtime camings in cel D23 by adding call B23 to C23. To do this type or link 823C23 in cel D23 or use Sum toolbar. Regular camings 500 Overtime Earings 100 Gross Eamings in the make sure 23 and C23 are highlighted, then enter Step 4: (Subtract) Subtract the withholdings from Gross camings in cel 029 by subtracting cel C29 from 29. To do this type 329 C29 or use Sum toolbar. Note: you can only do this because there are brackets) around the number in 29 that means it wil subtract it. If there were no brackets or sign you would need to subtract instead of 26 add cel Gross carings total withholdings (150) Net Pay make sure 29 and C29 are highlighted, then enter Step 5: Copy any of the above formules and celis above into the table below. To do this highlight cols you want to copy and night click, select copy. Then click on 835 where you want to start the paste), right click and select paste. All of the fom s and contents of the cats should be copied into the table below Please save and submit Excel Worksheet under CH 1 End of Chapter Upload Files Link