Excel Vocabulary
Active cell A selected work sheet cell thats ready for data entry
formula an equation that calculates a new value using values currently on a worksheet
Autosum a function that automatically adds the values in the cells directly above or to the left of the active cell
Alignment the position of data within a cell
columna vertical group of cells in a worksheet identifies by letters
Descending dort Order arranging text or arranging text or numbers from Z toA largest to smallest and latest to earliest
cell reference a unique identifier for a cell which is formed by combining the cells column letter and row number
column chart a chart that uses bars of varying height to illustrate values in a worksheet
Argument Value cell reference range or text the tacts as an operand in a function formula
Format arranging the shape size type and general makeup of a cell or group of cells
cell the space formed by the intersection of a row and a column the basic unit of a worksheet
chart/Grapha chart that uses bars of varying height to illustrate values in a worksheet
Fill to copy a cells contents and or formatting into an adjacent cell or group of cells
Freezer keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls
Average return the average (arithmetic means) of its arguments
Count return the number of cells in a range that contains numbers
ascending sort order arranging text or numbers from A to Z from smallest to largest or earliest to latest
label alphanumeric text that will not be used in calculation
min returns the smallest values in a set of values
line chart a chart that uses points connected by a line to illustrate values in a worksheet
Function a prewritten formula that makes it easy to preform common calculations
Max returns the largest values
mixed cell reference cell reference used in a formula
operand a number or cell reference used in a formula
order of operations the math rules used for calculating the value of a formula
operator A symbol that indicates what mathematical operation to perform on the on the operation to perform on the operands plus minus multiply divide
pie chart a chart that shows the relationship of a part to a whole
range selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right
relative cell reference cell reference that adjusts a new location when copied or moved
row a horizontal group of cells in a worksheet identified by numbers
sort to arrange a list of words or numbers in ascending or decending order
spread sheet a grid of rows and columns containing numbers text and formulas used to perform calculations
sum adds all numbers In a range of cells
value numeric characters that can be used in a calculation
work book a collection of related worksheets corner separated by a colon
worksheet the workspace made up of columns and rows where data is entered to create an electronic spreadsheet