Please see below. Need help with this asap please and thank you. CEFGHKA B1 Function: SUM; Formula: Subtract, Multiply; Cell ReferencingStudent Work Area3 Using Excel to Calculate Payroll AmountsPROBLEMRequired: Provide input into cells shaded in yellow in this template.Use mathematical formulas with cell references to the Problem area45 Betsy Strand's payroll information is provided here.or work area as appropriate. Use the SUM function to add anynecessary amounts.62416.00Regular hourly wage rateHourly rate for work in excess of 40 hoursHours worked during a January pay periodFederal income tax withholding7%2424.008479Compute Betsy Strand's gross earnings and net pay for the payperiod.$95.0010FICA tax rate7.65%1112Gross earnings:Regular pay13 Betsy has no voluntary deductions.1415Overtime pay16Total gross earnings1718Gross earnings19FICA taxes withheld2021Federal income taxes withheld2223Net pay2425

Gross earnings are the earnings of the individual without considering the effect of taxes. Net Pay…

Function: SUM; Formula: Subtract, Multiply; Cell Referencing Student Work Area Using Excel to Calculate Payroll Amounts PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area Betsy Strand's payroll information is provided here. or work area as appropriate. Use the SUM function to add any 24 16.00 Regular hourly wage rate Hourly rate for work in excess of 40 hours Hours worked during a January pay period Federal income tax withholding necessary amounts. 24 24.00 47 Compute Betsy Strand's gross earnings and net pay for the pay 24 7.65% 95.00 1 FICA tax rate period. 2 Gross earnings: Regular pay 3 Betsy has no voluntary deductions. 4 _5 Overtime pay 16 17 Total gross earnings 18 Gross earnings 2$ 19 FICA taxes withheld 20 21 Federal income taxes withheld 22 23 Net pay 24