Question 1

The first step in creating a chart is to choose a chart type that presents the data in the clearest way possible.

Accepted Answer

A) True 
 B)False

Question 2

Case PPT 6-2 Simon is a financial analyst working on a PowerPoint presentation to aid his discussion on new home sales data in the Eastern regions of the United States. His data is accumulated from three economic reports provided to him daily. Simon then imports this economic data into an Excel worksheet each morning where predefined calculations manipulate the data for his informational needs. Simon needs to get portions of this data into his slide show. Because Simon's data is regularly updated in Excel, he should ____.

Accepted Answer

A)  import the Excel chart data into his presentation file as a linked object 
B)  import the Excel chart data into his presentation file as an embedded object 
C)  drag and drop the data into the slide show 
D)  consider using another program to display the data separately 
A)  import the Excel chart data into his presentation file as a linked object 
B)  import the Excel chart data into his presentation file as an embedded object 
C)  drag and drop the data into the slide show 
D)  consider using another program to display the data separately

Question 3

A(n) ____________________ chart type illustrates parts as they relate to a whole, like a pie chart, but can be used for more than one data series.

Accepted Answer

The answer of A(n) ____________________ chart type illustrates parts as...

Question 4

You can change the direction in which PowerPoint plots data.

Accepted Answer

A) True 
 B)False

Question 5

The ____________________ chart element represents text or numbers that provide additional information about a value in the data series.

Accepted Answer

The answer of The ____________________ chart element represents text or...

Question 6

You can use the ____ to resize elements.

Accepted Answer

A)  Grid Draw tool 
B)  sizing handles 
C)  Kerning tool 
D)  resize button 
A)  Grid Draw tool 
B)  sizing handles 
C)  Kerning tool 
D)  resize button

Question 7

Case PPT 6-2 Simon is a financial analyst working on a PowerPoint presentation to aid his discussion on new home sales data in the Eastern regions of the United States. His data is accumulated from three economic reports provided to him daily. Simon then imports this economic data into an Excel worksheet each morning where predefined calculations manipulate the data for his informational needs. Simon needs to get portions of this data into his slide show. As the data can vary from day to day, Simon is concerned about keeping his formatting consistent. He should use the ____ options, which enable Simon to use source formatting.

Accepted Answer

A)  Insert 
B)  Update 
C)  Paste 
D)  Imbed 
A)  Insert 
B)  Update 
C)  Paste 
D)  Imbed

Question 8

A(n) chart provides a graphic representation of data.

Accepted Answer

A) True 
 B)False

Question 9

You can apply quick styles and borders to charts.

Accepted Answer

A) True 
 B)False

Question 10

You can apply a(n) theme from the gallery to create an exploded slice on a pie chart to make it more obvious.

Accepted Answer

A) True 
 B)False

Question 11

You can use the Table Eraser tool to remove the ____.

Accepted Answer

A)  table 
B)  cell boundaries 
C)  slide 
D)  table theme 
A)  table 
B)  cell boundaries 
C)  slide 
D)  table theme

Question 12

Match between columns
                        Premises: A chart type whereby a line connects a value axis from the center for each category to all values in the same series.
A chart type that is effective for showing trends over time.
A chart type whereby data points are plotted using two value axes, and are displayed in uneven intervals or clusters.
A chart type that illustrates the magnitude of change over time, displaying the sum of plotted values.
A chart type that is useful for showing how parts relate to a whole unit.

Accepted Answer

The Answer of Line and Pie and Radar and Area is...

Question 13

You can manually set column spacing.

Accepted Answer

A) True 
 B)False

Question 14

When table text is rotated, the spacing between characters changes.

Accepted Answer

A) True 
 B)False

Question 15

You can ____ an element within the chart area to select it.

Accepted Answer

A)  click 
B)  right-click 
C)  double-click 
D)  hover over 
A)  click 
B)  right-click 
C)  double-click 
D)  hover over

Question 16

You can introduce parts of a table in segments .

Accepted Answer

A) True 
 B)False

Question 17

A table ____________________ provides formats for shading, borders, and effects.

Accepted Answer

The answer of A table ____________________ provides formats for shading,...

Question 18

A(n) ____________________ chart type might be used to compare the progress of sales reps achieving sales goals.

Accepted Answer

The answer of A(n) ____________________ chart type might be used...

Question 19

A(n) ____ object becomes part of the destination file and can be edited in the destination file.

Accepted Answer

A)  attached 
B)  static 
C)  linked 
D)  embedded 
A)  attached 
B)  static 
C)  linked 
D)  embedded

Question 20

Chart elements consist of graphics and text ____.

Accepted Answer

A)  boxes 
B)  menus 
C)  buttons 
D)  tabs 
A)  boxes 
B)  menus 
C)  buttons 
D)  tabs

Exam 39: Working With Tables and Charts

The first step in creating a chart is to choose a chart type that presents the data in the clearest way possible.

A(n) ____________________ chart type illustrates parts as they relate to a whole, like a pie chart, but can be used for more than one data series.

You can change the direction in which PowerPoint plots data.

The ____________________ chart element represents text or numbers that provide additional information about a value in the data series.

You can use the ____ to resize elements.

A(n) chart provides a graphic representation of data.

You can apply quick styles and borders to charts.

You can apply a(n) theme from the gallery to create an exploded slice on a pie chart to make it more obvious.

You can use the Table Eraser tool to remove the ____.

You can manually set column spacing.

When table text is rotated, the spacing between characters changes.

You can ____ an element within the chart area to select it.

You can introduce parts of a table in segments .

A table ____________________ provides formats for shading, borders, and effects.

A(n) ____________________ chart type might be used to compare the progress of sales reps achieving sales goals.

A(n) ____ object becomes part of the destination file and can be edited in the destination file.

Chart elements consist of graphics and text ____.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters