Exam 14: Excel 2013 : Managing Data Using Tables

Because tables often have more rows than can fit on a page,you can define the first row of a table as the print ____________________,which prints at the top of every page.

Which wildcard symbol is a substitute for one or more characters?

You can easily format a table using table ____.

You should not have any blank columns or rows in your table.

The ____ feature allows formulas to refer to table columns by names that are automatically generated when you create a table.

To delete a table row,place the cursor in any cell in the row you wish to delete,then click Delete Table Rows from the Delete list arrow in the Cells group.

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

Which of the following is NOT a guideline when naming a field?

To add an additional record to a table,type below the last record,then press ____.

A(n)____________________ sort rearranges table data using more than one field,where each field is a different level,based on its importance in the sort.

-In the accompanying figure,which item should you click to make sure your find and replace operation respected capitalization?

If Denise specifies Jan* as a search criterion,which of the following will Excel locate?

Records are composed of ____.

-In the accompanying figure,what field is used as the sorting field?

The Find and Replace dialog box can be opened by clicking the Find & Select button in the Editing group.

-In the accompanying figure,how many fields are in the table?

-In the accompanying figure,how many fields are in the table?

-In the accompanying figure,how many records are in the table?

Lily asks you if it is possible to sort the records in her table first by state,then by Zip code.What will you tell her?

Explain calculated columns.