Question 1

Your supervisor has created a spreadsheet and a chart is included in the workbook. 
 Your supervisor thinks the chart legend is too large, how should you fix the chart?

Accepted Answer

Click on the legend, then drag one of its sizing handles to make it smaller.

Question 2

In the accompanying figure, item 4 points to the ____.

Accepted Answer

A)  plot area 
B)  chart area 
C)  fill color 
D)  highlighted area 
A)  plot area 
B)  chart area 
C)  fill color 
D)  highlighted area A

Question 3

In the accompanying figure, there are ____ categories.

Accepted Answer

A)  four 
B)  five 
C)  zero 
D)  three 
A)  four 
B)  five 
C)  zero 
D)  three D

Question 4

A worksheet is a much more effective way to communicate data to an audience than a chart.

Accepted Answer

A) True 
 B)False

Question 5

In a worksheet, you select the cells that contain the data you want to chart, and then click the Recommended Charts button on the INSERT tab to choose from a selection of chart types

Accepted Answer

A) True 
 B)False

Question 6

The _____________________ is the part of the chart contained within the horizontal and vertical axes.

Accepted Answer

The answer of The _____________________ is the part of the...

Question 7

In the accompanying figure, item 1 points to the ____.

Accepted Answer

A)  x-axis 
B)  data range 
C)  axis titles 
D)  data series 
A)  x-axis 
B)  data range 
C)  axis titles 
D)  data series

Question 8

You put together a spreadsheet for your company containing the quarterly sales figures for each region. Each column of the spreadsheet represents a quarter and each row represents a department's figures. 
 Describe which chart type you should use to show how three of the departments compared to each other for all of the quarters.

Accepted Answer

You should

Question 9

A ____ chart is an effective tool for comparing the relative values of parts to a whole.

Accepted Answer

A)  Pie 
B)  Column 
C)  Bubble 
D)  Circle 
A)  Pie 
B)  Column 
C)  Bubble 
D)  Circle

Question 10

The Offset Bottom Shadow style is an example of a shape _______________ that can be added to a chart element.

Accepted Answer

The answer of The Offset Bottom Shadow style is an...

Question 11

You can change one type of chart to another by clicking the Change Chart Type button on the CHANGE TOOLS DESIGN tab

Accepted Answer

A) True 
 B)False

Question 12

A(n) _____________________ in a chart is a grid containing the chart's underlying worksheet data.

Accepted Answer

The answer of A(n) _____________________ in a chart is a...

Question 13

The ____ is the vertical line that defines the left edge of the chart and provides values.

Accepted Answer

A)  title axis 
B)  z-axis 
C)  x-axis 
D)  y-axis 
A)  title axis 
B)  z-axis 
C)  x-axis 
D)  y-axis

Question 14

In the accompanying figure, item 2 points to the ____.

Accepted Answer

A)  data series 
B)  legend 
C)  chart title 
D)  data range 
A)  data series 
B)  legend 
C)  chart title 
D)  data range

Question 15

Your supervisor has created a spreadsheet and a chart is included in the workbook. 
 Describe how you should change the chart to have an overall theme of purple elements.

Accepted Answer

Select the chart, then click t

Question 16

To remove a data table from a chart click the Data Table check box in the Chart _____________ menu to remove it.

Accepted Answer

The answer of To remove a data table from a...

Question 17

It is important to organize your rows and columns of data so that when you create a chart, it illustrates the points you want to make.

Accepted Answer

A) True 
 B)False

Question 18

It is possible to move a chart to a new location on the worksheet after it has been created.

Accepted Answer

A) True 
 B)False

Question 19

If data labels on a chart are too small to read you can increase their ____ size before printing the chart.

Accepted Answer

A)  text 
B)  font 
C)  letter 
D)  form 
A)  text 
B)  font 
C)  letter 
D)  form

Question 20

To modify chart element text, such as a title, click in the ____ text.

Accepted Answer

A)  box 
B)  placeholder 
C)  dialog box 
D)  pane 
A)  box 
B)  placeholder 
C)  dialog box 
D)  pane

Your supervisor has created a spreadsheet and a chart is included in the workbook. Your supervisor thinks the chart legend is too large, how should you fix the chart?

In the accompanying figure, item 4 points to the ____.

In the accompanying figure, there are ____ categories.

A worksheet is a much more effective way to communicate data to an audience than a chart.

In a worksheet, you select the cells that contain the data you want to chart, and then click the Recommended Charts button on the INSERT tab to choose from a selection of chart types

The _____________________ is the part of the chart contained within the horizontal and vertical axes.

In the accompanying figure, item 1 points to the ____.

A ____ chart is an effective tool for comparing the relative values of parts to a whole.

The Offset Bottom Shadow style is an example of a shape _______________ that can be added to a chart element.

You can change one type of chart to another by clicking the Change Chart Type button on the CHANGE TOOLS DESIGN tab

A(n) _____________________ in a chart is a grid containing the chart's underlying worksheet data.

The ____ is the vertical line that defines the left edge of the chart and provides values.

In the accompanying figure, item 2 points to the ____.

Your supervisor has created a spreadsheet and a chart is included in the workbook. Describe how you should change the chart to have an overall theme of purple elements.

To remove a data table from a chart click the Data Table check box in the Chart _____________ menu to remove it.

It is important to organize your rows and columns of data so that when you create a chart, it illustrates the points you want to make.

It is possible to move a chart to a new location on the worksheet after it has been created.

If data labels on a chart are too small to read you can increase their ____ size before printing the chart.

To modify chart element text, such as a title, click in the ____ text.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Creating and Enhancing a Worksheet

Using Complex Formulas, Functions, and Tables

Creating a Database

Working With Data

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters

Exam 9: Working With Charts

Your supervisor has created a spreadsheet and a chart is included in the workbook. Your supervisor thinks the chart legend is too large, how should you fix the chart?

In the accompanying figure, item 4 points to the ____.

In the accompanying figure, there are ____ categories.

A worksheet is a much more effective way to communicate data to an audience than a chart.

In a worksheet, you select the cells that contain the data you want to chart, and then click the Recommended Charts button on the INSERT tab to choose from a selection of chart types

The _____________________ is the part of the chart contained within the horizontal and vertical axes.

In the accompanying figure, item 1 points to the ____.

A ____ chart is an effective tool for comparing the relative values of parts to a whole.

The Offset Bottom Shadow style is an example of a shape _______________ that can be added to a chart element.

You can change one type of chart to another by clicking the Change Chart Type button on the CHANGE TOOLS DESIGN tab

A(n) _____________________ in a chart is a grid containing the chart's underlying worksheet data.

The ____ is the vertical line that defines the left edge of the chart and provides values.

In the accompanying figure, item 2 points to the ____.

Your supervisor has created a spreadsheet and a chart is included in the workbook. Describe how you should change the chart to have an overall theme of purple elements.

To remove a data table from a chart click the Data Table check box in the Chart _____________ menu to remove it.

It is important to organize your rows and columns of data so that when you create a chart, it illustrates the points you want to make.

It is possible to move a chart to a new location on the worksheet after it has been created.

If data labels on a chart are too small to read you can increase their ____ size before printing the chart.

To modify chart element text, such as a title, click in the ____ text.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Creating and Enhancing a Worksheet

Using Complex Formulas, Functions, and Tables

Creating a Database

Working With Data

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters