Question 1

A collection of related data points is called a ____.

Accepted Answer

A)  data marker 
B)  tick mark 
C)  data point 
D)  data series 
A)  data marker 
B)  tick mark 
C)  data point 
D)  data series D

Question 2

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

Accepted Answer

A)  x-axis 
B)  y-axis 
C)  data marker 
D)  legend 
A)  x-axis 
B)  y-axis 
C)  data marker 
D)  legend A

Question 3

As shown in the figure above, item 2 points to ____________________.

Accepted Answer

tick marks,tick mark

Question 4

WordArt, which lets you create curved or stylized text, can be created using the Chart Tools Format tab.

Accepted Answer

A) True 
 B)False

Question 5

Each value in a cell selected for a chart is called a ____.

Accepted Answer

A)  data marker 
B)  tick mark 
C)  data point 
D)  data series 
A)  data marker 
B)  tick mark 
C)  data point 
D)  data series

Question 6

You are a manager in the Sales department for a clothing store that has three locations. You have prepared the following worksheet containing data about the sales figures for the company, which also has a chart of the data.   Which store location had the highest sales in the 2nd Quarter? Which had the lowest sales in the same quarter?

Accepted Answer

Los Angeles had the

Question 7

You can modify the data range and configuration of a chart in the ____ group of the Chart Tools Design tab.

Accepted Answer

A)  Data 
B)  Type 
C)  Chart Layouts 
D)  Chart Styles 
A)  Data 
B)  Type 
C)  Chart Layouts 
D)  Chart Styles

Question 8

A scatter chart ____.

Accepted Answer

A)  compares distinct, unrelated objects over time using a horizontal format 
B)  compares trends over even time intervals 
C)  compares trends over uneven time or measurement intervals 
D)  combines a column and line chart to compare data requiring different scales of measure 
A)  compares distinct, unrelated objects over time using a horizontal format 
B)  compares trends over even time intervals 
C)  compares trends over uneven time or measurement intervals 
D)  combines a column and line chart to compare data requiring different scales of measure

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

As shown in the figure above, item 7 represents ____.

Accepted Answer

A)  data markers 
B)  tick marks 
C)  the plot area 
D)  the legend 
A)  data markers 
B)  tick marks 
C)  the plot area 
D)  the legend

Question 11

The arrows shown in the figure above point to ____.

Accepted Answer

A)  data markers 
B)  I-beams 
C)  legends 
D)  sizing handles 
A)  data markers 
B)  I-beams 
C)  legends 
D)  sizing handles

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  x-axis 
B)  y-axis 
C)  data marker 
D)  legend 
A)  x-axis 
B)  y-axis 
C)  data marker 
D)  legend

Question 14

As shown in the figure above, item ____ represents the horizontal axis.

Accepted Answer

A)  2 
B)  3 
C)  6 
D)  7 
A)  2 
B)  3 
C)  6 
D)  7

Question 15

As shown in the figure above, item ____ represents a data point.

Accepted Answer

A)  1 
B)  3 
C)  4 
D)  7 
A)  1 
B)  3 
C)  4 
D)  7

Question 16

You can use buttons on the Insert tab of the Ribbon to create and modify a chart.

Accepted Answer

A) True 
 B)False

Question 17

The z-axis of 3-D charts is used for comparing data across both categories and values.

Accepted Answer

A) True 
 B)False

Question 18

Sub gridlines show the values between the tick marks.

Accepted Answer

A) True 
 B)False

Question 19

You are having trouble keeping track of your personal spending and you decide to create a worksheet and a chart to help you better understand and plan for your personal expenses. The worksheet and chart are shown below.   You want to explain Other Expenses a little more in the chart by using a text annotation. Write the procedure for adding a text box with the text Ex - gym fees, health insurance to the chart.

Accepted Answer

Make sure the chart is selected, click t

Question 20

As shown in the figure above, item ____ represents the vertical axis.

Accepted Answer

A)  1 
B)  3 
C)  6 
D)  7 
A)  1 
B)  3 
C)  6 
D)  7

Exam 18: Excel 2007 Unit D: Working With Charts

A collection of related data points is called a ____.

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

As shown in the figure above, item 2 points to ____________________.

WordArt, which lets you create curved or stylized text, can be created using the Chart Tools Format tab.

Each value in a cell selected for a chart is called a ____.

You can modify the data range and configuration of a chart in the ____ group of the Chart Tools Design tab.

A scatter chart ____.

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

As shown in the figure above, item 7 represents ____.

The arrows shown in the figure above point to ____.

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

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

As shown in the figure above, item ____ represents the horizontal axis.

As shown in the figure above, item ____ represents a data point.

You can use buttons on the Insert tab of the Ribbon to create and modify a chart.

The z-axis of 3-D charts is used for comparing data across both categories and values.

Sub gridlines show the values between the tick marks.

As shown in the figure above, item ____ represents the vertical axis.

Word 2007 Unit A: Creating Documents With Word 2007

Word 2007 Unit B: Editing Documents

Word 2007 Unit C: Formatting Text and Paragraphs

Word 2007 Unit D: Formatting Documents

Outlook 2007 Unit A: Getting Started With E-Mail

Outlook 2007 Unit B: Managing Information Using Outlook

Powerpoint 2007 Unit A: Creating a Presentation in Powerpoint 2007

Powerpoint 2007 Unit B: Modifying a Presentation

Powerpoint 2007 Unit C: Inserting Objects Into a Presentation

Powerpoint 2007 Unit D: Finishing a Presentation

Access 2007 Unit A: Getting Started With Access 2007

Access 2007 Unit B: Building and Using Queries

Access 2007 Unit C: Using Forms

Access 2007 Unit D: Using Reports

Excel 2007 Unit A: Getting Started With Excel 2007

Excel 2007 Unit B: Working With Formulas and Functions

Excel 2007 Unit C: Formatting a Worksheet

Concepts Unit A: Understanding Essential Computer Concepts

Office 2007 Unit A: Getting Started With Microsoft Office 2007

Windows Vista Unit A: Getting Started With Windows Vista

Windows Vista Unit B: Understanding File Management

Windows Xp Unit A: Getting Started With Windows Xp

Windows Xp Unit B: Understanding File Management

Integration Unit A: Integrating Word and Excel

Integration Unit B: Integrating Word, Excel, and Access

Integration Unit C: Integrating Word, Excel, Access, and Powerpoint

Internet Unit A: Getting Started With Internet Explorer 7

Filters