Exam 8: Excel : Datasets and Tables

By default Excel prints page in what order?

Which table style option shows the field names when it is checked?

Which conditional formatting option is not found in the Quick Analysis Gallery?

Which of the following is not a freeze option?

________ references help to clarify what type of data is being used in any calculations.

Data ________ is the method used to organize data points in a dataset.

By how many levels will Excel allow you to sort?

Which one of the following filter options is not found on the number filter submenu?

Match the following Conditional Formatting Options with their description: I. Highlight Cells Rules II. Top\Bottom Rules III. Data bars IV. Color Scales V. Icon Sets A. Formats cells if they fall in the lowest % (% determined by the user) B. Formats cells with gradients of color depending on the cell's value compared to the other values in the range C. Formats cells with colors whose width is proportional to the other values in the range D. Formats cells if a date falls in a certain range E. Uses symbols to represent the comparison of values

What is not true about creating a data table?

What cannot be found on the Manage Rules dialog box?

Where does Excel display the Total row in a table?

You can see how many records meet the conditions of the filter by looking at the ________ bar.

In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?

Match the following Subtotal Function with their Table Numbers: I. AVERAGE II. MAX III. MIN IV. SUM V. COUNTA A. 104 B. 103 C. 101 D. 109 E. 105

If you need to perform complex filters on your data you will want to use the ________ AutoFilter dialog box.

Table ________ add color and borders to a table.

Records are individual pieces of information.

A collection of fields about one person would be considered a(n)________.

Which one of the following filter options is not found on the date filter submenu?