Filters
Question type
Study Flashcards

PivotTables can be created from the ________ tab in the Ribbon.

Correct Answer

verifed

verified

When editing a PivotTable where are values field settings edited?


A) PivotTable Design tab
B) Data tab
C) PivotTable Fields task pane
D) Formulas tab

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

The ________ is text that displays in the header at the top of the slicer window.

Correct Answer

verifed

verified

Match the following charts to their descriptions:

Premises
pie chart
line chart
bar chart
area chart
XY chart
Responses
shows proportions of a whole
displays data over time
emphasizes the magnitude of change over time
shows comparisons between items
displays distributions, groups, or patterns

Correct Answer

pie chart
line chart
bar chart
area chart
XY chart

Match the following PivotTable areas with the corresponding description: I.PivotTable Fields task pane II.Filters Area III.Columns Area IV.Rows Area V.Values Area A.Organizes and groups data into categories on the left side.Each group name occupies a single row. B.Displays summary statistics,such as totals or averages. C.Subdivides data into one or more additional categories. D.Filters the data to display results based on particular conditions you set. E.Contains two sections that allow for the editing of a PivotTable.

Correct Answer

verifed

verified

Where is the Subtotal command located on the Ribbon?


A) Insert tab
B) Data tab
C) View tab
D) Backstage

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

Where are PowerPivot tools located on the Ribbon?


A) Insert tab
B) Formulas tab
C) Data tab
D) Review tab

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

Match the following chart elements with their descriptions:

Premises
plot area
chart area
data points
data series
multiseries
Responses
cells that contain numeric values
area representing the data
contains data points that represent a set of related numbers
the chart and all of its elements
data for two or more sets of data

Correct Answer

plot area
chart area
data points
data series
multiseries

Once slicers are created additional Slicer Styles can be applied.

A) True
B) False

Correct Answer

verifed

verified

Where is the command to insert a PivotTable located in the Ribbon?


A) Data tab
B) Insert tab
C) Formulas tab
D) Developer tab

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

Which of the following is not a PivotTable Subtotals option?


A) Do Not Show Subtotals
B) Show All Subtotals at Bottom of Group
C) Do Not Include Filtered Items in Totals
D) Include Filtered Items in Totals

E) All of the above
F) None of the above

Correct Answer

verifed

verified

Which of the following tools is best suited for complex cross referenced subtotals?


A) PivotTable
B) Subtotal
C) Data table
D) Outline

E) A) and B)
F) A) and D)

Correct Answer

verifed

verified

Match the following terms to their meanings:

Premises
layering
grouping
resizing
ungrouping
flipping
Responses
breaks a combined object into individual shapes
stacking objects on one another
manually or precisely using the size group options
combining selected objects so they appear as a single object
creating a mirror image of an object

Correct Answer

layering
grouping
resizing
ungrouping
flipping

Match the following calculated field settings with the corresponding description:

Premises
Slicer
Filter
Calculated Field
PivotChart
Slicer caption
Responses
An interactive graphical representation of the data in a PivotTable
Text that displays in the header at the top of the slicer window
A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly
A user-defined field that does not exist in the original dataset
Excludes particular categories or values

Correct Answer

Slicer
Filter
Calculated Field
PivotChart
Slicer caption

When the calculation options of a PivotTable are set to % of ________ Row Total,the PivotTable displays values as: (value for the item)/ (value for the parent item on rows).

Correct Answer

verifed

verified

How are grouped columns ungrouped?


A) Select the entire worksheet and click Ungroup in the Subtotal group
B) Select one cell in the grouped columns and click Ungroup in the Outline group
C) Select all grouped columns and click Ungroup in the Outline group
D) Right-click and select Ungroup

E) None of the above
F) A) and C)

Correct Answer

verifed

verified

Slicers can only be removed from the Analyze tab in the Ribbon.

A) True
B) False

Correct Answer

verifed

verified

A PivotTable can be created from the Quick Analysis gallery.

A) True
B) False

Correct Answer

verifed

verified

Match the following OLE terms to their descriptions:

Premises
destination file
source file
destination application
source application
Responses
used to create the original object embedded object
contains the table that is used to create a linked or
source of the document into which the object is being inserted
contains the inserted object

Correct Answer

destination file
source file
destination application
source application

Match the following terms to their descriptions:

Premises
stub
column headers
table style
table
merge
Responses
identifies the content of each column
combination of formatting choices
combine two or more cells
first column of a table
grid of up to 75 rows and columns

Correct Answer

stub
column headers
table style
table
merge

Showing 61 - 80 of 136

Related Exams

Exam 1

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

16 Questions

Exam 2

Desktop Publishing and Graphic Design: Hands On Exercise Videos

16 Questions

Exam 3

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

100 Questions

Exam 4

Infographics: Creating Text Charts, tables, and Graphs

100 Questions

Exam 6

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

132 Questions

Exam 7

Infographics: Hands On Exercise Videos

51 Questions

Exam 8

Data Validation and Data Analysis: Hands On Exercise Videos

50 Questions

Exam 9

What If Analysis: Hands On Exercise Videos

31 Questions

Exam 10

Time Saving Tools: Hands On Exercise Videos

32 Questions

Exam 11

Time Saving Tools: Using Templates multiple Documents and Themes

110 Questions

Exam 12

Interactivity and Advanced Animation: Engaging the Audience

110 Questions

Exam 13

What If Analysis

103 Questions

Exam 14

Action and Specialized Queries: Moving Beyond the Select Query

100 Questions

Exam 15

Interactivity and Advanced Animation: Hands On Exercise Videos

15 Questions

Exam 16

Action and Specialized Queries: Hands On Exercise Videos

14 Questions

Exam 17

Specialized Functions: Hands On Exercise Videos

16 Questions

Exam 18

Document Automation: Hands On Exercise Videos

19 Questions

Exam 19

Document Automation: Forms, macros, and Security

100 Questions

Exam 20

Customization: Customizing Powerpoint and the Slide Show

100 Questions

Exam 21

Specialized Functions

103 Questions

Exam 22

Advanced Forms and Reports: Moving Beyond the Basics

100 Questions

Exam 23

Customization: Hands On Exercise Videos

19 Questions

Exam 24

Advanced Forms and Reports: Hands On Exercise Videos

12 Questions

Exam 25

Statistical Functions: Hands On Exercise Videos

17 Questions

Exam 26

Word and the Internet: Hands On Exercise Videos

17 Questions

Exam 27

Word and the Internet: Web Page Creation and Enhancement and Blogs

100 Questions

Exam 28

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

100 Questions

Exam 29

Statistical Functions

103 Questions

Exam 30

Get Connected: Exchanging Data Between Access and Other Applications

100 Questions

Exam 31

Collaboration and Distribution: Hands On Exercise Videos

15 Questions

Exam 32

Get Connected: Hands On Exercise Videos

17 Questions

Exam 33

Multiple Sheet Workbook Management: Hands On Exercise Videos

16 Questions

Exam 34

Multiple Sheet Workbook Management

103 Questions

Exam 35

Fine Tuning the Database: Analyzing and Improving Database Performance

100 Questions

Exam 36

Fine Tuning the Database: Hands On Exercise Videos

17 Questions

Exam 37

Imports, web Queries, and XML: Hands-On-Exercise Videos

13 Questions

Exam 38

Imports, web Queries, and XML

103 Questions

Exam 39

Using Macros and SQL in Access: Advanced Techniques

100 Questions

Exam 40

Using Macros and SQL in Access: Hands On Exercise Videos

16 Questions

Exam 41

Collaboration and Workbook Distribution: Hands On Exercise Videos

17 Questions

Exam 42

Collaboration and Workbook Distribution

103 Questions

Exam 43

Templates styles and Macros

103 Questions

Exam 44

Templates, styles, and Macros: Hands-On-Exercise Videos

18 Questions

Show Answer