Content Frame
Note for screen reader users: There is text between the form elements on this page. To be sure that you do not miss any text, use item by item navigation methods, rather than tabbing from form element to form element.
Skip Breadcrumb Navigation
Home  arrow Chapters  arrow Excel Chapter 7: Creating PivotTable and PivotChart Reports and Business Intelligence  arrow Online Chapter Review

Online Chapter Review



This activity contains 25 questions.

Question 1.
The _____________ for a PivotTable must be formatted in columns and rows.


Open Hint for Question 1 in a new window.
 
End of Question 1


Question 2.
By default, non-numeric fields are added to the _____.


Open Hint for Question 2 in a new window.
 
End of Question 2


Question 3.
Two ways to filter a PivotTable could be through using a search filter or using a __________.


Open Hint for Question 3 in a new window.
 
End of Question 3


Question 4.
In a PivotTable report, by default, the numeric data calculation performed is __________.


Open Hint for Question 4 in a new window.
 
End of Question 4


Question 5.
Use PivotTable __________ and change field names to make the PivotTable easier to understand.


Open Hint for Question 5 in a new window.
 
End of Question 5


Question 6.
Whenever the source data is changed, you will also need to __________ the PivotTable data to reflect the changes.


Open Hint for Question 6 in a new window.
 
End of Question 6


Question 7.
Use the PivotChart __________ to choose a filter.


Open Hint for Question 7 in a new window.
 
End of Question 7


Question 8.
When working with multiple tables in Excel, you must first establish a __________ between the tables.


Open Hint for Question 8 in a new window.
 
End of Question 8


Question 9.
If PowerPivot is not enabled, you will need to enable it from the __________ dialog box.


Open Hint for Question 9 in a new window.
 
End of Question 9


Question 10.
You can import multiple table data from an Access database into the __________ by using PowerPivot.


Open Hint for Question 10 in a new window.
 
End of Question 10


Question 11.
In the PivotTable Fields pane, there are two tabs: ACTIVE and _____.


Open Hint for Question 11 in a new window.
 
End of Question 11


Question 12.
Use __________ to easily drill down through the PivotTable data with a single click.


Open Hint for Question 12 in a new window.
 
End of Question 12


Question 13.
Multiple Power View sheets can be created in a workbook.


Open Hint for Question 13 in a new window.
   
 
End of Question 13


Question 14.
The background is the area of a Power View worksheet that contains data visualizations.


Open Hint for Question 14 in a new window.
   
 
End of Question 14


Question 15.
The source data used to create a PivotTable report can be noncontiguous data in multiple and varying cells.


Open Hint for Question 15 in a new window.
   
 
End of Question 15


Question 16.
The only way to place field data on a PivotTable report is to drag the field names into the layout section.


Open Hint for Question 16 in a new window.
   
 
End of Question 16


Question 17.
Slicers display as movable floating objects on a worksheet.


Open Hint for Question 17 in a new window.
   
 
End of Question 17


Question 18.
The Insert Slicers dialog box displays all the field names from your PivotTable report.


Open Hint for Question 18 in a new window.
   
 
End of Question 18


Question 19.
In a PivotTable report, you cannot change a column field to display as a row field.


Open Hint for Question 19 in a new window.
   
 
End of Question 19


Question 20.
PivotTable reports can only calculate sums of numerical data.


Open Hint for Question 20 in a new window.
   
 
End of Question 20


Question 21.
You can change the data displayed in the PivotChart by double clicking the vertical axis.


Open Hint for Question 21 in a new window.
   
 
End of Question 21


Question 22.
Using PowerPivot, you can import multiple table data from Access.


Open Hint for Question 22 in a new window.
   
 
End of Question 22


Question 23.
Using PowerPivot, a PivotChart does not have to be associated with a PivotTable.


Open Hint for Question 23 in a new window.
   
 
End of Question 23


Question 24.
Match the following terms to their meanings:




Open Hint for Question 24 in a new window.
A matching question presents 4 answer choices and 4 items. The answer choices are lettered A through D. The items are numbered 24.1 through 24.4. Screen readers will read the answer choices first. Then each item will be presented along with a select menu for choosing an answer choice. Using the pull-down menus, match each item in the left column to the corresponding item in the right column.
A The field section is the upper portion of the PivotTable Fields pane containing the column titles from your source data.
B A PivotTable report is an interactive Excel report that summarizes and analyzes large amounts of data.
C The FILTERS area is an area to position fields by which you want to filter the PivotTable report.
D The VALUES area is an area to position fields that contain data that is summarized in a PivotTable report or PivotChart report.
[hint] 
[hint] 
[hint] 
[hint] 
End of Question 24


Question 25.
Match the following terms to their meanings:




Open Hint for Question 25 in a new window.
A matching question presents 2 answer choices and 2 items. The answer choices are lettered A through B. The items are numbered 25.1 through 25.2. Screen readers will read the answer choices first. Then each item will be presented along with a select menu for choosing an answer choice. Using the pull-down menus, match each item in the left column to the corresponding item in the right column.
A Can be used to perform data analysis and create sophisticated charts and reports.
B A method of incorporating data from multiple, related tables into an Excel worksheet.
[hint] 
[hint] 
End of Question 25





Copyright © 1995 - 2015 Pearson Education . All rights reserved.
Legal Notice | Privacy Policy | Permissions

Return to the Top of this Page