Question 5
Add conditional formatting.
Color Scales: Green –White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"
See the explanation below
Correct answer: A
Explanation:
Step 1: Click cell C3Step 2: Shift-Click cell S25.Step 3: On the Home tab, under Format, choose Conditional Formatting, and choose New Rule... Step 4: In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green. Step 5: In the same dialog box set Midpoint type to Percentile, set Midpoint Value to 70, and set Midpoint Color to White. Also set Maximum Type to Number, Maximum value to 25, and Maximum Color to Red. Finally click OK.
Step 1: Click cell C3
Step 2: Shift-Click cell S25.
Step 3: On the Home tab, under Format, choose Conditional Formatting, and choose New Rule...
Step 4: In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green.
Step 5: In the same dialog box set Midpoint type to Percentile, set Midpoint Value to 70, and set Midpoint Color to White. Also set Maximum Type to Number, Maximum value to 25, and Maximum Color to Red. Finally click OK.