Exam 8: Excel : Datasets and Tables

The Table Styles ________ shows you all the table styles which are available.

You cannot sort cells by their fill color.

Selecting a range automatically makes it a data table.

What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?

Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

By default, what is the first table on a worksheet named?

"John Smith" is a good example of a field.

Using the Print ________ can help you save paper.

It is a good practice to print column and row labels on each page.

Match the following terms with their description: I. Field II. Record III. Table IV. Table style V. Total row A. Includes complimentary fill colors B. Complete set of fields for one entity C. Structured range D. Appears below the last row in a table E. Smallest piece of data collected

In a data table calculated columns will copy down the table automatically.

If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?

If you use the Icon sets conditional formatting, you are limited to how many categories?

If you wanted to sort the days of the week in their natural order, not alphabetically, you would set up a(n)________ sort.

How does Excel indicate that a column has been selected in a structured reference?

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

In a structured reference what do you use to indicate a column heading or field name?

Excel uses dashed blue lines to indicate manual page breaks.

Match the following Data Type Sort Options with their example: I. Sort Z to A II. Sort Oldest to Newest III. Sort Largest to Smallest IV. Sort A to Z V. Sort Newest to Oldest A. Number; Othniel; Psychology B. 11\20\2015; 8\20\2015; 5\25\91 C. 58; 29; 27 D. 1\16\1957; 12\26\1959; 1\7\87 E. Karen; Doug; Barb

Match the following table style options with their description: I. Header Row II. Total Row III. First Column IV. Last Column V. Filter Button A. Displays a total row when selected B. Makes sure that the row headings stand out C. Displays on the right side of each heading in the header row D. Used to make aggregated data stand out E. Removes field names when not checked