7
RCMultiple Choice

Pivot Tables and Pivot Charts — Cumulative exam

Question 7 • Computer Applications - Office 2016 - EL3520 A

Which function can NOT be performed using the Conditional Formatting option?

Answer
A
Insert icons that visually display the ranking or rating of values in a selected range.
B
Apply conditional formatting to dates that fall within specified date ranges.
C
Use conditional formatting to highlight any duplicate values or data in a worksheet.
D
Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.

Explanation

Conditional Formatting can add icon sets to show rankings or ratings, format dates that meet specified conditions, and highlight duplicate values. It does not check spelling or language, so it cannot dynamically underline spelling errors in red or green; that is handled by spelling and proofing tools.

AI-written and checked against the verified answer.

Previous
Next