Question

question 14 of 25
you are editing the data in a spreadsheet and wish to replace all instances of
the word \unknown\ with the word \known.\ what would be the easiest way to
do that?

a. click ctrl + f (or cmd + f on a mac) and manually replace the
content in each highlighted cell.

b. right - click each column header and choose
eplace.\

c. choose
eplace\ and then right - click each column.

d. click ctrl + f (or cmd + f on a mac) and then choose
eplace.\

Explanation:

To replace all instances of "Unknown" with "Known" in a spreadsheet, the find - replace feature is used. The shortcut Ctrl + F (or Cmd + F on Mac) opens the find dialog, and then choosing "Replace" (usually there is a "Replace" option within the find functionality or a related "Find and Replace" option) allows for bulk replacement. Option A is manual and time - consuming. Options B and C have incorrect procedures as right - clicking column headers or columns in that way doesn't provide the standard replace functionality for all instances of a word. Option D describes the correct sequence: first use the find shortcut and then access the replace option.

Answer:

D. Click Ctrl + F (or Cmd + F on a Mac) and then choose "Replace."