Excel - Managing Data Using Tables and Analyzing Table Data (Unit Review)

Where do you commonly add new records to an Excel table?

Below the last row of the existing table.

Subtotals can be used in an Excel table. True or False.

False!

If Denise specifies Jan* as a search criterion, what will Excel locate?

The first three characters must be "Jan", but then any character after the asterisk. For example: Jane, Janet, or January

And and Or are logical conditions. True or False.

True!

Tables are organized into records which are composed of fields. True or False.

True!

The question mark (?) wildcard stands for any single character. True or False.

True!

When you create a table, Excel automatically applies a default table style. True or False.

True!

You can add new rows and columns to a data table by dragging the sizing handle in the table's lower-right corner. True or False.

True!

You can filter records based on information in a specific field. True or False.

True!

In a filtered table, the matching row numbers are ____.

blue

A multilevel sort calls for using the ____ feature.

custom sort

Tables are organized into rows, called ____.

records

In addition to using Excel's spreadsheet feature, you can analyze and manipulate data using a ____ structure.

table

Criteria on ____ line(s) indicates an Or condition.

two