Chapter 14

Match The following

• Value by which it becomes smaller.

• Worksheet Tabs

• is a set of data that changes by a constant value.

• Data Series

• tabs that show the other worksheets that belong to the same spreadsheet file.

• Increment

• Number by which each value increases.

• Range

• Group of cells next to each other.

• Decrement

Match the following

• formula does not change when it is copied or moved.

• absolute reference

• which is data the unction must use

• keyword

• formula automatically changes when it is copied

• relative reference

• rules of wording

• Syntax

• function's name

• argument

Match the following

• include it within another function.

• Password

• coded access word

• Nest

• when a column and rows meet and make a box.

• cell

• automatic data entry feature

• Autofill

• range on a specific worksheet

• 3D references

Match the following

• are built in formula for performing calculations.

• formula

• mathematical expression

• cell adress

• the cell currently in use

• active cell

• is when a each cell in the grid is identified by a unique name.

• function

• is a number, such as a whole number, a fraction, or a decimal.

• value

3 parts of a function

=SUM(C2:C4)

what is a identifier

2 ways of moving worksheet tab

• Pop-up menu, Click and Drag

• Nest

• Autofill

• Password

Give me an example of Data Formats

Give me 2 examples of Number Formats

Define Macro