Worksheets
A complete Excel file can contain one or more worksheets.
Workbook
A calculation entered into a cell, always starting with an equal sign (=).
Formula
The area above the worksheet that shows the contents of the active cell.
Formula Bar
A graphical representation of data.
Chart
The cell currently selected, outlined with a thick border.
Active Cell
A single page within a workbook, made up of rows and columns.
Worksheet
A function that adds numbers in a range.
SUM
A shortcut button that automatically creates a SUM formula for a selected range.
AutoSum
A tool that controls what type of data can be entered in a cell.
Data Validation
A tool that shows only the rows of data that meet certain conditions.
Filter
The intersection of a row and a column where data is entered.
Cell
A built-in command that performs a calculation.
Function
Adjusting how data looks (font, color, size, alignment, borders, etc.)
Cell Formatting
Vertical sections in a worksheet, labeled with letters.
Column
A cell reverence that changes when copied. Example: Copying = A1+B1 from row 1 to row 2 becomes = A2+B2.
Relative Reference
Cell Reference
A function that calculates the mean (average) of values.
AVERAGE
A tool that arranges data in ascending (A-Z) or descending (Z-A) order.
Sort
Horizontal sections in a worksheet, labeled with numbers.
Row
A fixed cell reference signs so it does not change when copied. Example =$A$1+$B$1
Absolute Reference
A Group of selected cells
Range
Functions that return the highest (MAX) or lowest (MIN) value in a range.
MAX/MIN
Combines multiple cells into one larger cell and centers the text.
Merge & Center
A small square at the bottom-right of a cell used to copy data, formulas, or create sequences.
Fill Handle
A powerful tool that summarizes, analyzes, and organizes large amounts of data into meaningful reports
Pivot Table