How can we help?

You can also find more resources in our Help Center.

21 terms

spreadsheet vocabulary

STUDY
PLAY
Absolute reference
the method of copying or moving a formula thdat keeps its cell reference exactly as they are
Argument
the data that a function will use
Asterisk(*)
spreadsheet symbol for multiplication
Caret(^)
spreadsheet symbol for expontials
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 symbol that makes a mathical statement; a standard procedure for solving a class of mathematical promblems
Function
a set of mathematical processes using multiple sets of data that ultimately derives ata a final answer; Examples: Average, Sum, MIN(Minimum), MAX(Maximum),SQRT(Square root)
Handle(excel)
teh small square a the lower right corner of cell used to select a range
Increement
the number by which each value in a series increases
Keyword
ina 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 in on its new location
Slash(/)
spreadsheet symbol for division
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