1. Read the following data regarding payroll deductions, and answer the questions that follow:

Lydia: $9.50/hour, worked 20 hours this pay period

Thomas: $12.50/hour, worked 40 hours this pay period

Bruce: $8.50/hour, worked 30 hours this pay period

a. Using a spreadsheet program, create a payroll spreadsheet with the information above. Be sure to include proper headings.

b. Add a “Tax (%)” column. Apply a nested IF statement to the spreadsheet to determine the percentage of taxes that needs to be deducted. For someone who makes $9.00 or less an hour, the is 5%. For someone who makes between $9.01 and $12.00 an hour, the rate is 6%. For someone who makes more than $12.01 an hour, the is 7%.

c. Describe hour you generated this column.