Question: Which Excel feature allows you to select all cells in the column with inconsistent formulas compared to the rest of the column?
- On the Home tab, click Go To > Special > Column differences.
- On the Formulas tab, click Trace precedents.
- On the Formulas tab, click Trace errors.
- On the Formulas tab, click show formulas
Answer: The correct answer of the above question is Option A:On the Home tab, click Go To > Special > Column differences.