Match between columns Premises: % of Grand Total % of Column Total % of Row Total % of Parent Row Total Running Total

The Answer of Displays values as: (value for the item) is...

Match between columns Premises: Subtotal Outline Collapse Expand Grouping

The Answer of The process of joining rows or columns is...

Match between columns Premises: radar chart bubble chart surface chart column chart doughnut chart

The Answer of shows relationships using three values and compares is...

Match between columns Premises: 1 2 3 4 +

The Answer of Collapse outline to display the grand total is...

Match between columns Premises: clip art borders shading lists styles

The Answer of background of an element and used to is...

Exam 5: Subtotals Pivot-tables and Pivot-charts

Match each Slicer Tools command group with the corresponding description: I.Slicer II.Slicer Styles III.Arrange IV.Buttons V.Size A.Specifies the slicer's placement in relation to other groups,such as placing a slicer on top of other slicers. B.Sets the height and width of the slicer window. C.Defines how many columns are displayed in the selected slicer and the height and width of each button inside the slicer. D.Applies a style to the slicer by specifying the color of the filtered item in the slicer. E.Enables you to change the slicer caption,display the Slicer Settings dialog box for further customization,and manage the PivotTable connected to the slicer.

(Short Answer)

4.9/5

(27)

Question 41

Match the following calculated field settings with the corresponding description:

% of Grand Total

Displays values as: (value for the item) / (value for the parent item on rows)

% of Column Total

Displays each value as a percentage of the respective row total. The values in each row total 100%

% of Row Total

Displays each value as a percentage of the respective column total. The values in each column total 100%

Correct Answer:

Verified

% of Grand Total

% of Column Total

% of Row Total

% of Parent Row Total

Running Total

(Matching)

4.9/5

(36)

Question 42

Which of the following appears in the PivotTable Fields task pane?

(Multiple Choice)

4.8/5

(38)

Question 43

Match the following terms to their meanings:

Subtotal

The process of joining rows or columns of related data together into a single entity

Outline

A row within the dataset containing at least one aggregated value

Collapse

A hierarchical structure of data

Correct Answer:

Verified

Subtotal

Outline

Collapse

Expand

Grouping

(Matching)

4.9/5

(32)

Question 44

Match the following calculated field settings with the corresponding description

PivotTable Styles

A user-defined field that does not exist in the original dataset

Calculated field

Contains two sections that allow for the editing of a PivotTable

Slicer caption

A method of creating a PivotTable within a worksheet

Correct Answer:

Verified

PivotTable Styles

Calculated field

Slicer caption

PivotTable Fields task pane

Quick Analysis gallery

(Matching)

4.8/5

(36)

Question 45

Match the following terms to their meanings:

Drawing Canvas

use to assign an absolute position to a graphic

Lock anchor setting

moves the object to display behind text

Bring Forward

frame-like boundary object in the document

Correct Answer:

Verified

Drawing Canvas

Lock anchor setting

Bring Forward

Send Backward

Send Behind text

(Matching)

4.9/5

(40)

Question 46

Match the following PowerPoint options to their functions:

Cell Bevel, Shadow, Reflection

text direction

Color, Picture, Texture

cell or table background

Rotate all text 90 degrees, Stacked

special table effects

Correct Answer:

Verified

Cell Bevel, Shadow, Reflection

Color, Picture, Texture

Rotate all text 90 degrees, Stacked

Align Left, Center

Align Top, Align Bottom

(Matching)

4.9/5

(36)

Question 47

What does the Filters Area of a PivotTable do?

(Multiple Choice)

4.9/5

(39)

Question 48

When subtotals are applied the + that appears above the worksheet is the ________ button.

(Short Answer)

4.9/5

(33)

Question 49

Match the following terms to their meanings: I.Subtotal II.Outline III.Collapse IV.Expand V.Grouping A.The process of joining rows or columns of related data together into a single entity B.A row within the dataset containing at least one aggregated value C.A hierarchical structure of data D.Restricting the view of a grouped data set E.Displaying all information in a grouped data set

(Short Answer)

4.9/5

(35)

Question 50

Where are PivotTable formatting tools located?

(Multiple Choice)

4.9/5

(37)

Question 51

More than one function can be applied per field in a PivotTable.

(True/False)

4.9/5

(42)

Question 52

Once a slicer is inserted into a worksheet which of the following actions cannot be performed?

(Multiple Choice)

4.7/5

(28)

Question 53

Match the following charts to their descriptions:

radar chart

shows relationships using three values

bubble chart

compares aggregate values of three or more variables

surface chart

shows proportions to a whole

Correct Answer:

Verified

radar chart

bubble chart

surface chart

column chart

doughnut chart

(Matching)

4.8/5

(33)

Question 54

Match the following grouping button with the corresponding description:

1

Collapse outline to display the grand total only.

2

Displays subtotals by the main subtotal category, the secondary subtotal category, and the grand total.

3

Expand an outline group to see its details.

Correct Answer:

Verified

1

2

3

4

+

(Matching)

4.8/5

(47)

Question 55

From which of the following locations can you create a PivotTable?

(Multiple Choice)

4.8/5

(39)

Question 56

Custom slicers can be created in Excel.

(True/False)

4.8/5

(35)

Question 57

Match the following Word options to the group where it is located:

insert a SmartArt graphic

Paragraph Group

insert a section break

Arrange group

add a border

Page Setup Group

Correct Answer:

Verified

insert a SmartArt graphic

insert a section break

add a border

resize an object

rotate an object

(Matching)

4.7/5

(33)

Question 58

Match the following terms to their meanings:

clip art

background of an element

borders

used to organize information by emphasizing important points

shading

predefined set of formatting options to apply to characters or paragraphs

Correct Answer:

Verified

clip art

borders

shading

lists

styles

(Matching)

4.9/5

(41)

Question 59

When using subtotal,what does the 4th button of the outline levels do?

(Multiple Choice)

4.8/5

(28)

Question 60

Exam 5: Subtotals Pivot-tables and Pivot-charts

Which of the following appears in the PivotTable Fields task pane?

What does the Filters Area of a PivotTable do?

When subtotals are applied the + that appears above the worksheet is the ________ button.

Where are PivotTable formatting tools located?

More than one function can be applied per field in a PivotTable.

Once a slicer is inserted into a worksheet which of the following actions cannot be performed?

From which of the following locations can you create a PivotTable?

Custom slicers can be created in Excel.

When using subtotal,what does the 4th button of the outline levels do?

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

Desktop Publishing and Graphic Design: Hands On Exercise Videos

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

Infographics: Creating Text Charts, tables, and Graphs

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

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

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

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

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

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

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

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

Filters