Pierre has entered marks obtained by the students in all the classes he teaches in a spreadsheet.Now he wants to highlight some data according to his specifications.Which spreadsheet feature should he use?
A) Sorting and filtering
B) Run macros
C) Conditional formatting
D) What-if analysis

Question

Quizplus · Accepted Answer

Conditional formatting allows Pierre to apply specific formatting to cells based on their contents. He can set rules for highlighting data that meet certain criteria, such as marking all students who scored below a certain grade in red. Sorting and filtering would only rearrange the data and not highlight it, while running macros and what-if analysis are not relevant to Pierre's specifications in this scenario.

Pierre Has Entered Marks Obtained by the Students in All