Question 1

What cannot be found on the Manage Rules dialog box?

Accepted Answer

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

Question 2

Using the data bars conditional formatting,how is the highest value represented?

Accepted Answer

A) By the darkest bar 
B) By the tallest bar 
C) By the longest bar 
D) By the most number of bars 
A) By the darkest bar 
B) By the tallest bar 
C) By the longest bar 
D) By the most number of bars

Question 3

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 
A) Last Column 
B) Total Row 
C) Filter Button 
D) Header Row

Question 4

What is the default data table style?

Accepted Answer

A) Normal 
B) Medium 1 
C) Medium 2 
D) None 
A) Normal 
B) Medium 1 
C) Medium 2 
D) None

Question 5

Table ________ add color and borders to a table.

Accepted Answer

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

Question 6

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear,then drag the page break to your desired location.

Accepted Answer

A) True 
 B)False

Question 7

To print row labels on the left side of each page you would select the row(s)that contain the labels in the rows to repeat at left box.

Accepted Answer

A) True 
 B)False

Question 8

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 
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 9

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

Accepted Answer

A) Begins With 
B) Includes 
C) Contains 
D) Custom Filter 
A) Begins With 
B) Includes 
C) Contains 
D) Custom Filter

Question 10

The ________ symbol is used in structured references to refer to the current row.

Accepted Answer

The answer of The ________ symbol is used in structured...

Question 11

If you use the Color Scale conditional formatting,you are limited to how many colors (and their gradations?
)

Accepted Answer

A) Unlimited 
B) 256 
C) 1,012 
D) 2 or 3 
A) Unlimited 
B) 256 
C) 1,012 
D) 2 or 3

Question 12

Use the Sort by ________ Color if you want to sort records by the color of the text.

Accepted Answer

The answer of Use the Sort by ________ Color if...

Question 13

In a data table you can use ________ references in place of cell references inside the formulas.

Accepted Answer

The answer of In a data table you can use...

Question 14

When would you not need to use a fully qualified structured reference?

Accepted Answer

A) When referring to a cell outside the table 
B) When referring to a cell on a different worksheet 
C) When referring to a cell on a different workbook 
D) When referring to a cell within the table 
A) When referring to a cell outside the table 
B) When referring to a cell on a different worksheet 
C) When referring to a cell on a different workbook 
D) When referring to a cell within the table

Question 15

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

Accepted Answer

A) One,two,or three 
B) Two,three,or four 
C) Three,four,or five 
D) Four,five,or six 
A) One,two,or three 
B) Two,three,or four 
C) Three,four,or five 
D) Four,five,or six

Question 16

This could be a valid formula in Excel:
 =[@Cost]-[@Pre_Paid_Taxes].

Accepted Answer

A) True 
 B)False

Question 17

What is not true about creating a data table?

Accepted Answer

A) Make sure no column labels are the same. 
B) Make sure to leave one blank row below the data labels. 
C) Format the field names so that they stand out visually. 
D) Keep field names short. 
A) Make sure no column labels are the same. 
B) Make sure to leave one blank row below the data labels. 
C) Format the field names so that they stand out visually. 
D) Keep field names short.

Question 18

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 
A) Text Contains 
B) Duplicate Values 
C) Unique Values 
D) Undo Format

Question 19

What data does Excel print by default?

Accepted Answer

A) The selected range of data 
B) The entire dataset on the active sheet 
C) The entire workbook 
D) There is no default setting for this in Excel. 
A) The selected range of data 
B) The entire dataset on the active sheet 
C) The entire workbook 
D) There is no default setting for this in Excel.

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 
A) First Quarter 
B) Tomorrow 
C) Between 
D) Last Month

What cannot be found on the Manage Rules dialog box?

Using the data bars conditional formatting,how is the highest value represented?

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

What is the default data table style?

Table ________ add color and borders to a table.

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear,then drag the page break to your desired location.

To print row labels on the left side of each page you would select the row(s)that contain the labels in the rows to repeat at left box.

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

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

The ________ symbol is used in structured references to refer to the current row.

If you use the Color Scale conditional formatting,you are limited to how many colors (and their gradations? )

Use the Sort by ________ Color if you want to sort records by the color of the text.

In a data table you can use ________ references in place of cell references inside the formulas.

When would you not need to use a fully qualified structured reference?

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

This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

What is not true about creating a data table?

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

What data does Excel print by default?

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

Introduction to Excel

Formulas and Functions

Charts

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 4: Datasets and Tables

What cannot be found on the Manage Rules dialog box?

Using the data bars conditional formatting,how is the highest value represented?

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

What is the default data table style?

Table ________ add color and borders to a table.

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear,then drag the page break to your desired location.

To print row labels on the left side of each page you would select the row(s)that contain the labels in the rows to repeat at left box.

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

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

The ________ symbol is used in structured references to refer to the current row.

If you use the Color Scale conditional formatting,you are limited to how many colors (and their gradations? )

Use the Sort by ________ Color if you want to sort records by the color of the text.

In a data table you can use ________ references in place of cell references inside the formulas.

When would you not need to use a fully qualified structured reference?

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

This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

What is not true about creating a data table?

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

What data does Excel print by default?

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

Introduction to Excel

Formulas and Functions

Charts

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters