Question 1

A(n)________ allows you to summarize and examine data such as analyzing book sales by categories.&#10;A)PowerPivot&#10;B)Table Analysis&#10;C)PivotTable&#10;D)Aggregate Analysis

Accepted Answer

PivotTable is specifically designed for summarizing and examining data. It allows users to create customized reports and analyze data based on specific parameters. This makes it a useful tool for analyzing book sales by categories. PowerPivot and Table Analysis are also data analysis tools, but they are more complex and require a higher level of expertise to use effectively. Aggregate Analysis is not a specific tool, but rather a process that involves combining individual data points into summary statistics.

Question 2

Slicer styles are located on the ________ tab.&#10;A)VIEW&#10;B)INSERT&#10;C)DESIGN&#10;D)OPTIONS

Accepted Answer

D

Question 3

PivotTable styles are located on the ________ tab.&#10;A)DESIGN&#10;B)ANALYZE&#10;C)INSERT&#10;D)OPTIONS

Accepted Answer

PivotTable styles are located on the DESIGN tab. This tab contains various tools to customize the look and feel of the PivotTable, including styles, layouts, and formatting options.

Question 4

Which of the following is NOT an area used when creating a PivotTable?&#10;A)COLUMNS&#10;B)TABLES&#10;C)ROWS&#10;D)VALUES

Accepted Answer

The four areas used when creating a PivotTable are COLUMNS, ROWS, VALUES, and FILTERS. TABLES is not an area used in creating a PivotTable.

Question 5

Changes made to a PivotChart are automatically reflected in the corresponding PivotTable.

Accepted Answer

When changes are made to a PivotChart, they reflect in the corresponding PivotTable. This is because the PivotChart and the PivotTable share the same data source and underlying data.

Question 6

You can use a maximum of ________ numbered button(s)in addition to the + and - buttons to expand and collapse an outline.&#10;A)one&#10;B)two&#10;C)three&#10;D)four

Accepted Answer

You can use a maximum of three numbered buttons in addition to the + and - buttons to expand and collapse an outline.

Question 7

You can move a field from one PivotTable area to another by just dragging it.

Accepted Answer

This is true. To move a field from one PivotTable area to another, simply click and drag the field to the desired location.

Question 8

________ is used to exclude particular categories or values from a PivotTable.&#10;A)Mining&#10;B)Grouping&#10;C)Outlining&#10;D)Filtering

Accepted Answer

Filtering is used to exclude particular categories or values from a PivotTable. With filtering, you can select which values or categories to include or exclude based on specific criteria.

Question 9

To remove a field from a PivotTable,you select it and press Delete.

Accepted Answer

To remove a field from a PivotTable, you drag the field out of the Fields area or uncheck it in the field list, not simply press Delete.

Question 10

You can use subtotals in a dataset to calculate subtotals of groups such as sales of books within a discipline.

Accepted Answer

This is true. Subtotals can be used in a dataset to calculate subtotals of groups such as sales of books within a discipline.

Question 11

When creating a calculated field in a PivotTable,range names and cell references outside the PivotTable CANNOT be used.

Accepted Answer

The answer of When creating a calculated field in a...

Question 12

A ________ is a series of buttons that allows users to filter a PivotTable.&#10;A)PivotChart&#10;B)slicer&#10;C)PowerPivot&#10;D)data mine

Accepted Answer

The answer of A ________ is a series of buttons...

Question 13

A ________ is used to graphically represent the data in a PivotTable.&#10;A)PivotChart&#10;B)PowerPivot&#10;C)Scatter Chart&#10;D)PivotGraph

Accepted Answer

The answer of A ________ is used to graphically represent...

Question 14

To apply an outline to columns,you must ________ the desired columns.&#10;A)cluster&#10;B)group&#10;C)aggregate&#10;D)condense

Accepted Answer

The answer of To apply an outline to columns,you must...

Question 15

To properly have two levels of subtotals,you must subtotal the secondary category first and then add a subtotal for your primary category.

Accepted Answer

The answer of To properly have two levels of subtotals,you...

Question 16

Changes made to the original worksheet are automatically reflected in the PivotTable.

Accepted Answer

The answer of Changes made to the original worksheet are...

Deck 1 : Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos