Which of the following built-in tools in MS Excel allows users to apply conditional color fills, data bars, or icons to cells based on the numerical values they hold? MCQ with Answer and Explanation
Which of the following built-in tools in MS Excel allows users to apply conditional color fills, data bars, or icons to cells based on the numerical values they hold?
A. Format Painter tool
B. Cell Styles manager
C. AutoFormat wizard
D. Conditional Formatting
Answer: Option D
Solution (By JKSSB Mock Tests)
Conditional Formatting changes the visual presentation of cells (such as fill color, border styles, or icon sets) dynamically based on user-defined logical rules or values.
Explanation:
The LEN function returns the number of characters in a text string. LENGTH is not a function, CHAR returns a character based on code, TEXT formats a value.
No comments yet. Be the first to start the discussion!