Question 1

Which of the following is not an option that the Data Labels can produce?

Accepted Answer

A)  series name 
B)  category name 
C)  value of the data point 
D)  legend name 
A)  series name 
B)  category name 
C)  value of the data point 
D)  legend name D

Question 2

Acombo  chart can add a(n) ____ axis to chart related data.

Accepted Answer

A)  combo 
B)  secondary 
C)  tertiary 
D)  clustered 
A)  combo 
B)  secondary 
C)  tertiary 
D)  clustered B

Question 3

Which one of the following is NOT one of the new chart types in Excel 2016?​

Accepted Answer

A)  ​Treemap 
B)  ​Waterfall 
C)  ​Sunburst 
D)  ​Surface 
A)  ​Treemap 
B)  ​Waterfall 
C)  ​Sunburst 
D)  ​Surface D

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. You decide to annotate the chart using a callout. What button do you click to do this?

Accepted Answer

A)  the Callout button in the Annotations group on the Insert tab 
B)  the Notes button in the Annotations group on the Insert  tab 
C)  the Shapes button in the Annotations group on the Insert  tab 
D)  the Shapes button in the Illustrations group on the Insert  tab 
A)  the Callout button in the Annotations group on the Insert tab 
B)  the Notes button in the Annotations group on the Insert  tab 
C)  the Shapes button in the Annotations group on the Insert  tab 
D)  the Shapes button in the Illustrations group on the Insert  tab

Question 6

On a chart created in Excel, the horizontal axis is also 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 7

The default border color around a chart title is ____.

Accepted Answer

A)  red 
B)  green 
C)  black 
D)  blue 
A)  red 
B)  green 
C)  black 
D)  blue

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

The area inside the horizontal and vertical axes is the legend . _________________________

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: Often contains the names of data groups, such as locations, months, or years.

Accepted Answer

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

Question 11

Which chart type is the best candidate for spotting trends and extrapolating information based on research data?

Accepted Answer

A)  pie 
B)  area 
C)  scatter 
D)  hi-low 
A)  pie 
B)  area 
C)  scatter 
D)  hi-low

Question 12

You can quickly create a miniature chart called a(n) ____________________ that serves as a visual indicator of data trends directly within a cell.

Accepted Answer

The answer of You can quickly create a miniature chart...

Question 13

Tick marks appear on the horizontal axis of a chart. ____________________​

Accepted Answer

A) True 
 B)False

Question 14

To show how individual volume changes over time in relation to total volume, use a(n) ____.

Accepted Answer

A)  area chart 
B)  bar chart 
C)  column chart 
D)  line chart 
A)  area chart 
B)  bar chart 
C)  column chart 
D)  line chart

Question 15

____ marks indicate the scale of measure for each value on the y-axis.

Accepted Answer

A)  Datapoint 
B)  Tick 
C)  Axis 
D)  Legend 
A)  Datapoint 
B)  Tick 
C)  Axis 
D)  Legend

Question 16

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.

Accepted Answer

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

Question 17

You can print a chart by itself or as part of the worksheet.

Accepted Answer

A) True 
 B)False

Question 18

Match between columns
                        Premises: Often contains numerical values that help you interpret the size of chart elements.

Accepted Answer

The Answer of value axis and category axis and chart is...

Question 19

The chart's ____________________ handles, the small series of dots at the corners and sides of the chart's border, indicate that the chart is selected.

Accepted Answer

The answer of The chart's ____________________ handles, the small series...

Question 20

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. You want to preview just the chart before you print the chart sheet. What command do you use?

Accepted Answer

A)  Preview on the Print tab 
B)  Print on the File tab 
C)  Sneak Peek on the Print tab 
D)  Display on the File tab 
A)  Preview on the Print tab 
B)  Print on the File tab 
C)  Sneak Peek on the Print tab 
D)  Display on the File tab

Exam 9: Excel 4: Working With Charts

Which of the following is not an option that the Data Labels can produce?

Acombo chart can add a(n) ____ axis to chart related data.

Which one of the following is NOT one of the new chart types in Excel 2016?​

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

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

The default border color around a chart title is ____.

A scatter chart ____.

The area inside the horizontal and vertical axes is the legend . _________________________

Which chart type is the best candidate for spotting trends and extrapolating information based on research data?

You can quickly create a miniature chart called a(n) ____________________ that serves as a visual indicator of data trends directly within a cell.

Tick marks appear on the horizontal axis of a chart. ____________________​

To show how individual volume changes over time in relation to total volume, use a(n) ____.

____ marks indicate the scale of measure for each value on the y-axis.

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.

You can print a chart by itself or as part of the worksheet.

The chart's ____________________ handles, the small series of dots at the corners and sides of the chart's border, indicate that the chart is selected.

Access 1: Getting Started With Access

Access 2: Building and Using Queries

Access 3: Using Forms

Access 4: Using Reports

Essential: Understanding Essential Computer Concepts

Excel 1: Getting Started With Excel 2016

Excel 2: Working With Formulas and Functions

Excel 3: Formatting a Worksheet

Integration 1: Integrating Word and Excel

Integration 2: Integrating Word Excel and Access

Integration 3: Integrating Word Excel Access and Powerpoint

Office: Getting Started With Office 2016

Outlook 1: Getting Started With Email

Outlook 2: Managing Information Using Outlook

Powerpoint 1: Creating a Presentation in Powerpoint 2016

Powerpoint 2: Modifying a Presentation

Powerpoint 3: Inserting Objects Into a Presentation

Powerpoint 4: Finishing a Presentation

Windows 1: Getting Started With Windows 10

Windows 2: Understanding File Management

Word 1: Creating Documents With Word 2016

Word 2: Editing Documents

Word 3: Formatting Text and Paragraphs

Word 4: Formatting Documents

Filters

Which one of the following is NOT one of the new chart types in Excel 2016?

Tick marks appear on the horizontal axis of a chart. ____________________