3. On the Sales Data worksheet, enter a formula in cell J4 to find the sales associate's region by extracting the first three characters of the sales associate's ID in cell C4. Use cell references where appropriate. Fill the formula down through cell J64. 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. THEN THE COMMISSION RATE IS: IF ANNUAL SALES ARE: >=225,000 6% >=175,000 4% 2% >=100,000 =225,000 6% >=175,000 4% 2% >=100,000