Question 1

A(n)________ of original data should be made so it is possible to return to the original data should errors occur.

Accepted Answer

backup

Question 2

When using the ________ Filter feature,filtering criteria must be set up in a specific format.

Accepted Answer

Advanced

Question 3

All of the following statements are TRUE regarding PivotTable and PivotChart best practices EXCEPT:

Accepted Answer

A) Format the PivotTable or PivotChart so it is easy to read and your audience understands what it is you are trying to communicate. 
B) Once you have selected your data, ensure the source data are arranged in an area with column headings representing each field and the rows representing each record. 
C) Distinguish fields as either grouping variables or slicer variables. 
D) Know who your audience is prior to developing your PivotTable or PivotChart. It could make a difference in how much detail you display. 
A) Format the PivotTable or PivotChart so it is easy to read and your audience understands what it is you are trying to communicate. 
B) Once you have selected your data, ensure the source data are arranged in an area with column headings representing each field and the rows representing each record. 
C) Distinguish fields as either grouping variables or slicer variables. 
D) Know who your audience is prior to developing your PivotTable or PivotChart. It could make a difference in how much detail you display. C

Question 4

Users can change the look of an existing table through the Style gallery located on the ________ tab.

Accepted Answer

The answer of Users can change the look of an...

Question 5

To ________ data means to consolidate or summarize data,and can be accomplished through functions such as SUM and AVERAGE.

Accepted Answer

The answer of To ________ data means to consolidate or...

Question 6

All of the following statements are TRUE regarding grouping in PivotTables EXCEPT:

Accepted Answer

A) Grouping variables are placed along the top or the left side of the PivotTable. 
B) The summary variables are positioned in the VALUES area below the PivotTable Fields list. 
C) The grouping variables are positioned in the COLUMNS or ROWS areas at the top of the PivotTable Fields pane. 
D) Dates are great for grouping into months, quarters, and years to explore trends over time. 
A) Grouping variables are placed along the top or the left side of the PivotTable. 
B) The summary variables are positioned in the VALUES area below the PivotTable Fields list. 
C) The grouping variables are positioned in the COLUMNS or ROWS areas at the top of the PivotTable Fields pane. 
D) Dates are great for grouping into months, quarters, and years to explore trends over time.

Question 7

Which of the following statements about filtering is NOT TRUE?

Accepted Answer

A) Filtering makes it possible to view specific data. 
B) The filtering function can be applied to only one data set on a worksheet. 
C) Filters can only be established on an Excel table. 
D) Filtering enables a user to examine and analyze a subset of records. 
A) Filtering makes it possible to view specific data. 
B) The filtering function can be applied to only one data set on a worksheet. 
C) Filters can only be established on an Excel table. 
D) Filtering enables a user to examine and analyze a subset of records.

Question 8

A PivotTable can be created on a new or an existing ________.

Accepted Answer

The answer of A PivotTable can be created on a...

Question 9

The ________ function will run calculations on data that is in a subset when a filter is applied.

Accepted Answer

A) SUM 
B) TOTAL 
C) SUBTOTAL 
D) SUMMARY 
A) SUM 
B) TOTAL 
C) SUBTOTAL 
D) SUMMARY

Question 10

By default,PivotTables show a ________ for both columns and rows.

Accepted Answer

A) grand total 
B) count 
C) average 
D) subtotal 
A) grand total 
B) count 
C) average 
D) subtotal

Question 11

If the criteria range for the Advanced Filter includes a row with no criteria,the entire record set will be returned because nothing is constraining the records.

Accepted Answer

A) True 
 B)False

Question 12

All of the following statements are TRUE regarding raw data EXCEPT:

Accepted Answer

A) Raw data may be numeric or text. 
B) Raw data without context is meaningless to users. 
C) Information is another name for data. 
D) Raw data is unorganized. 
A) Raw data may be numeric or text. 
B) Raw data without context is meaningless to users. 
C) Information is another name for data. 
D) Raw data is unorganized.

Question 13

________ are interactive tables that extract,organize,and summarize data.

Accepted Answer

A) DataTables 
B) PivotTables 
C) ValueTables 
D) VariableTables 
A) DataTables 
B) PivotTables 
C) ValueTables 
D) VariableTables

Question 14

All of the following statements are TRUE regarding PivotCharts EXCEPT:

Accepted Answer

A) Once a PivotChart is created, all formatting elements from a regular chart are no longer available. 
B) When the PivotTable data are rearranged, they are automatically updated in the PivotChart. 
C) When making changes to the PivotChart the corresponding changes are seen in the PivotTable. 
D) PivotCharts provide a visual representation of the data in a PivotTable. 
A) Once a PivotChart is created, all formatting elements from a regular chart are no longer available. 
B) When the PivotTable data are rearranged, they are automatically updated in the PivotChart. 
C) When making changes to the PivotChart the corresponding changes are seen in the PivotTable. 
D) PivotCharts provide a visual representation of the data in a PivotTable.

Question 15

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

Accepted Answer

The answer of The ________ filter displays the values in...

Question 16

Match between columns
                        Premises: Raw data
Information
Aggregate
Filtering
Data sets

Accepted Answer

The Answer of Data that has context,meaning,and relevance and Named is...

Question 17

The ________ feature located on the PivotTable Analyze tab offers a list of options for summarizing its data values.

Accepted Answer

A) Group Values By 
B) Summarize Values By 
C) Aggregate Values By 
D) Update Values By 
A) Group Values By 
B) Summarize Values By 
C) Aggregate Values By 
D) Update Values By

Question 18

________ variables are fields within a data set that can be used to categorize or group for comparison.

Accepted Answer

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

Question 19

Which of the following should NOT be performed in an effort to protect the integrity of data?

Accepted Answer

A) Keep a backup of original data. 
B) Whenever possible, keep data and the analysis of that data on the same worksheet. 
C) Check data for completeness and accuracy. 
D) Organize data within a workbook in a meaningful manner. 
A) Keep a backup of original data. 
B) Whenever possible, keep data and the analysis of that data on the same worksheet. 
C) Check data for completeness and accuracy. 
D) Organize data within a workbook in a meaningful manner.

Question 20

The PivotTable ________ tab focuses on the appearance aspects of designing a PivotTable.

Accepted Answer

The answer of The PivotTable ________ tab focuses on the...

A(n)________ of original data should be made so it is possible to return to the original data should errors occur.

When using the ________ Filter feature,filtering criteria must be set up in a specific format.

All of the following statements are TRUE regarding PivotTable and PivotChart best practices EXCEPT:

Users can change the look of an existing table through the Style gallery located on the ________ tab.

To ________ data means to consolidate or summarize data,and can be accomplished through functions such as SUM and AVERAGE.

All of the following statements are TRUE regarding grouping in PivotTables EXCEPT:

Which of the following statements about filtering is NOT TRUE?

A PivotTable can be created on a new or an existing ________.

The ________ function will run calculations on data that is in a subset when a filter is applied.

By default,PivotTables show a ________ for both columns and rows.

If the criteria range for the Advanced Filter includes a row with no criteria,the entire record set will be returned because nothing is constraining the records.

All of the following statements are TRUE regarding raw data EXCEPT:

________ are interactive tables that extract,organize,and summarize data.

All of the following statements are TRUE regarding PivotCharts EXCEPT:

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

The ________ feature located on the PivotTable Analyze tab offers a list of options for summarizing its data values.

________ variables are fields within a data set that can be used to categorize or group for comparison.

Which of the following should NOT be performed in an effort to protect the integrity of data?

The PivotTable ________ tab focuses on the appearance aspects of designing a PivotTable.

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

A(n)________ of original data should be made so it is possible to return to the original data should errors occur.

When using the ________ Filter feature,filtering criteria must be set up in a specific format.

All of the following statements are TRUE regarding PivotTable and PivotChart best practices EXCEPT:

Users can change the look of an existing table through the Style gallery located on the ________ tab.

To ________ data means to consolidate or summarize data,and can be accomplished through functions such as SUM and AVERAGE.

All of the following statements are TRUE regarding grouping in PivotTables EXCEPT:

Which of the following statements about filtering is NOT TRUE?

A PivotTable can be created on a new or an existing ________.

The ________ function will run calculations on data that is in a subset when a filter is applied.

By default,PivotTables show a ________ for both columns and rows.

If the criteria range for the Advanced Filter includes a row with no criteria,the entire record set will be returned because nothing is constraining the records.

All of the following statements are TRUE regarding raw data EXCEPT:

________ are interactive tables that extract,organize,and summarize data.

All of the following statements are TRUE regarding PivotCharts EXCEPT:

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

The ________ feature located on the PivotTable Analyze tab offers a list of options for summarizing its data values.

________ variables are fields within a data set that can be used to categorize or group for comparison.

Which of the following should NOT be performed in an effort to protect the integrity of data?

The PivotTable ________ tab focuses on the appearance aspects of designing a PivotTable.

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