Formulas
Functions
Formatting
Charts/Graphs
Other
100
The mathematical rules used for calculating the value of a formula
What is Order of Operations
100
Adds all the numbers in a range of cells
What is Sum
100
The position of data within a cell
What is alignment
100
A chart that shows the relationship of a part to a whole.
What is pie chart
100
Keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls.
What is Freeze
200
An equation that calculates a new value using values currently on a worksheet
What is formula
200
Returns the average (arithmetic means) of its argument
What is average
200
To arange a list of words or numbers in ascending or descending order
What is sort
200
A chart that uses points connected by a line to illustrate values in a worksheet
What is Line chart
200
The workspace made up of columns and rows where data is entered to create an electronic spread sheet
What is worksheet
300
Value, cell reference, range, or text that acts as an operand in a function formula
What is argument
300
Returns the number of cells in a range that contains numbers
What is Count
300
To copy a cell's contents and/or formatting into an adjacent cell or range
What is fill
300
A graphic representation of values and their relationships: pie, line, column, and bar
What is Chart/Graph
300
Selected group of cells on a worksheet identified by the cell on the upper left corner and the cell in the lower right corner, seperated by a colon
What is range
400
Numeric characters that can be used in a calculation
What is Value
400
returns the largest value in a set of values
What is Max
400
Sort order arraging text or number from A to Z, from smallest to largest, or from earliest to latest
What is Ascending
400
A chart that uses bars of varying heighth to illustrate values in a worksheet
What is column
400
A selected worksheet cell that is ready for data entry
What is Active cell
500
A symbol that indicates what mathematical operation to perform on the operands: Plus +, minus -,multyply*, Divide /
What is Operator
500
Process of chagning values in cells to see how those changes affect the outcome of formulas in the worksheet
What is What if Analysis
500
Arragning the shape, size, type, and general make up of a cell or group of cell
What is Format
500
Where did Sally go during the bombing?
Where is everywhere
500
The space formed by the intersection of a row and column; the basic unit of the worksheet
What is Cell