Create an account
Using ________ allows the user to stretch or shrink the width, height, or both of printed output.
scale to fit
The ________ function counts the number of cells within a range that meet a certain criteria.
The IF function returns one value if a logical test is false and a different value if the logical test is true.
The MEDIAN function adds a group of values and then divides the sum by the number of items in the group.
When pasting a range of cells you only need to point to or select the ________ of the paste area.
upper left corner
Excel assigns a serial number to each date entered, which allows dates to be treated the same as other numbers in the worksheet.
Dates can be treated as other numbers because Excel assigns a ________ value to the date as it is entered.
If a cell's width is too narrow to properly display the numeric contents of the cell, Excel displays a series of ________ symbols.
An Excel ________ is a series of rows and columns that contains related data that is managed independently from other data in the worksheet.
The functions AVERAGE and MEDIAN are examples of ________ functions, which are useful when the user needs to analyze a group of measurements.
Excel's Print Titles command allows the user to specify rows and columns that will repeat on each printed page.
In Excel, data can be moved from one area to another using the mouse and a technique called drag and drop.
Excel's ________ function adds all of its arguments then divides the sum by the number of arguments.
The Excel function ________ would be used to find the lowest score on a series of student test scores.
The target destination for data that has been cut or copied using the Office Clipboard is called the paste area.
Using ________ searches the spreadsheet for one value and replaces it with another.
Find and Replace
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together