Advertisement Upgrade to remove ads

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.

Having trouble? Click here for help.

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.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set