Question 1

Pie charts can display parts of a whole effectively.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following charts could be used to easily group and compare categorized data sets?

Accepted Answer

A)  pie 
B)  area 
C)  column 
D)  line 
A)  pie 
B)  area 
C)  column 
D)  line

Question 3

Which of the following chart types does NOT display data in a standard X-Y plane?

Accepted Answer

A)  bar 
B)  column 
C)  line 
D)  pie 
A)  bar 
B)  column 
C)  line 
D)  pie

Question 4

There is only one type of trendline that can be added to a chart.

Accepted Answer

A) True 
 B)False

Question 5

The lines that go across charts to help gauge the size of the bars,columns,or data lines are known as ________.

Accepted Answer

The answer of The lines that go across charts to...

Question 6

A common method of emphasizing data in a pie chart is by adding a trendline.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following could be used to easily group and compare categorized data sets?

Accepted Answer

A)  bar 
B)  line 
C)  area 
D)  scatter 
A)  bar 
B)  line 
C)  area 
D)  scatter

Question 8

Charts must be placed in an existing worksheet.

Accepted Answer

A) True 
 B)False

Question 9

If a user wants to compare categorized data sets,they can do so effectively using a bar chart.

Accepted Answer

A) True 
 B)False

Question 10

A user wishes to chart people's height along the y-axis and their shoe size along the x-axis.A scatter chart is the best way to display this.

Accepted Answer

A) True 
 B)False

Question 11

A simple way to display change over time,which also emphasizes the data by displaying colored layers,is by using a(n)________ chart.

Accepted Answer

The answer of A simple way to display change over...

Question 12

A scatter chart is best used to display change over time.

Accepted Answer

A) True 
 B)False

Question 13

Each slice of a piece chart is an example of a data ________.

Accepted Answer

The answer of Each slice of a piece chart is...

Question 14

The lines that go across charts to help gauge the size of the bars,columns,and data lines are known as ________.

Accepted Answer

A)  data bars 
B)  sparklines 
C)  gridlines 
D)  trendlines 
A)  data bars 
B)  sparklines 
C)  gridlines 
D)  trendlines

Question 15

A set of data to be charted is also known as a(n)________.

Accepted Answer

The answer of A set of data to be charted...

Question 16

The scale of an axis refers to the color of that axis's lines.

Accepted Answer

A) True 
 B)False

Question 17

A common method to emphasize information on scatter charts is to add a trendline.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following chart types is most similar to a bar chart in terms of function?

Accepted Answer

A)  column 
B)  pie 
C)  line 
D)  scatter 
A)  column 
B)  pie 
C)  line 
D)  scatter

Question 19

Which of the following chart types would display a series in a circular fashion?

Accepted Answer

A)  bar 
B)  pie 
C)  column 
D)  line 
A)  bar 
B)  pie 
C)  column 
D)  line

Question 20

A(n)________ chart is used within a spreadsheet to give an immediate visual trend analysis and it adjusts as the source data changes.

Accepted Answer

The answer of A(n)________ chart is used within a spreadsheet...

Exam 12: Microsoft Excel 2010,workshop 4: Using Charts

Pie charts can display parts of a whole effectively.

Which of the following charts could be used to easily group and compare categorized data sets?

Which of the following chart types does NOT display data in a standard X-Y plane?

There is only one type of trendline that can be added to a chart.

The lines that go across charts to help gauge the size of the bars,columns,or data lines are known as ________.

A common method of emphasizing data in a pie chart is by adding a trendline.

Which of the following could be used to easily group and compare categorized data sets?

Charts must be placed in an existing worksheet.

If a user wants to compare categorized data sets,they can do so effectively using a bar chart.

A user wishes to chart people's height along the y-axis and their shoe size along the x-axis.A scatter chart is the best way to display this.

A simple way to display change over time,which also emphasizes the data by displaying colored layers,is by using a(n)________ chart.

A scatter chart is best used to display change over time.

Each slice of a piece chart is an example of a data ________.

The lines that go across charts to help gauge the size of the bars,columns,and data lines are known as ________.

A set of data to be charted is also known as a(n)________.

The scale of an axis refers to the color of that axis's lines.

A common method to emphasize information on scatter charts is to add a trendline.

Which of the following chart types is most similar to a bar chart in terms of function?

Which of the following chart types would display a series in a circular fashion?

A(n)________ chart is used within a spreadsheet to give an immediate visual trend analysis and it adjusts as the source data changes.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters