Question | Answer |
Keeping a cell reference constant when copying a formula | Absolute cell reference |
A spreadsheet function that indicates the average of a group of numbers in a range | AVERAGE |
The cell in which you are currently working | Active cell |
A value needed to calculate a function. For example, the function COUNT needs cell
references as the arguments:=COUNT(A2:D6) | Argument |
A type of graph that represents different quantities by using bars | Bar graph |
The point at which a column and a row intersect or meet | Cell |
The location of a cell as identified by the column letter and row
number | Cell address/cell reference |
Occurs when a formula in a spreadsheet refers to itself. No result is possible
and a warning appears | Circular reference |
Vertical sections of a spreadsheet. Identified by a letter | Column |
A spreadsheet function that counts the number of cells in a range that contains data | COUNT |
Statement that performs a calculation | Formula |
The bar below the standard and formatting toolbars where data entered from the
keyboard is displayed as it is entered into the cell | Formula bar |
Built-in formulas used with a range to perform calculations | Function |
A logical function (formula) that allows the user to set up a condition to test data | IF statement |
Alphabetical text in a spreadsheet | Label |
A paper orientation that is wider than it is tall | Landscape orientation |
A type of graph that shows changes in data over a period of time | Line graph |
A spreadsheet function that indicates the highest value in a range | MAX |
A spreadsheet function that indicates the lowest value in a range | MIN |
A symbol that represents a mathematical function. Examples: greater than, less than,
greater than or equal to | Operator |
A type of graph that divides the total into the parts of a circle | Pie graph |
A paper orientation that is taller than it is wide | Portrait orientation |
A group of cells closely related | Range |
Adjusts the cell references in a formula while retaining the mathematical
processes | Relative cell reference |
Horizontal sections of a spreadsheet. Identified by a number | Row |
A row and column arrangement of data used to enter, calculate, manipulate, and
analyze numbers. They are used to prepare budgets, financial statements, and inventory
management. They are also used to make forecasts | Spreadsheet |
A function used to add numbers in a range | SUM |
A number entered on a spreadsheet | Value |
A spreadsheet tool used to play out different situations to determine outcome | What-if analysis |