A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.

A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.

A box on the grid identified by the intersection of a column and a row.

Cells that run from top to bottom in a worksheet and are identified by letters.

Task-specific groups divided among the command tabs appropriate to the work a user currently performs.

Task-oriented tabs that are organized on the ribbon.

An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.

In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.

Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.

A toolbar that gives you fast and easy access to the tools you use most often in Excel.

A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007.

A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.

A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.

A collection of worksheets in a single file.

A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.

An Excel feature that automatically fill cells with data, formatting, or both.

To duplicate data from a worksheet to the Clipboard.

An arrow with a plus sign that appears when you select the cell or range of cells you want to copy and hold down Ctrl while you point to the border of the selection. When this pointer appears you can drag the cell or range of cells to the new location.

To remove data from a worksheet. Cut data may be pasted into a new location or locations in a worksheet.

A small square in the lower, right corner of a selected cell or range of cells. Used mainly to copy data to adjacent cells.

A tool identified with symbols such as dotted, dashed, or solid lines that fill the space before tabs.

A bar located between the ribbon and the worksheet in which users can edit the contents of a cell.

A word assigned to a document's properties that makes it easier to organize and find documents.

Text entered in a worksheet that identifies numeric data and is the most common type of text entered in a worksheet. Labels are also used to sort and group data.

A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.

A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.

A location that collects and stores up to 24 copied or cut items that are then available to be used in the active workbook, in other workbooks, and in other Office programs.

To insert data from the Clipboard to a new location in a worksheet.

A group of adjacent cells you select to perform operations on all of the selected cells.

Highlighting text that is to be changed.

Items you directly change, such as keywords

Pre-set settings that determine how Excel behaves when performing an action.

Commands on the default ribbon tabs that are related in functionality.

A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.

Several settings that enable you to change how a document prints.

(1) An area on the ribbon that contains groups of related commands. (2) An area of the Backstage navigation pane that contains groups of related commands.

A file that includes formatting and formulas complete with designs, tools, and specific data types.

A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.

Operators that specify the calculations to be performed.

A reference that identifies a cell's location in the worksheet based on its row number and column letter.

A number or text value entered directly into a formula.

A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.

An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.

A cell reference that uses an absolute column or row reference, but not both.

A group of cells, and occasionally a single cell, with a designated name.

Parentheses inside of parentheses within a formula.

An element that identifies the values to be used in a calculation.

The rules Excel follows to calculate any formula that contains two or more operators.

A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.

The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.

A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.

A symbol or name that represents something else; it can be a cell address, a range of cells, and so on.

A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.

A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.

A function that determines how many cells in a range contain a number.

A function that returns the number of cells in the selected range that contain text or values, but not blank cells.

A function that counts the number of blank cells in a range.

A predefined formula that performs a calculation.

A function that returns the largest value in a set of values.

Two or more cells combined into a single cell.

A function that determines the minimum value in a range of cells.

A function that totals all of the cells in a range.

Arrange in a line or bring into alignment.

A formatting characteristic, such as bold, italic, or underlined text.

An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.

A set of text properties that affects the typeface, size, and similar aspects of text.

A feature found in most Office applications that allows you to quickly copy formatting attributes that you have already applied and "paint" those attributes onto other text, shapes, pictures, and worksheet cells.

A shortcut that enables you to navigate to a web page or a location in another file in just one click of the mouse.

Two or more cells combined into a single cell.

A formatting tool that appears above or below the shortcut menu when you right-click a cell and that displays the most commonly used formatting commands.

A tool that enables you to control specifically what you want to paste after using the Copy or Cut commands, such as cell content, formulas, values, formatting, and much more.

A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more.

A set of formatting attributes that you can apply to a cell or range of cells more easily than by setting each attribute individually.

To automatically display data on the next line when it is too long to display within the cell's width. Wrapping automatically increases a cell's height.

The line between rows or columns.

The identifying letter of a column.

The left-to-right measurement of a column.

A predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items in a workbook.

Something that modifies the appearance of an object.

Lines of text that appear at the bottom of each page.

The lines that display around worksheet cells.

A line of text that appears at the top of each page of a printed worksheet.

The position of the content in a worksheet, so that it prints either vertically or horizontally on a page.

A divider that breaks a worksheet into separate pages for printing

An Excel view in which you can quickly adjust automatic page breaks to achieve a more desirable printed document.

An Excel view that enables you to see what your document will look like before sending it to the printer.

The identifying letter of a row.

The top-to-bottom measurement of a row.

Shrinking or stretching printed output to a percentage of its actual size.

Changes your cell data to change orientation.

Text or a picture that appears in the background of a document; it is similar to a sheet background in Excel.

The empty area of a document in which no content appears.

A command to help you search for certain content.

To prevent portions of a worksheet from moving on the screen. When you freeze panes, such as a row of column headings, the column headings remain visible as you scroll down the worksheet or change magnification.

To make a worksheet invisible.

A portion of a divided window.

An Excel feature that allows you to add content to a text box and replace any matches Excel finds

To make a worksheet visible again.

An Excel feature that allows you to make a worksheet appear bigger (zoom in) or smaller (zoom out).

A feature that automatically groups selected rows in Excel.

A built-in set of filtering capabilities.

To condense groups into single-row headings called outlines.

A condition you specify to limit which records are returned when filtering data. The plural of criterion is criteria.

An electronic file that stores a series of records in a relatively simple format.

A comparatively complex system that can store a large amount of related data, which requires a program to be able to assess and render that data.

A character that separates data entries from one another.

A restriction that Excel uses to determine which worksheet rows to display.

Organizing data so it can be viewed as a collapsible and expandable outline.

A series of steps you record that you might want to repeat frequently to save time.

Single-row headings.

Symbols that add controls next to the row and column headings to change the view of an outlined worksheet.

To separate into components. Also, to interpret character by character.

Predefined formatting in Excel that enables you to apply an elaborate format that makes a table look sleek and professional.

One of the ways to filter a table so that it shows only records containing a certain object. A slicer is a selection panel that floats above a worksheet (the way a chart does).

The sum of values that are grouped together.

A range of cells in a worksheet that contains related data and can be used by a lookup function.

A feature in Excel that ensures data is entered correctly, before it is processed incorrectly.

The parameters of a function.

A formula in which the result is determined by the presence or absence of a particular condition.

A condition you specify to limit which records are returned when filtering data.

An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.

A range of cells in a worksheet that contains related data and can be used by a lookup function.

Data in a table arranged in rows and columns.

In a shared workbook, a feature that includes the name of the person who made each change, when the change was made, and what data was changed.

Text that must be entered before a user can access a secured workbook, worksheet, or worksheet elements.

A workbook set up to allow multiple networked users to view and make changes simultaneously.

A password that combines uppercase and lowercase letters, numbers, and symbols making the password difficult to guess.

A feature that marks and records changes made to a workbook.

A line bordering the chart plot area used as a frame of reference for measurement.

A graphical representation of numeric data in a worksheet.

The entire chart and all its elements.

A sheet that contains only a chart.

Text that provides additional information about a data marker, which represents a single data point or value that originates from a worksheet cell.

A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell.

A row or column of data represented by a line, set of columns, bars, or other chart type.

A chart placed on a worksheet rather than on a separate chart sheet.

An explanatory list that identifies the patterns or colors assigned to the data series or categories in a chart.

A graphical representation of the data in a PivotTable.

A highly configurable table that condenses large amounts of data. A PivotTable is used to analyze and display numerical data in detail and to answer unforeseen questions about data.

The area bounded by axes in a chart.

Miniature graphs that summarize data; typically used to graphically describe trends in data.

Descriptive text that is aligned to an axis or at the top of a chart.

Various artistic mediums and special effects designed for use on photos in Excel.

An image with two colors.

An art-related object, such as a drawing, image, or shape.

A small box on the side and/or corner of the graphic that you click and pull to increase or decrease the size of a graphic.

A set of data that describes and gives information about other data.

Changing from color to black and white or to greater or reduced levels of color.

An editable line, circle, arrow, star, or other form.

A visual representation of information and ideas, such as an organization chart, a flow chart, a process, or a Venn diagram.

A floating box in a worksheet that can contain text or graphics.

An Office feature that combines text and artistic effects.

The parameters of a function.

A formula in which the result is determined by the presence or absence of a particular condition.

A condition you specify to limit which records are returned when filtering data.

An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.

A range of cells in a worksheet that contains related data and can be used by a lookup function.

Data in a table arranged in rows and columns. A table of text, numbers, or values that you use for the formula.

In a shared workbook, a feature that includes the name of the person who made each change, when the change was made, and what data was changed.

Text that must be entered before a user can access a secured workbook, worksheet, or worksheet elements.

A workbook set up to allow multiple networked users to view and make changes simultaneously.

A password that combines uppercase and lowercase letters, numbers, and symbols making the password difficult to guess.

A feature that marks and records changes made to a workbook.

Arrange in a line or bring into alignment.

An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.

Two or more cells combined into a single cell.

A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more

A line bordering the chart plot area used as a frame of reference for measurement.

A graphical representation of numeric data in a worksheet.

The entire chart and all its elements.

A sheet that contains only a chart.

Text that provides additional information about a data marker, which represents a single data point or value that originates from a worksheet cell.

A row or column of data represented by a line, set of columns, bars, or other chart type.

A chart that uses the left side (or top) of the chart as one value axis (y-axis) and the right side (or bottom) of the chart as a second value axis (y-axis)

A chart placed on a worksheet rather than on a separate chart sheet.

A graphical representation of the data in a PivotTable.

A highly configurable table that condenses large amounts of data. A PivotTable is used to analyze and display numerical data in detail and to answer unforeseen questions about data.

A tool that offers Excel users the ability to generate PivotTables very quickly on very large data sets of tens or even hundreds of millions of rows.

A term that describes when two tables have a connection between two fields.

A tool that filters the entire PivotTable, restricting the sums, counts, averages, and so on, to only those fields selected in the slicer or filter field.