basic computer MCQ #1380

Conditional formatting is used for:

basic computer MCQ #1380

  1. Question 1

    Q1. Conditional formatting is used for:

    • A) Highlighting values or cells based on a condition or criteria
    • B) Creating charts and graphs from data
    • C) Adding borders and shading to cells
    • D) Calculating totals and averages

    Answer: Highlighting values or cells based on a condition or criteria

    Explanation: Conditional formatting in Excel automatically changes a cell's appearance (color, font, icons) when its value meets a specified condition or rule.