Create an account
following d4 is the arithmetic operator that directs Excel to perform the multiplication operation
sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range
the width of the column will be increased or decreased so the widest entry will fit in the column
Comma style format
can be assigned to a range of cells by clicking the Comma Style button on the Ribbon, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths
which is made up of two values and a relational operator , is true or false for each cell in the range
formatting that appears only when the value in a cell meets conditions that you specify
electronice mail, the electronic transmission of messages and files to and from other computers using the internet
preceding d4*e4 is an important part of the formula, it alerts excel that you are entering a formula or function and not text
floating dollar sign
appears immediately to the left of the first digit with no spaces, use the Currency style in the Format Cells dialog box
a technique you can use to hide data that might not be relevant to a particular report or sensitive data that you do not want others to see
order of operations
moving from left to right in a formula starting with negation, percentage, exponentiations, multiplications, divisions, additions and subtractions
Page Layout 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