A graphic representation of values and their relationships: pie, line, column, bar, scattered
What are charts/graphs?
100
Arranging the shape, size, type, and general makeup of a cell or group of cells
What is format?
100
Adds all the numbers in a range of cells
What is SUM?
100
A symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/)
What is an operator?
100
The space formed by the intersection of a row and a column; the basic unit of a worksheet
What is a cell?
200
A 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 the range?
200
Keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls
What is freeze?
200
Returns the smallest value in a set of values
What is MIN?
200
A number or cell reference used in a formula
What is an operand?
200
A selected cell that is ready for data entry
What is the active cell?
300
A chart that uses points connected by a line to illustrate values in a worksheet
What is a line chart?
300
This is the difference between spreadsheets and Microsoft Excel
spreadsheets are used to solve problems that involve numbers by organizing data into rows and columns
Microsoft Excel is the software we use to make spreadsheets
300
Returns the largest value in a set of values
What is MAX?
300
Value, cell reference, range, or text that acts as an operand in a function formula
What is an argument?
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?
400
A chart that shows the relationships of a part to a whole.
What is a pie chart?
400
To copy a cell's contents and/or formatting into an adjacent cell or range
What is fill?
400
Returns the number of cells in a range that contains numbers
What is COUNT?
400
The mathematical rules used for calculating the value of a formula
What is the order of operations?
400
A cell reference that does not adjust to the new cell location when copied or moved
What is an absolute cell reference?
500
A chart that uses bars of varying height to illustrate values in a worksheet
What is a column chart?
500
1. Vertical groups of cells are identified by these
2. Horizontal groups of cells are identified by these
1. What is letters? 2. What is numbers?
500
Returns the arithmetic means of its arguments
What is AVERAGE?
500
The 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
A cell reference that adjusts to a new location when copied or moved