4. On the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate. a. Beginning in cell F4, 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. IF ANNUAL SALES ARE: THEN THE COMMISSION RATE IS: >=225,000 6% >= 175,000 4% >= 100,000 2%