Basic Terminology
More Basic Terminology
Formulas
Functions
Miscellaneous
100
The workspace made up of columns and rows where data is entered to create an electronic spreadsheet
What is a Workbook
100
to copy a cell's contents and/or formatting into an adjacent cell or range
What is Fill
100
an equation that calculates a new value using values currently on a worksheet
What is a formula
100
returns the smallest value in a set of values
What is Min
100
a selected worksheet cell that is ready for data entry
What is active cell
200
A grid of rows and columns containing numbers, text, and formulas used to preform calculations
What is a Spreadsheet
200
arranging the shape, size, type, and general makeup of a cell or range
What is Format
200
cell reference that does not adjust to the new cell location when copied or moved
What is an Absolute Cell Reference
200
returns the largest value in a set of values
What is max
200
a horizontal group of cells in a worksheet identified by numbers
What is a row
300
A unique identifier for a cell which is formed by combining the cell's column letter and row number
What is a Cell Reference
300
the space formed by the intersection for a row and a column; the basic unit of a worksheet
What is Cell
300
a number or cell reference used in a formula
What is operand
300
returns the average (arithmetic means) of its arguments
What is Average
300
returns the number of cells in a range that contains numbers
What is Count
400
selected group of cells on a worksheet identified by th ecell in the upper left corner and the cell in the lower right corner, separated by a colon
What is a Range
400
a vertical group of cells in a work sheet identified by letter
What is a Column
400
the mathematical rules used for calculation the value of a formula
What is Order of Operations
400
a prewritten formula thta makes it easy to perform common calculations
What is a Function
400
a cell reference that contains both relative and absolute references
What is a mixed cell reference
500
a graphic representation of values and their relationships; Pie, line, column, bar
What is Chart/ Graph
500
to arrange a list of words or numbers in ascending or descending order
What is sort
500
A symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/)
What is an operator
500
adds all the numbers in a range of cells
What is Sum
500
numeric characters that can be used in calculation
What is Value
M
e
n
u