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.

MrRoyal MrRoyal · Answer 2 · 2021-09-11T00:14:52+02:00

Conditional formatting involves applying cell formats to certain cells, if and only if they meet certain criteria.

Highlighting all "no" responses can be done using conditional formatting.

Options (a), (c) and (d) are all direct calculations that can be executed using Microsoft Excel functions and formulas such as:

SUM; to calculate quarterly sales (a)
COUNT, to count number of students (c)
AVERAGE, to calculate the average score (d)

However, option (b) indicates that;

The cell is to be highlighted

And the condition for highlighting the cell is that:

The content of the cell is "no"

By comparing the above analysis to the meaning of conditional formatting, we can conclude that, conditional formatting can only be applies to option (b).

Read more about conditional formatting at:

https://brainly.com/question/22754240