Show:
Funtions
References
Layout
Formatting
100
adds all the numbers in a range of cells
What is SUM
100
cell reference taht adjusts to a new location when copied or moved.
What is Absolute cell reference
100
the space formed by the intersection of a row and a column; the basic unit of a worksheet
What is cell
100
to arrange a list of words or numbers in ascending or descending order.
What is sort
200
returns the average (arithmetic means) of its arguments.
What is AVERAGE
200
cell reference that contains both relative and absolute references.
What is Mixed cell reference
200
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
200
sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest
What is Ascending
300
returns the number of cells in a range that contains numbers.
What is COUNT
300
a prewritten formula that makes it easy to perform common calculations
What is Function
300
a vertical group of cells in a worksheet identified by letters
What is column
300
sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest
What is Descending
400
returns the largest value in a set of values.
What is MAX
400
a function that automatically adds the values in the cell directly above or to the left of the active cell.
What is Autosum
400
a horizontal group of cells in a worksheet identified by numbers
What is Row
500
Returns the smallest value in a set of values.
What is MIN
500
an equation that calculates a new value using values currently on a worksheet.
What is Formula
500
the position of data within a cell
What is Alignment