Exam 21: Excel: Datasets and Tables: Managing Large Volumes of Data

Default column headings of a table are Column1,Column2,and so on.

In addition to sorting and filtering cells by content,you can sort and/or filter by ________ formatting.

Which of the following is NOT included in the Table Style Options group?

A(n)________ defines the range of data from a worksheet to print.

________ displays alternate fill colors for even and odd rows to help distinguish fields.

The ________ Table Style option displays the field names of a table when checked.

A(n)________ is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.

What is a record?

In Excel 2013,you can delete conditional formatting rules that you create but you cannot edit them.

Text can be sorted A to Z or Z to A.

You can create a table by selecting a range,clicking the Quick Analysis button,and clicking Tables.

Print ________ is the sequence in which pages of a workbook are printed.

What are the areas of the New Formatting Rule dialog box that need to be selected to create a new rule?

A structured reference requires parentheses around column headings or field names.

Filtering the First_Name field to display only records that begin with the letter J uses a:

In addition to sorting and filtering cells by content you can sort and/or filter by:

The Freeze Top Row option:

A(n)________ bar is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.