Chapter 14

Match The following

• Value by which it becomes smaller.

• 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

• Number by which each value increases.

• Decrement

• Group of cells next to each other.

• Data Series

Match the following

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

• absolute reference

• formula automatically changes when it is copied

• argument

• function's name

• Syntax

• rules of wording

• keyword

• which is data the unction must use

• relative reference

Match the following

• include it within another function.

• cell

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

• 3D references

• range on a specific worksheet

• Password

• coded access word

• Autofill

• automatic data entry feature

• Nest

Match the following

• the cell currently in use

• active cell

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

• cell adress

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

• formula

• mathematical expression

• function

• are built in formula for performing calculations.

• 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