Exam 14: Excel 2013 : Managing Data Using Tables

Which wildcard symbol is a substitute for any single character?

-In the accompanying figure,the header row is in row ____.

Inserting extra spaces at the beginning of a cell entry in a table can affect sorting and finding data later.

The wildcard asterisk (*)always represents one single character.

Table ____________________ allow you to easily format a table.

Which tab contains the print options for gridlines and headings?

The ____________________ reference feature allows your formulas to refer to table columns by name.

____________________ list arrows automatically appear in the column header cells when you create a table.

Tables are organized into records which are composed of fields.

-In the accompanying figure,row 5 is called a ____ row.

The Wildcard dialog box helps you find records in a table.

You can use Excel's ____________________ feature to rearrange the order in which records in your table appear.

The print title prints at the top of every ____.

If Denise specifies Jan? as a search criterion,Excel will locate all of the following records EXCEPT ____.

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

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

You can include capitalization as a sort criterion by clicking Options in the Sort dialog box,then selecting the ____________________ sensitive check box.

The Remove Duplicates button is found on the ____ tab.

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

After you enter a single formula into a table cell,the ____ feature fills in the remaining cells with the formula's results.