Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab Data Tools group Arrow next to X Clear Validation Circles?
A) What-If Analysis
B) Data Validation
C) Remove Duplicates
D) Consolidate worksheet data.

Question

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?
A) What-If Analysis
B) Data Validation
C) Remove Duplicates
D) Consolidate worksheet data.

Quizplus · Accepted Answer

The option "Data Validation" is the correct one as it is the specific feature that adds validation circles to a worksheet. The other options (What-If Analysis, Remove Duplicates, and Consolidate worksheet data) do not have any direct connection to validation circles.

Which of the Following Will You Select as X in the Series