Question 1

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

Question 2

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

Question 3

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

Accepted Answer

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

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

A)   
B)   
C)   
D)

Question 12

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

Question 13

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 14

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

Question 15

='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

Question 16

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

Question 17

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

Accepted Answer

combination

Question 18

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)  RadarF) PieG) DoughnutH) BarI) SurfaceJ) AreaK) StockL) Scatter

Question 19

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

Question 20

-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

Exam 4: Enhancing a Workbook With Charts and Graphs

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified
A

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

Correct Answer
verified

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 ____.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
D

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

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified
combination

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 4: Enhancing a Workbook With Charts and Graphs

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

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 ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedD

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct Answerverifiedcombination

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
combination

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified