Question 4 10 pts What formula would Ray's Net Pay be in dollars? 0 E5-F5. and click the $ icon =E5-F5-1.00 O C5+D5-F5. and click the $ icon 0 =G5 1.00 use this spreadsheet along with the information in the question to find the correct answer. use these formulas to calculate Gross Pay (Hourly Rate X Hours), Taxes (Gross Pay x tax %), and Net Pay (Gross Pay - Taxes). calculate taxes as 28% of gross pay and consider overtime to be time and a half (e.g.. $6.00 an hour would be $9.00 an hour of overtime). D G Net Pay 1 Taxes 2 3 Name Ray Marcia Brittany Miguel Totals Hourly Rates Total Hours (regular) Total Hours (Overtime) Gross Pay $12.42 40 11.5 $8.33 23.25 0 $14.33 40 4.25 $9.44 24.75 0 4 5 6