1. 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.

   Table EX 6.1 displays calculations for commission rates based on annual sales.

   IF ANNUAL SALES ARE:	THEN THE COMMISSION RATE IS:
   >=225,000	6%
   >=175,000	4%
   >=100,000	2%
   <100,000	0%

2. Fill the formula down through cell F64. If necessary, format the range as a percentage, and center the values in the cells.
3. In cell G4, calculate the commission earned by multiplying the annual sales by the commission rate (E4*F4).
4. Add a rounding function to the formula in cell G4 to round the result to two decimal places.
5. Fill the formula down through cell G64. If necessary, format the range using the default