At the Find and Replace dialog box with the Replace tab selected, which of the following is not one of the buttons that display?

Select one:

a. Replace All

b. Replace

c. Replace Next

d. Find All

Suppose that you want to replace all occurrences of 100 with 500. What option should you select at the Find and Replace dialog box to prevent 1000 from being replaced by 5000?

Select one:

a. Within

b. Look in

c. Match entire cell contents

d. Match case

When sorting data by more than one column, specify the first column in the Sort by option box at the Sort dialog box and specify the second column in the _____ option box.

Select one:

a. Column 2

b. Next by

c. Then

d. Then by

Which of the following icons indicates that the rows in a worksheet have been filtered?

Select one:

a. a white plus symbol

b. a two-headed arrow

c. a funnel

d. an exclamation point