Case 2-2
Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status.
-Antoinette's workbook has all the data entered and students' current grades displayed. She would like the current grade cells to display the value in red if it is less than 60. Antoinette needs to add _____ to the cell.
A) cell formatting
B) conditional formatting
C) highlighting
D) fill color

Question

Case 2-2
Antoinette is part of a college department creating a number of student files with Microsoft Excel. She  is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status.
-Antoinette's workbook has all the data entered and students' current grades displayed. She would like the current grade cells to display the value in red if it is less than 60. Antoinette needs to add _____ to the cell.
A) cell formatting
B) conditional formatting
C) highlighting
D) fill color

Quizplus · Accepted Answer

To make the cell value display in red if it is less than 60, Antoinette needs to use conditional formatting. She can set a rule that if the value is less than 60, the font color should be changed to red. This will not only change the color of the cell, but also make it visually stand out for faculty to easily identify struggling students.

Case 2-2 Antoinette Is Part of a College Department Creating a Number