Excel - Bus. Tech.
Show formulas
A command that displays the formula in each cell instead of the resulting value.
Freeze panes
A command that enables you to select one or more rows or columns and locks them into place.
Function
A formula that Excel has already built for you
Row
A horizontal group of cells in a worksheet
SUM Function
A predefined formula that adds all the numbers in a selected range of cells.
Column
A vertical group of cells in a worksheet
Auto Fill
An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.
Workbook
An Excel file that contains one or more worksheets.
AVERAGE Function
An Excel function that adds a group of values, and then divides the result by the number of values in the group.
Spreadsheet
Another name for a worksheet
X-axis
Another name for the horizontal axis
Y-axis
Another name for the vertical axis
Active Cell
The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command.
Cell
The intersection of a column and a row
Filter
The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify.
Fill handle
The small black square in the lower right corner of a selected cell.
Range
Two or more selected cells on a worksheet
Select all box
A box in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet
Legend
A chart element that identifies the patters or colors that are assigned to the categories in the chart
MAX Function
An Excel function that determines the larges value in a selected range of values.
MIN Function
An Excel function that determines the smallest value in a selected range of values
MEDIAN Function
An Excel function that finds the middle value that has as many values above it in the group as are below it
Formula bar
An element in the Excel window that displays the value or formula contained in the active cell; here you can also enter or edit values or formulas
Name box
An element of the Excel window that displays the name of the selected cell, table, chart, or object.
Formula
An equation that performs mathematical calculations on values in a worksheet.
Chart
The graphic representation of data in a worksheet; makes the data easier to understand than a table of numbers
Cell reference
The identification of a specific cell by its intersection column letter and row number.
Sheet tabs
The labels along the lower border of the Excel window that identify each worksheet.
Worksheet
The primary document that you use in Excel to work with and store data
Sort
The process of arranging data in a specific order based on the value in each field.