In Excel, which feature helps locate specific elements within a worksheet?

In Excel, which feature helps locate specific elements within a worksheet?

• A. Find & Replace
• B. Find & Select
• C. Search
• D. Locate

Answer: (B)

Locating specific elements in a worksheet requires a tool that can search by type and then highlight or select the matches. Excel provides a dedicated Find & Select option that groups multiple search-related actions in one place. You can use it to find formulas, constants, blanks, comments, objects, or conditional formatting, and then jump to or select those cells. This makes it the most flexible for locating items without changing them. Find & Replace also finds data, but its main purpose is to replace matches with new values, which isn’t the same as simply locating. The other terms aren’t standard Excel features used for this task. So the best choice is Find & Select.

Locating specific elements in a worksheet requires a tool that can search by type and then highlight or select the matches. Excel provides a dedicated Find & Select option that groups multiple search-related actions in one place. You can use it to find formulas, constants, blanks, comments, objects, or conditional formatting, and then jump to or select those cells. This makes it the most flexible for locating items without changing them. Find & Replace also finds data, but its main purpose is to replace matches with new values, which isn’t the same as simply locating. The other terms aren’t standard Excel features used for this task. So the best choice is Find & Select.