On the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate.

a$.$ Beginning in cell F$4,$ enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.

$\backslash$table$[[$IF ANNUAL SALES ARE:,THEN THE COMMISSION RATE IS:$],[225,000,7\%$