Question 1

________ data include elements or facts that may or may not have meaning or relevance.

Accepted Answer

The answer of ________ data include elements or facts that...

Question 2

Advanced Filter in Excel provides AND and OR features to join multiple criteria.

Accepted Answer

A) True 
 B)False

Question 3

To open the Create PivotTable dialog box,click on the ________ tab,and then click Summarize with PivotTable.

Accepted Answer

A) Home 
B) Insert 
C) Data 
D) Design 
A) Home 
B) Insert 
C) Data 
D) Design

Question 4

Because of the way that Excel is configured,table names can include spaces.

Accepted Answer

A) True 
 B)False

Question 5

________ is the name used for a collection of related sets of information that are composed of separate elements.

Accepted Answer

A) Information sets 
B) Variable sets 
C) Data sets 
D) Field sets 
A) Information sets 
B) Variable sets 
C) Data sets 
D) Field sets

Question 6

________ allows a user to import up to one million rows of data from multiple sources,such as large corporate databases,public data feeds,spreadsheets,and text files on your computer.

Accepted Answer

A) PivotTable 
B) PivotChart 
C) Slicer 
D) PowerPivot 
A) PivotTable 
B) PivotChart 
C) Slicer 
D) PowerPivot

Question 7

When creating a PivotTable,any existing automatic subtotals or other summary functions at the bottom of the data should be removed.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following statements regarding PivotTables is NOT TRUE?

Accepted Answer

A) When there are a lot of groups within a field, it is better to put those fields along the row side of the PivotTable. 
B) There are three context-sensitive tabs associated with PivotTables. 
C) Typically the contents of a PivotTable should go down more than across. 
D) Fields for PivotTable grouping could be all in the Rows area, all in the Columns area, or a mixture. 
A) When there are a lot of groups within a field, it is better to put those fields along the row side of the PivotTable. 
B) There are three context-sensitive tabs associated with PivotTables. 
C) Typically the contents of a PivotTable should go down more than across. 
D) Fields for PivotTable grouping could be all in the Rows area, all in the Columns area, or a mixture.

Question 9

________ variables are data that can be aggregated by summing,counting,or averaging.

Accepted Answer

A) Aggregate 
B) Category 
C) Grouping 
D) Summary 
A) Aggregate 
B) Category 
C) Grouping 
D) Summary

Question 10

To change a table back to a range of data,click ________ located in the Tools group on the Design tab.

Accepted Answer

A) Convert to Data 
B) Convert to Range 
C) Convert to Information 
D) Convert to Cells 
A) Convert to Data 
B) Convert to Range 
C) Convert to Information 
D) Convert to Cells

Question 11

Format the PivotTable or PivotChart so it is easy to read and your audience understands what it is you are trying to communicate.

Accepted Answer

A) True 
 B)False

Question 12

PivotTable data formatted through the ________ dialog box applies to all other cells within the same field.

Accepted Answer

A) Value Field Settings 
B) Format Data 
C) Data Settings 
D) Format Fields 
A) Value Field Settings 
B) Format Data 
C) Data Settings 
D) Format Fields

Question 13

All of the following statements are TRUE regarding the function_num argument of the SUBTOTAL function EXCEPT:

Accepted Answer

A) This argument informs Excel which function to use on the subset of records. 
B) One set of function_num values will include both filtered and hidden data. 
C) One set of function_num values will include only filtered data. 
D) One set of function_num values will include only hidden data. 
A) This argument informs Excel which function to use on the subset of records. 
B) One set of function_num values will include both filtered and hidden data. 
C) One set of function_num values will include only filtered data. 
D) One set of function_num values will include only hidden data.

Question 14

A filter is a standard part of an Excel table.

Accepted Answer

A) True 
 B)False

Question 15

When using the SUBTOTAL function,entering a number from 1 to 10 in the SUBTOTAL function's first argument will result in the filtered only data being used.

Accepted Answer

A) True 
 B)False

Question 16

The ________ filter displays the values in the field that can be toggled on and off through the use of check boxes.

Accepted Answer

A) advanced 
B) enhanced 
C) standard 
D) additional 
A) advanced 
B) enhanced 
C) standard 
D) additional

Question 17

________ is a process of hiding records that do not meet specified criteria in a data set.

Accepted Answer

The answer of ________ is a process of hiding records...

Question 18

Any records that should not be used in the SUBTOTAL calculations should be excluded using the filtering process.

Accepted Answer

A) True 
 B)False

Question 19

Pressing Shift allows you to select multiple criteria on a slicer.

Accepted Answer

A) True 
 B)False

Question 20

________ variables can be thought of as any fields within a data set that can be used to categorize for comparison.

Accepted Answer

The answer of ________ variables can be thought of as...

________ data include elements or facts that may or may not have meaning or relevance.

Advanced Filter in Excel provides AND and OR features to join multiple criteria.

To open the Create PivotTable dialog box,click on the ________ tab,and then click Summarize with PivotTable.

Because of the way that Excel is configured,table names can include spaces.

________ is the name used for a collection of related sets of information that are composed of separate elements.

________ allows a user to import up to one million rows of data from multiple sources,such as large corporate databases,public data feeds,spreadsheets,and text files on your computer.

When creating a PivotTable,any existing automatic subtotals or other summary functions at the bottom of the data should be removed.

Which of the following statements regarding PivotTables is NOT TRUE?

________ variables are data that can be aggregated by summing,counting,or averaging.

To change a table back to a range of data,click ________ located in the Tools group on the Design tab.

Format the PivotTable or PivotChart so it is easy to read and your audience understands what it is you are trying to communicate.

PivotTable data formatted through the ________ dialog box applies to all other cells within the same field.

All of the following statements are TRUE regarding the function_num argument of the SUBTOTAL function EXCEPT:

A filter is a standard part of an Excel table.

When using the SUBTOTAL function,entering a number from 1 to 10 in the SUBTOTAL function's first argument will result in the filtered only data being used.

The ________ filter displays the values in the field that can be toggled on and off through the use of check boxes.

________ is a process of hiding records that do not meet specified criteria in a data set.

Any records that should not be used in the SUBTOTAL calculations should be excluded using the filtering process.

Pressing Shift allows you to select multiple criteria on a slicer.

________ variables can be thought of as any fields within a data set that can be used to categorize for comparison.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 6: Analyze Data Using Tables

________ data include elements or facts that may or may not have meaning or relevance.

Advanced Filter in Excel provides AND and OR features to join multiple criteria.

To open the Create PivotTable dialog box,click on the ________ tab,and then click Summarize with PivotTable.

Because of the way that Excel is configured,table names can include spaces.

________ is the name used for a collection of related sets of information that are composed of separate elements.

________ allows a user to import up to one million rows of data from multiple sources,such as large corporate databases,public data feeds,spreadsheets,and text files on your computer.

When creating a PivotTable,any existing automatic subtotals or other summary functions at the bottom of the data should be removed.

Which of the following statements regarding PivotTables is NOT TRUE?

________ variables are data that can be aggregated by summing,counting,or averaging.

To change a table back to a range of data,click ________ located in the Tools group on the Design tab.

Format the PivotTable or PivotChart so it is easy to read and your audience understands what it is you are trying to communicate.

PivotTable data formatted through the ________ dialog box applies to all other cells within the same field.

All of the following statements are TRUE regarding the function_num argument of the SUBTOTAL function EXCEPT:

A filter is a standard part of an Excel table.

When using the SUBTOTAL function,entering a number from 1 to 10 in the SUBTOTAL function's first argument will result in the filtered only data being used.

The ________ filter displays the values in the field that can be toggled on and off through the use of check boxes.

________ is a process of hiding records that do not meet specified criteria in a data set.

Any records that should not be used in the SUBTOTAL calculations should be excluded using the filtering process.

Pressing Shift allows you to select multiple criteria on a slicer.

________ variables can be thought of as any fields within a data set that can be used to categorize for comparison.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters