Charts
Functions
Parts of a Spreadsheet
Dealing With Cells
Other
100
a graphic representation of values and their relationships
What is charts/graphs
100
a prewritten formula that makes it easy to perform common calulations
What is a function
100
the space formed by the intersection of a row and a coulmn; the basic unit of a worksheet
What is a cell
100
a number or cell reference used in a formula
What is a operand
100
the position of data within a cell
What is alignment
200
a chart that uses bars of varying height to illustrate values in a worksheet
What is column chart
200
adds all the numbers in a range of cells
What is SUM
200
a selected worksheet cell that is ready for data entry
What is a active cell
200
value, cell reference, range, or text that acts as an operand in a function formula
What is an argument
200
to arrange a list of words or numbers in ascending or descending order
What is sort
300
a chart that uses points connected by a line to illustrate values in a worksheet
What is line chart
300
returns the largest value in a set of values
What is MAX
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 a range
300
a unique identifier for a cell which is formed by conbining the cell's column letter and row number.
What is a cell reference
300
arranging the shape, size, type, and general makeup of a cell or group of cells
What is format
400
a chart that shows the relationship of a part to a whole
What is a pie chart
400
returns the average (arithmetic means) of its arguments
What is AVERAGE
400
a vertical group of cells in a worksheet identified by letters
What is a column
400
cell reference that adjusts to a new location when copied or moved
What is a relative cell reference
400
an equation that calculates a new value using values currently on a worksheet
What is formula
500
sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest
What is ascending
500
returns the number of cells in a range that contains numbers
What is COUNT
500
a horizontal group of cells in a worksheet identified by numbers
What is a row
500
cell refernce the does no adjust to the new cell location when copied or moved
What is an absolute cell reference
500
a symbol that indicates what mathmatical operation to perform on the operands
What is operator
M
e
n
u