Question 1

Records are individual pieces of information.

Accepted Answer

A) True 
 B)False

Question 2

Match between columns
                        Premises: MAX
AVERAGE
COUNTA
MIN
SUM

Accepted Answer

The Answer of 109 and 104 and 105 and 101 is...

Question 3

When you enter a structured reference in a formula Excel copies that formula down the rest of the column automatically.

Accepted Answer

A) True 
 B)False

Question 4

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 5

Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?

Accepted Answer

A) Top/Bottom Rules 
B) Highlight Cells Rules 
C) Between Values Rules 
D) Color Scales

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

________ 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 8

You can add a row to a data table as long as you put in the row immediately below the table.

Accepted Answer

A) True 
 B)False

Question 9

After a table has been named, that name can be used in functions instead of cell references.

Accepted Answer

A) True 
 B)False

Question 10

Excel indicates where page breaks will occur by placing temporary ________ (such as Page 1, Page 2)on your display.

Accepted Answer

The answer of Excel indicates where page breaks will occur...

Question 11

Which table style option is useful to display aggregated data when it is checked?

Accepted Answer

A) Last Column 
B) Total Row 
C) Filter Button 
D) Header Row

Question 12

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 13

In a data table each row is considered a(n)________.

Accepted Answer

The answer of In a data table each row is...

Question 14

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

Accepted Answer

The answer of If you wanted to sort the days...

Question 15

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 16

Match between columns
                        Premises: Icon set
Sorting
Data bars
Color scale
Filtering

Accepted Answer

The Answer of Using conditions to limit the visible data is...

Question 17

________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

Accepted Answer

The answer of ________ page breaks can be inserted if...

Question 18

What is not true about using the AND function in a custom conditional formatting rule?

Accepted Answer

A) All the tests must be of the same data type, for example: all numbers or all text. 
B) All the logical tests must be true for the formatting to be applied. 
C) You must have at least two tests in the formula. 
D) You may have as many tests as you need in the formula.

Question 19

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 20

You cannot sort cells by their fill color.

Accepted Answer

A) True 
 B)False

Exam 4: Datasets and Tables

Records are individual pieces of information.

Match the following Subtotal Function with their Table Numbers:

When you enter a structured reference in a formula Excel copies that formula down the rest of the column automatically.

What cannot be found on the Manage Rules dialog box?

Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?

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

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

You can add a row to a data table as long as you put in the row immediately below the table.

After a table has been named, that name can be used in functions instead of cell references.

Excel indicates where page breaks will occur by placing temporary ________ (such as Page 1, Page 2)on your display.

Which table style option is useful to display aggregated data when it is checked?

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

In a data table each row is considered a(n)________.

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

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

Match the following terms with their description:

________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

What is not true about using the AND function in a custom conditional formatting rule?

By default Excel prints page in what order?

You cannot sort cells by their fill color.