Create an account
whatever you type in a cell will display except trailing zeros to the right of a decimal point
symbols with which you can specify the type of mathmatical operation you want to perform in a formula
Accounting number Format
applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at both the right and left edges of the cell to accommodate parentheses for negative numbers.
adds appropriate thousand comma separators and also applies the Accounting Number Format-two decimal places and space for parentheses in the event of a negative number-but without a dollar sign.
Absolute cell references
A cell reference that refers to cells by their fixed position in a worksheet, and that remains the same when the formula is copied.
outlines cells in color to indicate which cells are used in a formula; useful for verifying which cells are referenced in a formula or for quickly positioning the insertion point within the cell to perform editing directly in the cell
Part of a whole expressed in hundredths. Photo album A presentation composed of pictures.
A command that formats the selected cell as a percentage rounded to the nearest hundredth.
Software from Microsoft that provides a website on which employees in an organization can upload and share information.
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