A | B |
Absolute reference | the method of copying or moving a formula that keeps its cell references exactly as they are |
Argument | the data that a function will use |
Caret (^) | spreadsheet symbol for exponentials |
Cell | each intersection of a row and column in a spreadsheet |
Cell address (Cell reference) | cells are referred to by their column letter and row number, such as cell A1 |
Data | information made up of numbers and/or letters that can be stored in a database or spreadsheet |
Data Series | a set of data that changes by a constant value |
Decrement | the number by which each value in a series decreases |
Formula bar | area above the column headers used to input and edit cell data |
Formula | a group of symbols that make a mathematical statement; a standard procedure for solving a class of mathematical problems |
Function | a set of mathematical processes that the computer knows how to do using multiple sets of data that ultimately derives at a final answer; Examples: Average, Sum, MIN (Minimum), MAX (Maximum), SQRT (Square root) |
Handle (Excel) | the small square a the lower right corner of cell used to select a range |
Increment | the number by which each value in a series increases |
Keyword | in a spreadsheet function’s syntax, the name of the function |
Menu | a list of items or commands |
Range | in a spreadsheet, a group of cells that are next to each other |
Relative reference (address) | the method of copying or moving a formula that changes the values in the formula depending on its new location |
Slash (/) | spreadsheet symbol for division |
Spreadsheet | data stored in rows and columns |
Syntax | the rules for wording a spreadsheet function |
Worksheet tab | a tag that identifies each open worksheet in a spreadsheet program, located in the lower left corner of the screen |