Use SUM in cells B$10$:C$10.$

Format all values as Comma Style with no decimal places.

Create an IFS function to display a response rating. Note: If your version of Excel does not include the IFS function,

build the following nested IF function

$)))(((11\%,$$$C$$$17,$$$C$$$18$

a$.$

Click cell D$7.$ The response rate and ratings are shown in rows $14$:$18.$

b$.$

Start an IFS function and select $C7$ for the Logical$\_$test$1$ argument. Type $/$ for division and select cell B$7.$

Type $20\%$ to complete the test.

c$.$

Click the Value$\_$if$\_$true$1$ box, select C$15,$ and press F$4($FN$+$F$4)($Figure $6-107).$