Which operation would replace all instances of the word 'Coffee' with 'Office Supplies' in the worksheet?

Which operation would replace all instances of the word 'Coffee' with 'Office Supplies' in the worksheet?

• A. Find and Replace with Replace All
• B. Delete
• C. Copy
• D. Insert Date

Answer: (A)

Find and Replace lets you locate a specific word in a worksheet and substitute it with another text. When you use Find and Replace with Replace All, every occurrence of the word "Coffee" is swapped to "Office Supplies" across the worksheet, saving time and ensuring consistency. Deleting would remove the word rather than replace it; Copy would duplicate text without changing what's there; Insert Date would add a date, not substitute text. So this operation best achieves the required substitution.

Find and Replace lets you locate a specific word in a worksheet and substitute it with another text. When you use Find and Replace with Replace All, every occurrence of the word "Coffee" is swapped to "Office Supplies" across the worksheet, saving time and ensuring consistency. Deleting would remove the word rather than replace it; Copy would duplicate text without changing what's there; Insert Date would add a date, not substitute text. So this operation best achieves the required substitution.