Test 2 A

Question 1

Header Row

Answer 1

The first row of the range contains field names.

Question 2

Record

Answer 2

A collection of related fields that are grouped together.

Question 3

Field

Answer 3

Description of a person, place or thing.

Question 4

Field Name or Column Header

Answer 4

A unique label that describes the contents of the data in a column.

Question 5

Sort Fields

Answer 5

The fields that you use to order data.

Question 6

Sort

Answer 6

rearranging the records in a table or range based on one or more fields.

Question 7

Data Definition Table

Answer 7

A documentation that lists the fields to be maintained for each record and a description of the formation that a field will include.

Question 8

Freezing

Answer 8

Keeps a row or column visible at the top of the worksheet no matter how far you scroll down.

Question 9

Custom List

Answer 9

Indicates the sequence in which you want data ordered.

Question 10

Total Row

Answer 10

Used to calculate summary statistics for any column in an excel table.