Question 1

What is a sparkline? Explain how a sparkline can be inserted and its use. ​

Accepted Answer

The answer of What is a sparkline? Explain how a...

Question 2

A(n) _________ is a fusion of two or more chart types in a single graph, such as a column chart and a line chart. ​ 
A)treemap chart 
B)area chart 
C)combo chart 
D)sunburst chart

Accepted Answer

The answer of A(n) _________ is a fusion of two...

Question 3

A _________ is the type of chart on Microsoft Excel that does not include chart elements such as legends, titles, gridlines, or axes. ​ 
A)sparkline 
B)gridline 
C)timeline 
D)streamline

Accepted Answer

The answer of A _________ is the type of chart...

Question 4

In a Microsoft Excel worksheet, a(n) _________ is a chart that is an object in a worksheet. ​ 
A)place value chart 
B)embedded chart 
C)album chart 
D)size chart

Accepted Answer

The answer of In a Microsoft Excel worksheet, a(n) _________...

Question 5

What is a data bar? Describe its features. ​

Accepted Answer

The answer of What is a data bar? Describe its...

Question 6

The _________ shows the patterns or relationship between two or more sets of values. ​ 
A)Box & Whisker Chart 
B)Sunburst Chart 
C)X Y (Scatter) Chart 
D)Surface Chart

Accepted Answer

The answer of The _________ shows the patterns or relationship...

Question 7

Explain how to edit a chart data and add a data series to an existing chart. ​

Accepted Answer

The answer of Explain how to edit a chart data...

Question 8

The _________ tab provides a gallery of column chart layouts and a gallery of column chart styles and access to the individual chart elements you can include on a column chart. ​ 
A)Chart Tools Design 
B)Chart Tools Format 
C)Chart Tools Data 
D)Chart Tools View

Accepted Answer

The answer of The _________ tab provides a gallery of...

Question 9

In Microsoft Excel Charts, _________ are individual parts of a chart such as the chart area, the chart title, the plot area, data markers, and a legend. ​ 
A)chart sectors 
B)chart elements 
C)chart metrics 
D)chart plotters

Accepted Answer

The answer of In Microsoft Excel Charts, _________ are individual...

Question 10

The _________ button is used to create data bars. ​ 
A)What-If Analysis 
B)Conditional Formatting 
C)Data Validation 
D)Forecast Sheet

Accepted Answer

The answer of The _________ button is used to create...

Question 11

If you select a chart's sequence, the formula displayed in the formula bar uses the _________ function. ​ 
A)SERIES 
B)QUARTILE 
C)LOOKUP 
D)AREAS

Accepted Answer

The answer of If you select a chart's sequence, the...

Question 12

In Microsoft Excel, a(n) _________ is a page in a workbook that contains only a graph and no worksheet cells. ​ 
A)optical mark recognition sheet 
B)perspex sheet 
C)data sheet 
D)chart sheet

Accepted Answer

The answer of In Microsoft Excel, a(n) _________ is a...

Question 13

The _________ button next to the selected chart displays a list of the data series and category values used in the chart . ​ 
A)Chart Elements 
B)Chart Styles 
C)Chart Filters 
D)Chart Layouts

Accepted Answer

The answer of The _________ button next to the selected...

Question 14

A _________ is a horizontal bar that is always placed in the cell containing the value it represents. ​ 
A)space bar 
B)data bar 
C)taskbar 
D)toolbar

Accepted Answer

The answer of A _________ is a horizontal bar that...

Quiz 16: Inserting and Formatting Charts

What is a sparkline? Explain how a sparkline can be inserted and its use.

A(n) _________ is a fusion of two or more chart types in a single graph, such as a column chart and a line chart. A)treemap chart B)area chart C)combo chart D)sunburst chart

A _________ is the type of chart on Microsoft Excel that does not include chart elements such as legends, titles, gridlines, or axes. A)sparkline B)gridline C)timeline D)streamline

In a Microsoft Excel worksheet, a(n) _________ is a chart that is an object in a worksheet. A)place value chart B)embedded chart C)album chart D)size chart

What is a data bar? Describe its features.

The _________ shows the patterns or relationship between two or more sets of values. A)Box & Whisker Chart B)Sunburst Chart C)X Y (Scatter) Chart D)Surface Chart

Explain how to edit a chart data and add a data series to an existing chart.

The _________ tab provides a gallery of column chart layouts and a gallery of column chart styles and access to the individual chart elements you can include on a column chart. A)Chart Tools Design B)Chart Tools Format C)Chart Tools Data D)Chart Tools View

In Microsoft Excel Charts, _________ are individual parts of a chart such as the chart area, the chart title, the plot area, data markers, and a legend. A)chart sectors B)chart elements C)chart metrics D)chart plotters

The _________ button is used to create data bars. A)What-If Analysis B)Conditional Formatting C)Data Validation D)Forecast Sheet

If you select a chart's sequence, the formula displayed in the formula bar uses the _________ function. A)SERIES B)QUARTILE C)LOOKUP D)AREAS

In Microsoft Excel, a(n) _________ is a page in a workbook that contains only a graph and no worksheet cells. A)optical mark recognition sheet B)perspex sheet C)data sheet D)chart sheet

The _________ button next to the selected chart displays a list of the data series and category values used in the chart . A)Chart Elements B)Chart Styles C)Chart Filters D)Chart Layouts

A _________ is a horizontal bar that is always placed in the cell containing the value it represents. A)space bar B)data bar C)taskbar D)toolbar

Quiz 16: Inserting and Formatting Charts

What is a sparkline? Explain how a sparkline can be inserted and its use. ​

A(n) _________ is a fusion of two or more chart types in a single graph, such as a column chart and a line chart. ​ A)treemap chart B)area chart C)combo chart D)sunburst chart

A _________ is the type of chart on Microsoft Excel that does not include chart elements such as legends, titles, gridlines, or axes. ​ A)sparkline B)gridline C)timeline D)streamline

In a Microsoft Excel worksheet, a(n) _________ is a chart that is an object in a worksheet. ​ A)place value chart B)embedded chart C)album chart D)size chart

What is a data bar? Describe its features. ​

The _________ shows the patterns or relationship between two or more sets of values. ​ A)Box & Whisker Chart B)Sunburst Chart C)X Y (Scatter) Chart D)Surface Chart

Explain how to edit a chart data and add a data series to an existing chart. ​

The _________ tab provides a gallery of column chart layouts and a gallery of column chart styles and access to the individual chart elements you can include on a column chart. ​ A)Chart Tools Design B)Chart Tools Format C)Chart Tools Data D)Chart Tools View

In Microsoft Excel Charts, _________ are individual parts of a chart such as the chart area, the chart title, the plot area, data markers, and a legend. ​ A)chart sectors B)chart elements C)chart metrics D)chart plotters

The _________ button is used to create data bars. ​ A)What-If Analysis B)Conditional Formatting C)Data Validation D)Forecast Sheet

If you select a chart's sequence, the formula displayed in the formula bar uses the _________ function. ​ A)SERIES B)QUARTILE C)LOOKUP D)AREAS

In Microsoft Excel, a(n) _________ is a page in a workbook that contains only a graph and no worksheet cells. ​ A)optical mark recognition sheet B)perspex sheet C)data sheet D)chart sheet

The _________ button next to the selected chart displays a list of the data series and category values used in the chart . ​ A)Chart Elements B)Chart Styles C)Chart Filters D)Chart Layouts

A _________ is a horizontal bar that is always placed in the cell containing the value it represents. ​ A)space bar B)data bar C)taskbar D)toolbar