Chapter 14

Match The following

• Group of cells next to each other.

• Worksheet Tabs

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

• Increment

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

• Range

• Number by which each value increases.

• Data Series

• Value by which it becomes smaller.

• Decrement

Match the following

• formula automatically changes when it is copied

• argument

• rules of wording

• absolute reference

• function's name

• Syntax

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

• keyword

• which is data the unction must use

• relative reference

Match the following

• range on a specific worksheet

• Autofill

• coded access word

• cell

• include it within another function.

• Password

• automatic data entry feature

• Nest

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

• 3D references

Match the following

• are built in formula for performing calculations.

• cell adress

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

• value

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

• function

• the cell currently in use

• formula

• mathematical expression

• 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