What is the purpose of the 'Find & Replace' feature in Excel, and how do you use it?
Instruction: Describe how to locate specific text in a dataset and replace it with different text.
Context: This question evaluates the candidate's ability to efficiently modify data by using the 'Find & Replace' feature, essential for correcting or updating large datasets.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
Find & Replace locates matching content and substitutes new content within the chosen scope. Start on a copy or ensure the change can be undone, especially when formulas are involved.
Select the intended range, open Home → Find & Select → Replace (Ctrl+H in Windows desktop Excel), enter the search and replacement text, and inspect the available options...