Question 1

What are the benefits of using Slicers over traditional filters?

Accepted Answer

The answer of What are the benefits of using Slicers...

Question 2

What are the benefits of using PivotTables over traditional data tables?

Accepted Answer

The answer of What are the benefits of using PivotTables...

Question 3

In what situations would you change the default data field calculations settings of a PivotTable?

Accepted Answer

The answer of In what situations would you change the...

Question 4

Match between columns
                        Premises: Update Link
Edit Link
Open Link
Linked Object
Paste Link

Accepted Answer

The Answer of can make modifications within Word and retrieves is...

Question 5

Match between columns
                        Premises: layer
fill
grid
rotate
flip

Accepted Answer

The Answer of shift an object in a particular direction is...

Question 6

Match between columns
                        Premises: Copy and Paste
Copy and Paste Special will be moved into Word
Drag and Drop
Display as icon option in Paste Special
Create New tab in the Object dialog box

Accepted Answer

The Answer of allows access to the Paste link option is...

Question 7

Match between columns
                        Premises: Drawing Canvas
Lock anchor setting
Bring Forward
Send Backward
Send Behind text

Accepted Answer

The Answer of use to assign an absolute position to is...

Question 8

Match between columns
                        Premises: layering
grouping
resizing
ungrouping
flipping

Accepted Answer

The Answer of breaks a combined object into individual shapes is...

Question 9

Match between columns
                        Premises: SmartArt
WordArt
pull quote
drawing shapes
Link two text boxes

Accepted Answer

The Answer of add three-dimensional effects and a sentence to is...

Question 10

Match between columns
                        Premises: insert a SmartArt graphic
insert a section break
add a border
resize an object
rotate an object

Accepted Answer

The Answer of Paragraph Group and Arrange group and Page is...

Question 11

Match between columns
                        Premises: add a drop cap
insert a column break
add a border
change appearance of a SmartArt design
move WordArt text into position

Accepted Answer

The Answer of INSERT tab and FORMAT tab and PAGE is...

Question 12

Match between columns
                        Premises: clip art
borders
shading
lists
styles

Accepted Answer

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

Question 13

Match between columns
                        Premises: reverse
masthead
drop cap
typography
styles

Accepted Answer

The Answer of identifying information at the top of a is...

Question 14

Match between columns
                        Premises: XY chart
single-series data series chart
multiseries data series chart
default chart
single- or multiseries chart

Accepted Answer

The Answer of column chart and pie chart and scatter is...

Question 15

Match between columns
                        Premises: Cell Bevel, Shadow, Reflection
Color, Picture, Texture
Rotate all text 90 degrees, Stacked
Align Left, Center
Align Top, Align Bottom

Accepted Answer

The Answer of text direction and cell or table background is...

Question 16

Match between columns
                        Premises: Eraser
Distribute Columns
Object
Edit Data
Slide Size

Accepted Answer

The Answer of Layout tab and Table Tools Design tab is...

Question 17

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

Accepted Answer

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

Question 18

Match between columns
                        Premises: plot area
chart area
data points
data series
multiseries

Accepted Answer

The Answer of cells that contain numeric values and area is...

Question 19

Match between columns
                        Premises: data markers
legend
tick marks
gridlines
leaders

Accepted Answer

The Answer of lines that extend from the horizontal or is...

Question 20

Match between columns
                        Premises: pie chart
line chart
bar chart
area chart
XY chart

Accepted Answer

The Answer of shows proportions of a whole and displays is...

Quiz 5: Subtotals Pivot-tables and Pivot-charts

What are the benefits of using Slicers over traditional filters?

What are the benefits of using PivotTables over traditional data tables?

In what situations would you change the default data field calculations settings of a PivotTable?

Match the following terms to their meanings:

Match the following terms to their meanings:

Match the following terms to their meanings:

Match the following terms to their meanings:

Match the following terms to their meanings:

Match the following Word features to the range of words that related to the feature:

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

Match the following terms to the tab where it is located:

Match the following terms to their meanings:

Match the following terms to their meanings:

Match each task to the dialog box to accomplish that task:

Match the following PowerPoint options to their functions:

Match each button with the tab where it can be found:

Match the following charts to their descriptions:

Match the following chart elements with their descriptions:

Match the following chart elements with their descriptions:

Match the following charts to their descriptions: