Column 1
Column 2
Column 3
Column 4
Column 5
100
sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest
What is ascending
100
returns the average (arithmetic means) of its arguments
What is average
100
arranging the shape, size, type, and general makeup of a cell or group of cells
What is format
100
to arrange a list of words or numbers in ascending or descending order
What is sort
100
the cell that is currently selected is known as the
What is active cell
200
a unique identifier for a cell which is formed by combining the cell's column letter and row number
What is cell reference
200
a prewritten formula that makes it easy to perform common calculations
What is function
200
returns the largest value in a set of values
What is MAX
200
returns the smallest value in a set of values
What is MIN
200
sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest
What is descending
300
returns the number of cells in a range that contains numbers
What is Count
300
the mathematical rules used for calculating the value of a formula
What is order of operation
300
numeric characters that can be used in a calculation
What is Value
300
a function that automatically adds the values in the cells directly above or to the left of the active cell
What is Autosum
300
selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon
What is range
400
a symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/)
What is operator
400
an equation that calculates a new value using values currently on a worksheet
What is formula
400
a vertical group of cells in a worksheet identified by letters
What is column
400
a collection of related worksheets
What is workbook
400
adds all the numbers in a range of cells
What is SUM
500
value, cell reference, range, or text that acts as an operand in a function formula
What is argument
500
a grid of rows and columns containing numbers, text, and formulas used to perform calculations
What is spreadsheet
500
the space formed by the intersection of a row and a column; the basic unit of a worksheet
What is cell
500
the position of data within a cell
What is alignment
500
to copy a cell's contents and/or formatting into an adjacent cell or range
What is fill
M
e
n
u