Lesson 9 Excel

In Excel, whenever values are separated, they are called:

• deminiters

• delimiters

• parsing

• None of these

You cannot restrict cell entries to certain data types in Excel

• True

• False

• Both

• None of these

A/an ____________ is the quickest means for you to set up a table so that it displays only rows that meet simple criteria.

• Delimiting

• AutoFilter

• FilterAuto

• None of these

Unusable data in Excel is _____________ data.

• Invalid

• Valid

• Extra

• Sensible

You can sort:

• Using one criterion

• Using more than one criteria

• None of these

• Both of these

Outlines in Excel:

• are used to generate reports that provide meaningful data.

• are used to show charts

• both of these

• none of thes

Grouping data in Excel

• Involves taking a row of cells that have something in common

• Can cluster rows together

• Can collapse data

• All of these

Grouped rows in Excel

• Can have a minus symbol

• Can have a plus symbol

• None of these

• Both of these

Converting an Excel worksheet into a table enables Excel to treat this table like a:

• Spreadsheet

• Database

• Both

• None of these

You __________ change an Excel Table back to a spreadsheet.

• Can

• Cannot

• If it is blue table

• None of these