Do you know the difference between an array and a range? How about differentiating between a function and a formula? Excel has hundreds of key terms, and some are more intuitive than others. Understanding some of the jargon will go a long way to helping you understand other aspects of the program.
Microsoft has its ownExcel glossarycontaining hundreds of terms and definitions. However, in this article, we have chosen some of the more frequently used terms that will get you on your way, whether you’re reading anExcel How-To Geek guideor you’veapplied for a job that requires Excel knowledge. In short, this is a must-know list, not a comprehensive list.
We’ve added How-To Geek article links to some of the terms in this list, which you can click to learn more about how to use that feature. Press Ctrl+F or Cmd+F to quickly search for a keyword in this article.
A
Active: An Excel worksheet, its content, or a cell is active when selected. The name of the active worksheet will appear as a bold tab at the bottom of your window, and the active cell will have a bold border.
Add-in: Tools that you install on your computer to create additional functions in Excel, such as a translation or a calendar add-in.
Array: A set of data within a range of cells. For example, if cells A1 to A20 contain data, A1:A20 is the range, and the data within those cells is the array. An array formula is used to perform multiple calculations at the same time.
B
Border: A line that is added to the outside of a cell or object. Cells can have top, bottom, left, or right borders, or a combination of any of these. While gridlines do not print by default, borders do.
C
Cell (reference): A cell is an Excel box that is distinguished by the gridlines, and each cell edge is a row or column line. Each cell contains its own data and has its own reference. A cell reference is its column and row location (for example, cell B2 is in column B, row 2).
Conditional Format: Formatting that is automatically applied to a cell based on specific conditions. For example, all cells containing the word “DONE” might have a green background due to conditional formatting rules that have been applied to those cells. Excel offers preset conditional formatting rules, or you can define specific parameters. Click Home > Conditional Formatting.
Criteria: Also known as conditions, criteria determine which cells are filtered, evaluated, or counted. For example, an Excel formula containingthe COUNTIF functionwill count the cells containing certain criteria.
D
Data Validation: When applied (via Data > Data Validation), data validation limits what can be entered into a cell. For example, you can define a cell to contain only whole numbers or dates. You can create an error message that appears when the wrong type of data is inserted into a cell, and you can also add a message that appears when a user clicks the cell containing the rule. Data validation can also be used to create a drop-down list of options to appear in the cell.
Drop-down: A list of choices that appears when a trigger is clicked. For example, a drop-down list can appear when you click an option on the ribbon, a filter button in a cell, or acell containing data validation rules.
E
Embed: You can embed a snippet of another file into an Excel worksheet (via Insert > Object). You can also embed a chart within a worksheet, rather than creating a new Excel chart sheet.
F
Fill handle: The small, black dot in the bottom-right corner of a cell, which you can click and drag to apply the same formula to other cells in a range. You can also use the fill handle to make Excelcontinue a sequence that you have begunacross a range of cells.
Filter: Filters let you display only the values in a column that meet the conditions you set. You can also use the FILTER function to filter data by multiple criteria.
Formula (bar): A formula is a combination of functions, cell references, values, operators, and names that, when used together following the equals (=) sign, create a new value. For example, =SUM(A1:D11) is a formula that adds the values in cells A1 to D11, and produces the outcome in the cell where the formula is entered. While the outcome appears in the cell, the related formula appears in theformula bar at the top of the Excel window, where you can edit the formula.
Function: A pre-defined formula that performs a calculation when used in a formula. For example,the AVERAGE functionfinds the mean of the referenced values or cells.
G
Gridlines: Non-printing lines that represent boundaries between cells. You can also add gridlines to charts to make reading the data easier.
Even though cell gridlines do not print by default, you canchange this setting so that they appear on your printout.
H
History: You canview an Excel workbook’s version historyto see the changes that have been made, or revert to a previous version.
L
Legend: In a chart, a legend tells the viewer what each color or pattern refers to. For example, different colors could represent different days in a chart, and the legend makes this clear.
M
Merge: Merging adjacent cells removes their separating gridlines and combines them structurally to create a larger cell.
