G8 Unit 6

A field that stores data that is unique

• Key field

• Data Field

Conditional formatting

• It is a format, such as cell color, which is based on a logical test.

• format only colors

Absolute cell reference

• The value of the cell will stay in different row of the table.

• The value of the cell will stay the same in every row of the table.

Cell reference

• Means they take values from other cells in the Microsoft word

• Means they take values from other cells in the spreadsheet

They are the columns of the table.

• field

• Record

Each ..............................stores all the data about one thing

A positive number means there is a ............................

They are the rows of the table

• field

• Record

Write three advantages of organizing data as a table in a spreadsheet.

• Sort and search the data

• Use formatting to pick out important facts.

• Use formulas to calculate new information

• allow sorting only

In Excel, rows are labeled by letters

• True

• False