Which feature in Excel allows you to search for a value and replace it with another value?

• A. Find and Replace
• B. Replace All
• C. Find
• D. Search

Answer: (A)

Find and Replace is the tool that lets you locate a value and swap it for another in one step. You can open it with Ctrl+H or via the Home tab > Find & Select > Replace. In the dialog, you specify the value to find and the replacement value, choose the scope (worksheet or workbook), and decide whether to replace a single occurrence or all matches. This is the best fit because the question asks for a feature that performs both searching and substituting, which is exactly what Find and Replace does. The Find option by itself only locates values without changing anything, and Replace All is the action within the same dialog that applies the substitutions—but it’s part of Find and Replace, not a separate feature. There isn’t a separate “Search” feature for replacements in Excel; the replacement capability is bundled into Find and Replace.