Reference no: EM131871628
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.