Create an account
The primary document that you use in Excel to store and work with data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.
The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command.
The identification of a specific cell by its intersecting column letter and row number.
Absolute cell reference
A cell reference that refers to a cell by its fixed position in a worksheet and that does not change when the formula is copied.
The default format that Excel applies to numbers-whatever you type in a cell will display, with the exception that trailing zeros to the right of decimal point will not display.
Accounting number format
The Excel number format that applies a comma separator where appropriate, inserts a fixed 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 accomodate parentheses for negative numbers.
Tab scrolling buttons
Buttons to the left of the sheet tabs used to display Excel sheet tabs that are not in view.
Drag and drop
A method of moving or copying the content of selected cells in which you point to the selection and then drag it to a new location.
Clustered bar chart
A chart type that is useful when you want to compare values across categories; categories are typically organized along the vertical axis, and the values along the horizontal axis.
A prewritten formula that performs calculations by using specific values in a particular order or structure.
The Excel function that adds a group of values and then divides the result by the number of values in the group.
In an Excel function, the values in parentheses used to perform calculations or operations.
The type of function that tests for specific conditions and typically uses conditional tests to determine whether specified conditions are TRUE or FALSE.
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