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

Please allow access to your computer’s microphone to use Voice Recording.

We can’t access your microphone!
Click the icon above to update your browser permissions above and try again
Example:

Reload the page to try again!
Reload

Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Your microphone is muted
For help fixing this issue, see this FAQ .