Chapter 14

Match The following

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

• Range

• Value by which it becomes smaller.

• Data Series

• Number by which each value increases.

• Decrement

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

• Worksheet Tabs

• Group of cells next to each other.

• Increment

Match the following

• which is data the unction must use

• absolute reference

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

• argument

• formula automatically changes when it is copied

• keyword

• function's name

• Syntax

• rules of wording

• relative reference

Match the following

• coded access word

• cell

• include it within another function.

• Autofill

• range on a specific worksheet

• 3D references

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

• Password

• automatic data entry feature

• Nest

Match the following

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

• cell adress

• are built in formula for performing calculations.

• function

• the cell currently in use

• value

• mathematical expression

• formula

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

• active cell

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