Create an account
The ___ function sums the numbers in the specified range and then divides the sum by the number cells with numeric values in the range.
An easy way to verify that a formula references the cells that you want it to reference is to use Excel's _____.
Formatting that appears only when the value in a cell meets specific conditions is called ____.
____ means that the width of a column will be increased or decreased so the widest entry will fit.
To alert Excel that you are entering a formula and not text, type an ___ preceding the formula.
If the following arithmetic operations all are found in a formula with no parentheses, which one is completed last?
when you copy a formula with relative cell references down a row, ___
The row references change in the formula
You can select a range using the keyboard, just press the ___ then use the arrow keys to select the desired range.
You can enter functions
With the keyboard or mouse
The sum menu
And the Insert Function box in the formula bar
To assign a dollar sign to appear immediately to the left of the first digit with no spaces, us a ___.
Floating dollar sign
When Excel automatically sets the width of a column based on the widest entry in the column, it is called ___.
In the formula =4*6-8, the subtraction operation is completed before the multiplication operation. T/F
When an error occurs in a formula in a cell, Excel displays the Trace Error button next to the cell, and places a green triangle in the upper left of the cell. T/F
To use Range Finder to verify that a formula contains the intended cell reference, double-click the cell containing the formula you want to check. T/F
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