1-The ________ feature searches cells, replacing each match it finds with a provided replacement value?

2-Excel's Shrink to Fit command allows the user to stretch or shrink the width, height, or both of printed output for the output to fit on a specific number of pages.

True

False

3- A predefined formula is called a

criteria.

data bar.

filter.

function.

4- Excel's ________ function retrieves the date and time from the computer's calendar and clock.

CLOCK

CALENDAR

NOW

TIME

5- A ________ displays and summarizes totals from other worksheets.

data bar

sheet tab

summary sheet

detail sheet

6- A value or expression that can be evaluated as true or false is called a logical test.

True

False

7- By including worksheets in a ________, you can enter or edit data on them simultaneously.

theme

collection

chart

group

8- Excel provides only one technique for changing the name of a worksheet.

True

False

9- If a column of data holds the letter grades for a class, the ________ function could be used to determine how many students had a grade of "A".

MEDIAN

SUM

COUNTIF

IF

10- An Excel ________ is a series of rows and columns that contains related data that is managed independently from the other data in the worksheet.