Create an account
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ________ that you use in algebra.
The adjusted cell references in a copied and pasted formula are called ________ references.
The ________ Options button lists error-checking options following the assignment of an invalid formula to a cell.
The ________ Option button lists formatting options following an insertion of cells, rows, or columns.
The ________ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
The ________ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
Excel automatically appends the ________ to complete the AVERAGE function with you click the Enter box or press the ENTER key.
You should ________ a function name in the Formula AutoComplete list to select the function.
Insert Function box on the formula bar
Clicking the ________ opens the Insert Function dialog box shown in the accompanying figure.
You can use the ________ to check which cells are referenced in the formula assigned to the active cell.
Accounting number format
The ________ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a ________ dollar sign.
If you do not assign a format to a cell or cells in a column, the column width will remain ________ characters.
________ view allows you to create or modify a worksheet while viewing how it will look in printed format.
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