Question $4$

$0\mathrm{.}3$ pts

For which situation would you use the SWITCH function?

You have a spreadsheet with a list of articles and a column containing authors' initials $($JD$,$ KM$,$ MP$,$ RG$).$ You want to create another column that evaluates the initials and returns their respective names

You woht to calculate a three$-$tier bonus based on salaries for employees: $5\%$ bonus for employees who exceeded their goals, $3\%$ bonus for employees who met their goals, and $0\%$ for employees who did not meet their goals.

You have a list of graduating students. You want to calculate the average GPA for only students graduating with a marketing degree

You want to display a bonus if an employee earned $25$ on a performance evaluation and was hired before $\frac{1}{1}\frac{?}{2021}.$

For which situation would you use the SWITCH function?

You have a spreadsheet with a list of articles and a column containing authors' initials $($JD$,$ KM$,$ MP$,$ RG$).$ You want to create another column that evaluates the initials and returns their respective names

You w$$nt to calculate a three$-$tier bonus based on salaries for employees: $5\%$ bonus for employees who exceeded their goals, $3\%$ bonus for employees who met their goals, and $0\%$ for employees who did not meet their goals.

You have a list of graduating students. You want to calculate the average GPA for only students graduating with a marketing degree

You want to display a bonus if an employee earned a $5$ on a performance evaluation and was hired before $\frac{1}{1}\frac{?}{2021}.$