Which of the following can be done by using conditional formatting? Calculate quarterly sales.
Highlight all “no” responses.
Count the number of students in high school.
Calculate average scores on a math test.

B

Step-by-step explanation:

Which of the following can be done by using conditional formatting?

Calculate quarterly sales.

Highlight all “no” responses.

Count the number of students in high school.

Calculate average scores on a math test.

Conditional formatting applies formatting to cells if specific conditions are met. For example, conditional formatting can be used to apply background color to “no” responses in a customer satisfaction survey. This will allow the business owner to quickly locate and read customer complaints and identify areas for improvement.