Question

bjorn has created a large spreadsheet that contains multiple columns and rows of data. his boss has requested that he ensure there are no duplicate values in the spreadsheet. what could bjorn use to automatically highlight cells containing specific text within his spreadsheet?
a absolute reference
b cell shading
c conditional formatting
d minimum value

Explanation:

Conditional formatting in spreadsheets allows users to automatically apply formatting (like highlighting) to cells based on specific conditions, such as containing duplicate values or specific text. Absolute reference fixes cell references in formulas, cell shading is manual formatting, and minimum value finds the smallest number—none of these automate highlighting based on content conditions. Thus, conditional formatting is the correct tool.

Answer:

C. Conditional formatting