A document that stores and manipulates data in columns and rows.

A file that contains one or more related worksheets.

A single spreadsheet within a workbook.

The default file extension for Excel workbooks.

A frozen row or column that will stay visible on the screen no matter where you scroll on the worksheet.

Temporarily removing a row or column information from view. However, the information is not deleted.

This paste option applies the formatting from copied cells to destination cells.

This paste option enters the values of the copied cells. It does not copy formulas or source formatting.

This paste option switches the rows and columns of the copied cells.

By default, these cells cannot be edited when a worksheet is protected.

Portrait, where the long edge of the paper is vertical; and Landscape, where the long edge of the paper is horizontal.

Designates a section of a worksheet to be printed. Information outside the print area will not be printed.

These allow you to designate rows or columns to be repeated on each printed page. They are especially useful for printing labels and row/column headers.

This option prevents locked cells from being edited. You also have the option of adding password protection to a worksheet.

A feature that automatically adjusts the width and height of a column, row, cell, or header.

Draws an outline around a cell or group of cells.

Predefined formatting options that can be applied to cells or groups of cells.

The color of the cell background.

Combines selected cells into one large cell, then centers the content.

Displays numerical information, such as a date, monetary value, percentage, phone number, etc.

When activated, text will begin a new line when it reaches the end of a cell instead of continuing beyond the cell boundary.

Basic math operations like addition (+), subtraction(-), multiplication (*), and division(/).

A feature in Excel that automatically performs a calculation (like addition) on a group of numbers.

A set of calculations that are applied to values in a spreadsheet.

A workbook tool that displays the contents of the active cell; it can be used to enter new values and formulas.

A computational procedure that performs a specific operation.

The values inside the parentheses of a function.

A method of identifying cells in a spreadsheet formula based on their locations, rather than the location of the formula.

A function that calculates the average value of a group of numbers based on a given criteria.

A function that counts the number of cells within a specified range that meet a given criteria.

A function that adds together all of the values in a group of numbers based on a given criteria.

A function that evaluates a condition as TRUE or FALSE, then returns a unique result for each outcome.

A method of identifying cells in a spreadsheet formula based on the location of the formula, rather than the location of the cells.