Question 1

With 3-D rotation,you can change a chart's ____.

Accepted Answer

A)  rotation 
B)  perspective 
C)  depth 
D)  all of the above 
A)  rotation 
B)  perspective 
C)  depth 
D)  all of the above D

Question 2

Which of the following would result in adding the value 'k' to the end of each number on a chart's vertical axis?

Accepted Answer

A)  #,##0"k" 
B)  k#,## 
C)  #,##0k 
D)  #,##0-k- 
A)  #,##0"k" 
B)  k#,## 
C)  #,##0k 
D)  #,##0-k- A

Question 3

A chart that combines two or more chart types into a single graph is called a(n)____________________ chart.

Accepted Answer

combination

Question 4

You can add ___________________ to identify smaller intervals between the major tick marks.

Accepted Answer

The answer of You can add ___________________ to identify smaller...

Question 5

For which of the following reasons would you choose to use a chart or graph?

Accepted Answer

A)  To organize information in columns and rows 
B)  To show trends or relationships across data 
C)  To present data using text only 
D)  To add color to a report 
A)  To organize information in columns and rows 
B)  To show trends or relationships across data 
C)  To present data using text only 
D)  To add color to a report

Question 6

The first step in creating a combination chart is to ____.

Accepted Answer

A)  select a data series in an existing chart that you want to appear as another chart type 
B)  click Change Chart Type in the Chart Tools Design tab 
C)  select the chart type you want 
D)  open a new bland spreadsheet 
A)  select a data series in an existing chart that you want to appear as another chart type 
B)  click Change Chart Type in the Chart Tools Design tab 
C)  select the chart type you want 
D)  open a new bland spreadsheet

Question 7

Andy has experimented with a few different types of charts to give his boss options for reporting the test results.In his bar chart,Andy wants to change the chart's border.To do this,he should select the ____ tab in the Chart Tools.

Accepted Answer

A)  Format 
B)  Edit 
C)  Design 
D)  Layout 
A)  Format 
B)  Edit 
C)  Design 
D)  Layout

Question 8

You can use the 3-D Format options to add drop shadows,raised or beveled corners,and textured surfaces that give the illusion of ____ reflecting off the chart elements.

Accepted Answer

A)  light 
B)  color 
C)  water 
D)  shadows 
A)  light 
B)  color 
C)  water 
D)  shadows

Question 9

To move one slice of a pie chart away from the pie creates a(n)____.

Accepted Answer

A)  spontaneous pie chart 
B)  perfect pie chart 
C)  exploded pie chart 
D)  exponential pie chart 
A)  spontaneous pie chart 
B)  perfect pie chart 
C)  exploded pie chart 
D)  exponential pie chart

Question 10

When data bars are used with negative values,the date bars originate from the center of the cell with negative bars extending to the left and positive bars extending to the right.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following represents the pointer when it is over the resizing handle?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 12

Critical-Thinking Case Based Questions
Case 4-1
Andy has just started a job with the school district.His director has given him the last six months of test results from four local schools.Andy has organized the results as four data series and needs to display the trends in a graphic format.
-Andy's boss wants him to compare the values in this chart with several different data sets.Andy should prepare a(n)____ for his boss.

Accepted Answer

A)  Radar chart 
B)  Line graph 
C)  Pie chart 
D)  XY scatter chart 
A)  Radar chart 
B)  Line graph 
C)  Pie chart 
D)  XY scatter chart

Question 13

-In the above figure,the data markers shown in the cells in the column labeled "Percentages," are ____.

Accepted Answer

A)  data lines 
B)  sparklines 
C)  data bars 
D)  spark bars 
A)  data lines 
B)  sparklines 
C)  data bars 
D)  spark bars

Question 14

To display Mar 17,2008 as a custom format,you would type ____ in the Format Code: box in Excel.

Accepted Answer

A)  mm dd,yy 
B)  mmm dd,yy 
C)  mmm dd,yyyy 
D)  mm dd,yyyy 
A)  mm dd,yy 
B)  mmm dd,yy 
C)  mmm dd,yyyy 
D)  mm dd,yyyy

Question 15

To specify the name of a new data series and its range of data values,use the ____ dialog box.

Accepted Answer

A)  Edit Series 
B)  Select Data 
C)  Select Series 
D)  Add Data 
A)  Edit Series 
B)  Select Data 
C)  Select Series 
D)  Add Data

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays stock market data

Accepted Answer

A) Bubble 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Doughnut
H)Bar
I)Surface
J)Area
K)Stock
L)Scatter 
A) Bubble 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Doughnut
H)Bar
I)Surface
J)Area
K)Stock
L)Scatter

Question 17

='Trolley Schedule'!$A$2:$C$12 identifies a ____.

Accepted Answer

A)  Series data range 
B)  Column chart type 
C)  Chart series source 
D)  Chart data range 
A)  Series data range 
B)  Column chart type 
C)  Chart series source 
D)  Chart data range

Question 18

Which of the following shows the correct order of steps for adding a data series to a chart?

Accepted Answer

A)  Select the chart,Click the Add button,Click the Select Data button,Select the range 
B)  Select the chart,Click the Select Data button,Click the Add button,Select the range 
C)  Select the range,Click the Select Data button,Click the Add button,Select the chart 
D)  Select the range,Select the chart,Click the Select Data button,Click the Add button 
A)  Select the chart,Click the Add button,Click the Select Data button,Select the range 
B)  Select the chart,Click the Select Data button,Click the Add button,Select the range 
C)  Select the range,Click the Select Data button,Click the Add button,Select the chart 
D)  Select the range,Select the chart,Click the Select Data button,Click the Add button

Question 19

Rotation options for a chart allow you to rotate the ____.

Accepted Answer

A)  x-axis 
B)  y-axis 
C)  perspective 
D)  all of the above 
A)  x-axis 
B)  y-axis 
C)  perspective 
D)  all of the above

Question 20

Anya has decided to make her chart a 3-D chart,but her supervisor complained that he cannot see enough of the data.Anya should try to ____.

Accepted Answer

A)  raise the viewpoint of the chart by rotating along the y-axis 
B)  raise the viewpoint of the chart by rotating along the x-axis 
C)  spin the chart clockwise 
D)  replace the chart with a bar chart 
A)  raise the viewpoint of the chart by rotating along the y-axis 
B)  raise the viewpoint of the chart by rotating along the x-axis 
C)  spin the chart clockwise 
D)  replace the chart with a bar chart

With 3-D rotation,you can change a chart's ____.

Which of the following would result in adding the value 'k' to the end of each number on a chart's vertical axis?

A chart that combines two or more chart types into a single graph is called a(n)____________________ chart.

You can add ___________________ to identify smaller intervals between the major tick marks.

For which of the following reasons would you choose to use a chart or graph?

The first step in creating a combination chart is to ____.

Andy has experimented with a few different types of charts to give his boss options for reporting the test results.In his bar chart,Andy wants to change the chart's border.To do this,he should select the ____ tab in the Chart Tools.

You can use the 3-D Format options to add drop shadows,raised or beveled corners,and textured surfaces that give the illusion of ____ reflecting off the chart elements.

To move one slice of a pie chart away from the pie creates a(n)____.

When data bars are used with negative values,the date bars originate from the center of the cell with negative bars extending to the left and positive bars extending to the right.

Which of the following represents the pointer when it is over the resizing handle?

-In the above figure,the data markers shown in the cells in the column labeled "Percentages," are ____.

To display Mar 17,2008 as a custom format,you would type ____ in the Format Code: box in Excel.

To specify the name of a new data series and its range of data values,use the ____ dialog box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays stock market data

='Trolley Schedule'!$A$2:$C$12 identifies a ____.

Which of the following shows the correct order of steps for adding a data series to a chart?

Rotation options for a chart allow you to rotate the ____.

Anya has decided to make her chart a 3-D chart,but her supervisor complained that he cannot see enough of the data.Anya should try to ____.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 4: Enhancing a Workbook With Charts and Graphs

With 3-D rotation,you can change a chart's ____.

Which of the following would result in adding the value 'k' to the end of each number on a chart's vertical axis?

A chart that combines two or more chart types into a single graph is called a(n)____________________ chart.

You can add ___________________ to identify smaller intervals between the major tick marks.

For which of the following reasons would you choose to use a chart or graph?

The first step in creating a combination chart is to ____.

Andy has experimented with a few different types of charts to give his boss options for reporting the test results.In his bar chart,Andy wants to change the chart's border.To do this,he should select the ____ tab in the Chart Tools.

You can use the 3-D Format options to add drop shadows,raised or beveled corners,and textured surfaces that give the illusion of ____ reflecting off the chart elements.

To move one slice of a pie chart away from the pie creates a(n)____.

When data bars are used with negative values,the date bars originate from the center of the cell with negative bars extending to the left and positive bars extending to the right.

Which of the following represents the pointer when it is over the resizing handle?

-In the above figure,the data markers shown in the cells in the column labeled "Percentages," are ____.

To display Mar 17,2008 as a custom format,you would type ____ in the Format Code: box in Excel.

To specify the name of a new data series and its range of data values,use the ____ dialog box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays stock market data

='Trolley Schedule'!$A$2:$C$12 identifies a ____.

Which of the following shows the correct order of steps for adding a data series to a chart?

Rotation options for a chart allow you to rotate the ____.

Anya has decided to make her chart a 3-D chart,but her supervisor complained that he cannot see enough of the data.Anya should try to ____.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters