1
2
3
4
5Category
100
returns the largest value in a set of values
What is max
100
the position of data within a cell
What is alignment
100
returns the smallest value in a set of values
What is min
100
a vertical group of cells in a worksheet identified by letters
What is column
100
a collection of related worksheets
What is workbook
200
the workspace made up of columns and rows where data is entered to create an electronic spreadsheet
What is worksheet
200
keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls
What is freeze
200
to arrange a list of words or numbers in ascending or descending order
What is sort
200
an equation that calculates a new value using values currently on a worksheet
What is formula
200
a symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/)
What is operator
300
returns the number of cells in a range that contains numbers
What is count
300
a grid of rows and columns containing numbers, text, and formulas used to perform calculations
What is spreadsheet
300
alphanumeric text that will not be used in calculations
What is label
300
value, cell reference, range, or text that acts as an operand in a function formula
What is argument
300
a chart that uses bars of varying height to illustrate values in a worksheet
What is column chart
400
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 prewritten formula that makes it easy to perform common calculations
What is function
400
arranging the shape, size, type, and general makeup of a cell or group of cells
What is format
400
a number or cell reference used in a formula
What is operand
400
a unique identifier for a cell which is formed by combining the cell's column letter and row number
What is cell reference
500
process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet
What is what if analysis
500
the mathematical rules used for calculating the value of a formula
What is order of operation
500
a cell reference that contains both relative and absolute references
What is mixed cell reference
500
cell reference that does not adjust to the new cell location when copied or moved
What is absolute cell reference
500
cell reference that adjusts to a new location when copied or moved
What is relative cell reference
M
e
n
u