Please attach excel document with formulas answering questions on the picture.

1 Turn this data range into a table of your choice 2 Calculate Gross Pay = Hourse worked x Rate 3 Calculate FICA Tax = Gross Pay x7.65% 4 Calculate 401K amounts that the company is providing = Gross Pay x Column G 5 Calculate Net Pay = Gross Pay Medical insurance - FICA Tax 401K Company 6 Calculate New Wage Increase = Raise increase % Rate 7 Calculate New Wage = Rate + New Wage Increase 8 Calculate New Gross Pay = New wage x Hours Worked 9 Create a total row at the bottom that shows total hours worked, Medical Insurance, Gross pay, FICA Tax, 401K Company, Net pay and New Gross Pay 11 Create a bar chart of your choice that compares new gross pay to old gross pay for each employee 12 Create a pie chart of your choice that shows the breakdown of net pay for each employee 1 Turn this data range into a table of your choice 2 Calculate Gross Pay = Hourse worked x Rate 3 Calculate FICA Tax = Gross Pay x7.65% 4 Calculate 401K amounts that the company is providing = Gross Pay x Column G 5 Calculate Net Pay = Gross Pay Medical insurance - FICA Tax 401K Company 6 Calculate New Wage Increase = Raise increase % Rate 7 Calculate New Wage = Rate + New Wage Increase 8 Calculate New Gross Pay = New wage x Hours Worked 9 Create a total row at the bottom that shows total hours worked, Medical Insurance, Gross pay, FICA Tax, 401K Company, Net pay and New Gross Pay 11 Create a bar chart of your choice that compares new gross pay to old gross pay for each employee 12 Create a pie chart of your choice that shows the breakdown of net pay for each employee