Chapter 14

Match The following

• Value by which it becomes smaller.

• Data Series

• Number by which each value increases.

• Range

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

• Worksheet Tabs

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

• Increment

• Group of cells next to each other.

• Decrement

Match the following

• formula automatically changes when it is copied

• Syntax

• function's name

• relative reference

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

• keyword

• which is data the unction must use

• argument

• rules of wording

• absolute reference

Match the following

• automatic data entry feature

• cell

• coded access word

• Autofill

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

• 3D references

• include it within another function.

• Password

• range on a specific worksheet

• Nest

Match the following

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

• active cell

• the cell currently in use

• function

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

• formula

• are built in formula for performing calculations.

• cell adress

• mathematical expression

• 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