Which of the following is not true about Find and Replace in Excel A. You can search for bold and replace with italics B. You can decide whether to look for the whole word or not C. You can search in formula too D. You can search by rows or columns or sheets

You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets

The correct answer is D. You can search by rows or columns or sheets.

A. You can search for bold and replace with italics. This is true. You can use the Find and Replace dialog box to search for specific text and replace it with other text. You can also use the Find and Replace dialog box to search for formatting, such as bold or italics.

B. You can decide whether to look for the whole word or not. This is true. You can use the Find and Replace dialog box to search for the entire word or just part of the word.

C. You can search in formula too. This is true. You can use the Find and Replace dialog box to search for text in formulas.

D. You can search by rows or columns or sheets. This is not true. You can only search for text in a specific cell or range of cells. You cannot search by rows or columns or sheets.

Exit mobile version