All employees with one or more years of service are eligible for a bonus. Pay Grade $1$ employees receive $$3,000($cell U$2),$ Pay Grade $2$ employees receive $$6,000($cell U$3),$ and Pay Grade $3$ employees receive $$8,000($cell U$4)$In the Bonus column, use the IFS function to calculate the bonus. For employees in pay grades over $3,$ there is no bonus $.($HINT: the AND function is used in the logical test within the IFS function because you have to test if the years of service $>=1$ AND each specific pay grade $)$ In the Salary Increase column, enter IF and OR functions to insert the text "Not Eligible" if the individual's job status is a consultant $($CN$)$ or the pay grade is $4.$ Leave the cell blank if the employee is eligible for a salary increase $.($ HINT: the logical test for the IF function requires the OR function $)$