Question

carlos has created a large spreadsheet for class. the spreadsheet contains multiple columns and rows of data. some of the data has not been entered and is therefore blank. what can carlos do so that the empty cells will be highlighted in yellow until data is entered?
a he can use minimum value.
b he can use absolute reference.
c he can use cell shading.
d he can use conditional formatting.

Explanation:

Conditional formatting allows setting rules (e.g., "if cell is blank") to automatically apply formatting (like yellow highlighting) to cells that meet the condition. Minimum value finds the smallest number, absolute reference fixes cell references in formulas, and cell shading applies static color—none of these dynamically highlight blank cells until data is entered. Only conditional formatting achieves the required dynamic highlighting.

Answer:

D. He can use conditional formatting.