Question 1

When adding ________ elements to a chart, make sure they enhance the effectiveness of the chart instead of overpowering it.

Accepted Answer

The answer of When adding ________ elements to a chart,...

Question 2

The Chart Layouts group enables you to apply ________ layouts to a chart.

Accepted Answer

The answer of The Chart Layouts group enables you to...

Question 3

The default chart sheet name is sheett1, sheet2, etc.

Accepted Answer

A) True 
 B)False

Question 4

A multiple data series chart

Accepted Answer

A)  groups or clusters similar data in columns to compare values across categories. 
B)  compares two or more sets of data in one chart. 
C)  is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart. 
D)  places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color. 
A)  groups or clusters similar data in columns to compare values across categories. 
B)  compares two or more sets of data in one chart. 
C)  is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart. 
D)  places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.

Question 5

Just like for printing any worksheet data, preview the chart in Backstage view before you print to check margins, spacing, and page breaks to ensure a balanced printout.

Accepted Answer

A) True 
 B)False

Question 6

The Chart Tools Design ________ tab contains options to modify the overall chart design.

Accepted Answer

The answer of The Chart Tools Design ________ tab contains...

Question 7

Chapter 3 Customize, Analyze, and Summarize Query Data

Accepted Answer

A)  is a group of related data points. 
B)  is a visual representation of numerical data. 
C)  is a numeric value that describes a single value on a chart. 
D)  is text that describes a collection of data points in a chart. 
A)  is a group of related data points. 
B)  is a visual representation of numerical data. 
C)  is a numeric value that describes a single value on a chart. 
D)  is text that describes a collection of data points in a chart.

Question 8

A stock chart

Accepted Answer

A)  shows relationships among three values by using bubbles. 
B)  shows values as percentages of the whole but may contain more than one data series. 
C)  displays trends using two dimensions on a continuous curve. 
D)  can show the open, high, low, and close prices for individual stocks over time. 
A)  shows relationships among three values by using bubbles. 
B)  shows values as percentages of the whole but may contain more than one data series. 
C)  displays trends using two dimensions on a continuous curve. 
D)  can show the open, high, low, and close prices for individual stocks over time.

Question 9

A category label

Accepted Answer

A)  contains the entire chart and all of its elements. 
B)  is text that describes a collection of data points in a chart. 
C)  displays data comparisons vertically in columns. 
D)  contains graphical representation of values in data series. 
A)  contains the entire chart and all of its elements. 
B)  is text that describes a collection of data points in a chart. 
C)  displays data comparisons vertically in columns. 
D)  contains graphical representation of values in data series.

Question 10

Labels on charts are not necessary because you can always tell what the chart means by the colors.

Accepted Answer

A) True 
 B)False

Question 11

An axis title

Accepted Answer

A)  is a line used to depict trends and forecast future data. 
B)  is the value or name of a data point. 
C)  is a label that describes either the category axis or the value axis. 
D)  is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area. 
A)  is a line used to depict trends and forecast future data. 
B)  is the value or name of a data point. 
C)  is a label that describes either the category axis or the value axis. 
D)  is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.

Question 12

The category axis

Accepted Answer

A)  compares two or more sets of data in one chart. 
B)  compares values for one set of data. 
C)  displays descriptive group names or labels, such as college names or cities, to identify data. 
D)  displays incremental values to identify the values of the data series. 
A)  compares two or more sets of data in one chart. 
B)  compares values for one set of data. 
C)  displays descriptive group names or labels, such as college names or cities, to identify data. 
D)  displays incremental values to identify the values of the data series.

Question 13

A single data series

Accepted Answer

A)  compares values for one set of data. 
B)  groups or clusters similar data in columns to compare values across categories. 
C)  is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart. 
D)  compares two or more sets of data in one chart. 
A)  compares values for one set of data. 
B)  groups or clusters similar data in columns to compare values across categories. 
C)  is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart. 
D)  compares two or more sets of data in one chart.

Question 14

Creating a chart involves selecting the data ________ and choosing the chart type.

Accepted Answer

The answer of Creating a chart involves selecting the data...

Question 15

When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs:

Accepted Answer

A)  Design, Layout, and Format 
B)  Home, Insert, and Page Layout 
C)  Chart, Type, and Formulas 
D)  Data, Review, and Data 
A)  Design, Layout, and Format 
B)  Home, Insert, and Page Layout 
C)  Chart, Type, and Formulas 
D)  Data, Review, and Data

Question 16

After you insert a sparkline, the Sparkline Tools Design contextual tab displays, with options to ________ the sparkline.

Accepted Answer

The answer of After you insert a sparkline, the Sparkline...

Question 17

For less formal presentations, you might want to demonstrate your creativity by using images or a texture to fill the data series, chart area, or plot area instead of a solid fill color.

Accepted Answer

A) True 
 B)False

Question 18

A chart sheet

Accepted Answer

A)  is a label that describes the chart. 
B)  enables you to adjust the size of the chart. 
C)  contains a single chart and no spreadsheet data. 
D)  is a miniature chart contained in a single cell. 
A)  is a label that describes the chart. 
B)  enables you to adjust the size of the chart. 
C)  contains a single chart and no spreadsheet data. 
D)  is a miniature chart contained in a single cell.

Question 19

Excel displays the row labels in the first column on the ________ axis.

Accepted Answer

The answer of Excel displays the row labels in the...

Question 20

Excel creates charts on the same worksheet as the original data set, but you can ________ the chart to its own chart sheet.

Accepted Answer

The answer of Excel creates charts on the same worksheet...

When adding ________ elements to a chart, make sure they enhance the effectiveness of the chart instead of overpowering it.

The Chart Layouts group enables you to apply ________ layouts to a chart.

The default chart sheet name is sheett1, sheet2, etc.

A multiple data series chart

Just like for printing any worksheet data, preview the chart in Backstage view before you print to check margins, spacing, and page breaks to ensure a balanced printout.

The Chart Tools Design ________ tab contains options to modify the overall chart design.

Chapter 3 Customize, Analyze, and Summarize Query Data

A stock chart

A category label

Labels on charts are not necessary because you can always tell what the chart means by the colors.

An axis title

The category axis

A single data series

Creating a chart involves selecting the data ________ and choosing the chart type.

When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs:

After you insert a sparkline, the Sparkline Tools Design contextual tab displays, with options to ________ the sparkline.

For less formal presentations, you might want to demonstrate your creativity by using images or a texture to fill the data series, chart area, or plot area instead of a solid fill color.

A chart sheet

Excel displays the row labels in the first column on the ________ axis.

Excel creates charts on the same worksheet as the original data set, but you can ________ the chart to its own chart sheet.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters

Exam 13: Excel: Customize, Analyze, and Summarize Query Data

When adding ________ elements to a chart, make sure they enhance the effectiveness of the chart instead of overpowering it.

The Chart Layouts group enables you to apply ________ layouts to a chart.

The default chart sheet name is sheett1, sheet2, etc.

A multiple data series chart

Just like for printing any worksheet data, preview the chart in Backstage view before you print to check margins, spacing, and page breaks to ensure a balanced printout.

The Chart Tools Design ________ tab contains options to modify the overall chart design.

Chapter 3 Customize, Analyze, and Summarize Query Data

A stock chart

A category label

Labels on charts are not necessary because you can always tell what the chart means by the colors.

An axis title

The category axis

A single data series

Creating a chart involves selecting the data ________ and choosing the chart type.

When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs:

After you insert a sparkline, the Sparkline Tools Design contextual tab displays, with options to ________ the sparkline.

For less formal presentations, you might want to demonstrate your creativity by using images or a texture to fill the data series, chart area, or plot area instead of a solid fill color.

A chart sheet

Excel displays the row labels in the first column on the ________ axis.

Excel creates charts on the same worksheet as the original data set, but you can ________ the chart to its own chart sheet.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters