Excel Tables Basics

This tool has a criteria range separate from the actual data.

• AutoFilter
• Sort
• Structured reference
• Advanced Filter

Text files that use a special character, such as a comma, to separate fields.

• Delimited

• Field

• Record

• Sorting

What is data that originated in another program or format?

• Internal data
• Outside data
• Source data
• External data

What is a column of data called?

• Record
• Field
• Field Name
• Structured reference

What is the title found in the header row called?

• Title
• Header name
• Field name
• Structured reference

Which command recognizes a pattern and duplicates it?

• PivotTable
• Pattern fill
• Duplicate fill
• Flash fill

The row that contains the descriptive titles or labels for each column is called the ____________ row.

• Title
• Field
• Label
• Header

A row of data is called a ________________.

• field
• record
• row
• column

What automatically inserts summary rows for data that are arranged in related groups?

• Group
• Outline
• Subtotal command
• PivotTable

A ____________ contains basic data, no formatting, and uses a special character to separate data in columns and rows.

• Word file
• text file
• Access file
• Excel file