An Excel file that contains one or more worksheets.
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.
Another name for a worksheet.
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.
Data in a cell-text or numbers.
Data in a cell made up of text only.
Data in a cell made up of numbers only.
Another name for a text value.
An Excel window area that displays the address of a selected cell.
A command with which you can display text on multiple lines within a cell.
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.
A specific way that Excel displays numbers.
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.
A graphic representation of data in a worksheet that shows comparisons, patterns, and trends.
The chart axis that is usually the horizontal axis and contains categories.
The chart axis that is usually the vertical axis and contains data.
To pull out one or more slices of a 3-D pie chart to emphasize a specific slice or slices.
A set of design elements that provides a unified look for colors, fonts, and graphics.
The labels along the lower border of the workbook window that identify each worksheet.
Tab scrolling buttons
Buttons to the left of the sheet tabs used to display Excel sheet tabs that are not in view.
A sequential number assigned to a date.
A temporary storage area for text and graphics.
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.
The target destination for data that has been cut or copied using the Clipboard.
The mathematical rules for performing calculations within a formula.
A worksheet that displays and summarizes totals from other worksheets in a workbook.
A worksheet that contains the detailed information in a workbook.
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.
A column in an Excel table that uses a single formula that adjusts for each row.
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.
A type of function that summarizes a group of measurements.
The function that returns the serial number of the current date and time.
An Excel function the determines the smallest value in a selected range of values.
An Excel function that determines the largest value in a selected range of values.
The type of function that tests for specific conditions and typically uses conditional tests to determine whether specified conditions are TRUE or FALSE.
Conditions that you specify.
Please allow access to your computer’s microphone to use Voice Recording.
We can’t access your microphone!
Click the icon above to update your browser permissions above and try again
Reload the page to try again!
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.
Your microphone is muted
For help fixing this issue, see this FAQ.