Excel Domain 6 Review

A file used to store numbers

A file used to hold data without formatting

A file used to hold music files

A special spreadsheet file containing dates

A process to collect data

Something used to limit the use of data

A way to organize data

A way to combine data

It is a file type restricted to the use of a word processing program.

It uses a comma as a delimiter to separate values.

The file uses a space to separate data.

It contains only numeric data.

It gives information about the data being imported.

It tells Excel where to place a title for a workbook.

It tells Excel how to organize data into columns.

It provides a way to give color and style to a workbook.

It's a graphical representation.

It's information that is used to track daily sales.

It's the same thing as information.

It's a group of letters, numbers, and symbols that a computer can perform an operation on.

Colon

Period

Comma

Tabs

Four categories: Name, address, zip code, and phone number

Three categories: Name & address, zip code, and phone number

Two categories: Name + address and zip code + phone number

One category: Name + address + zip code + phone number

Just one category with last name first and first name last.

Two categories with the first name in one category and the last name in a second category.

Just one category with first and last name.

Two categories with the first and last name in one category and the phone number in the second category.

MID finds the middle columns of a group of columns within a workbook.

The MID function takes the data to the left and the right of a category starting from the middle of the data.

The MID function allows the user to specify a starting point and how many characters to extract from that point.

MID allows the user to find the midpoint of a line.

RIGHT

MID

LEFT

PMT