Question 1

Discuss the guidelines that you should use for planning a chart.

Accepted Answer

Determine the purpose of the chart and i...

Question 2

Moving a chart to a different sheet in the workbook will not change the original data reflected in the chart.​

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: Before creating this, you need to plan the information you want it to show.

Accepted Answer

The Answer of data marker and chart and category axis is...

Question 4

Any data changed in the worksheet is automatically updated in the chart.

Accepted Answer

A) True 
 B)False

Question 5

To base a chart on data in nonadjacent ranges, press and hold [Ctrl] while selecting each range.​

Accepted Answer

A) True 
 B)False

Question 6

You can add a text box using the Chart Tools ____ tab.

Accepted Answer

A)   Design
B)   Layout
C)   Format
D)   TextE) None of the above
F) A) and D)

Question 7

In a pie chart, slices that are pulled away are said to be ____.

Accepted Answer

A)   identified
B)   exploded
C)   opened
D)   extractedE) B) and D)
F) B) and C)

Question 8

Which two charts compare trends over time intervals?

Accepted Answer

A)   bar and pie
B)   pie and area
C)   area and line
D)   line and scatterE) B) and D)
F) None of the above

Question 9

A collection of related data points is called a ____.

Accepted Answer

A)   data marker
B)   tick mark
C)   data point
D)   data seriesE) A) and D)
F) All of the above

Question 10

You can resize a chart to improve its appearance by dragging its sizing handles . _________________________

Accepted Answer

A) True 
 B)False

Question 11

A chart must be located in a specific cell or at a specific address range.

Accepted Answer

A) True 
 B)False

Question 12

To add a shadow to an object, click the ____ button in the Format Chart Title pane, click Shadow, and make the desired selections.

Accepted Answer

A)   Options
B)   Effects
C)   Tools
D)   Shadow FormatE) A) and B)
F) A) and C)

Question 13

Which of the following will NOT be affected or rearranged by choosing a new layout on the Chart Tools Design tab?

Accepted Answer

A)   data
B)   legend
C)   titles
D)   gridlinesE) A) and D)
F) C) and D)

Question 14

The Quick Chart tool recommends charts based on the selected data.​ ____________________

Accepted Answer

A) True 
 B)False

Question 15

A chart that is inserted directly in the current worksheet is called a(n)  ____ chart.

Accepted Answer

A)   inner
B)   embedded
C)   sub
D)   interactiveE) All of the above
F) B) and D)

Question 16

The x-axis and y-axis are, respectively, the ____.

Accepted Answer

A)   horizontal and vertical axes
B)   data series and gridlines
C)   tick markers and data series
D)   vertical and horizontal axesE) C) and D)
F) A) and C)

Question 17

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

Accepted Answer

A) True 
 B)False

Question 18

You can format the text in a chart object using the Home tab or the Mini toolbar.​

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: Visually represents each data point.

Accepted Answer

The Answer of category axis and data marker and object is...

Question 20

On a chart created in Excel, the vertical axis is also called the ____.

Accepted Answer

A)   x-axis
B)   y-axis
C)   data marker
D)   legendE) C) and D)
F) B) and D)

Exam 9: Excel 4: Working With Charts

The x-axis and y-axis are, respectively, the ____.

Correct Answer
verified

Any data changed in the worksheet is automatically updated in the chart.

Correct Answer
verified

On a chart created in Excel, the vertical axis is also called the ____.

Correct Answer
verified

To add a shadow to an object, click the ____ button in the Format Chart Title pane, click Shadow, and make the desired selections.

Correct Answer
verified

You can resize a chart to improve its appearance by dragging its sizing handles . _________________________

Correct Answer
verified

A collection of related data points is called a ____.

Correct Answer
verified

The Quick Chart tool recommends charts based on the selected data. ____________________

Correct Answer
verified

A chart must be located in a specific cell or at a specific address range.

Correct Answer
verified

To base a chart on data in nonadjacent ranges, press and hold [Ctrl] while selecting each range.

Correct Answer
verified

Which of the following will NOT be affected or rearranged by choosing a new layout on the Chart Tools Design tab?

Correct Answer
verified

You can format the text in a chart object using the Home tab or the Mini toolbar.

Correct Answer
verified

In a pie chart, slices that are pulled away are said to be ____.

Correct Answer
verified

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

Correct Answer
verified

Moving a chart to a different sheet in the workbook will not change the original data reflected in the chart.

Correct Answer
verified

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

Correct Answer
verified

You can add a text box using the Chart Tools ____ tab.

Correct Answer
verified

Which two charts compare trends over time intervals?

Correct Answer
verified

Discuss the guidelines that you should use for planning a chart.

Correct Answer
verified
Determine the purpose of the chart and i...
View Answer

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Exam 9: Excel 4: Working With Charts

The x-axis and y-axis are, respectively, the ____.

Correct AnswerverifiedShow Answer

Any data changed in the worksheet is automatically updated in the chart.

Correct AnswerverifiedShow Answer

On a chart created in Excel, the vertical axis is also called the ____.

Correct AnswerverifiedShow Answer

To add a shadow to an object, click the ____ button in the Format Chart Title pane, click Shadow, and make the desired selections.

Correct AnswerverifiedShow Answer

You can resize a chart to improve its appearance by dragging its sizing handles . _________________________

Correct AnswerverifiedShow Answer

A collection of related data points is called a ____.

Correct AnswerverifiedShow Answer

The Quick Chart tool recommends charts based on the selected data.​ ____________________

Correct AnswerverifiedShow Answer

A chart must be located in a specific cell or at a specific address range.

Correct AnswerverifiedShow Answer

To base a chart on data in nonadjacent ranges, press and hold [Ctrl] while selecting each range.​

Correct AnswerverifiedShow Answer

Which of the following will NOT be affected or rearranged by choosing a new layout on the Chart Tools Design tab?

Correct AnswerverifiedShow Answer

You can format the text in a chart object using the Home tab or the Mini toolbar.​

Correct AnswerverifiedShow Answer

In a pie chart, slices that are pulled away are said to be ____.

Correct AnswerverifiedShow Answer

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

Correct AnswerverifiedShow Answer

Moving a chart to a different sheet in the workbook will not change the original data reflected in the chart.​

Correct AnswerverifiedShow Answer

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

Correct AnswerverifiedShow Answer

You can add a text box using the Chart Tools ____ tab.

Correct AnswerverifiedShow Answer

Which two charts compare trends over time intervals?

Correct AnswerverifiedShow Answer

Discuss the guidelines that you should use for planning a chart.

Correct AnswerverifiedDetermine the purpose of the chart and i...View AnswerShow Answer

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

The Quick Chart tool recommends charts based on the selected data. ____________________

Correct Answer
verified

Correct Answer
verified

To base a chart on data in nonadjacent ranges, press and hold [Ctrl] while selecting each range.

Correct Answer
verified

Correct Answer
verified

You can format the text in a chart object using the Home tab or the Mini toolbar.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Moving a chart to a different sheet in the workbook will not change the original data reflected in the chart.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Determine the purpose of the chart and i...
View Answer