Exasilabt.

MODIFIED: FALI SEMESTER $2023$

TAB "EMPLOYEES"

Clean up the Employee Name in tas "EMPLONEES' to be incomplance with the format "Doe, John"

Break the Employee Name into First Name $($John$]$ and Last Name $[$Doe$)-$ please note that no middle nam,

Create employee email address with format: First Name istiName gxyz$.$con

Hishight employees having haur rate more than $$60$

TAB MAYROLI$=$

$5.$ Glculate Gers Earnings

$6.$ Calcusate Deduction kmount $($Deduction amount $=$ HCSP $+$ Retirement $+401(k)+$ Heath linsurance $+$ Dent

$7.$ Calculate Withholding amount $($Withnalding emount $-$ State WH $+$ Federal WH $+$ Social Security Tax $+M_t$

Please put totals in toe the columns in requlrements $5-7($Uit of the SUM function is recommended$).$ Your Fallure to include totals wili resuit in the loss of points In accordance with the grading ruberic.