Create an account
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.
The ___ Options button lists error-checking options following the assignment of an invalid formula to a cell.
Excell automatically appends the ___ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
You should ___ a function name in the Formula AutoComplete list to select the function.
You can use the ___ to check which cells are referenced in the formula assignement to the active cell.
If you do not assign a format to a cell or cells in a column, the column width will remain___ characters.
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ___ values.
To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ___.
Dialog box launcher
The ____ Auto Fill Options that fills the destination area using the format of the sourse area; no content is filled
Fill Formatting Only
Which of the following cell contents is extended to Qtr 3, Qtr 4 and Qtr1 by dragging the fill handle?
The split double arrow mouse pointer ___.
is the result of moving the mouse pointer to the boundry between the column heading A and column heading B.
The Increase indent button indents the contents of a cell to the right by ___ spaces each time you click it.
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ___ error message.
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