Question 1

By default Excel prints page in what order?

Accepted Answer

A) Top-left section, top-right section, bottom-left section, and bottom-right section 
B) All the odd numbered pages, then all the even numbered pages 
C) All the even numbered pages, then all the odd numbered pages 
D) Top-left section, bottom-left section, top-right section, and bottom-right section

Question 2

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

Accepted Answer

A) Header Row 
B) Total Row 
C) First Column 
D) Banded Columns

Question 3

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

Accepted Answer

A) Text Contains 
B) Duplicate Values 
C) Unique Values 
D) Undo Format

Question 4

Which of the following is not a freeze option?

Accepted Answer

A) Freeze Panes 
B) Freeze Top Row 
C) Freeze First Column 
D) Freeze Section

Question 5

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

Accepted Answer

The answer of ________ references help to clarify what type...

Question 6

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

Accepted Answer

The answer of Data ________ is the method used to...

Question 7

By how many levels will Excel allow you to sort?

Accepted Answer

A) 16 
B) 32 
C) 64 
D) 128

Question 8

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

Accepted Answer

A) Greater Than... 
B) Between... 
C) Below Average 
D) Bottom 10...

Question 9

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

Accepted Answer

The answer of Match the following Conditional Formatting Options with...

Question 10

What is not true about creating a data table?

Accepted Answer

A) Each record should be unique somehow. 
B) For efficiency, make sure your data table does not exceed 256 rows. 
C) It is best to put individual data tables on separate sheets. 
D) Delete any blank columns in your table.

Question 11

What cannot be found on the Manage Rules dialog box?

Accepted Answer

A) Delete Rule 
B) Copy Rule 
C) New Rule 
D) Edit Rule

Question 12

Where does Excel display the Total row in a table?

Accepted Answer

A) At the top of the table 
B) After each subtotal in the table 
C) Two rows below the last row in the table 
D) Below the last row in the table

Question 13

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

Accepted Answer

The answer of You can see how many records meet...

Question 14

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

Accepted Answer

A) The PAID record 
B) The range to be included in the calculation 
C) The Excel function called PAID 
D) The label for the resultant Total Row

Question 15

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

Accepted Answer

The answer of Match the following Subtotal Function with their...

Question 16

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

Accepted Answer

The answer of If you need to perform complex filters...

Question 17

Table ________ add color and borders to a table.

Accepted Answer

The answer of Table ________ add color and borders to...

Question 18

Records are individual pieces of information.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

The answer of A collection of fields about one person...

Question 20

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

Accepted Answer

A) First Quarter 
B) Tomorrow 
C) Between 
D) Last Month

Exam 8: Excel : Datasets and Tables