Question 1

Which of the following will you select as X in the given series of clicks to insert a 3-D pie chart: Insert > Charts group > X > 3-D Pie?
A) Insert Column Chart
B) Insert Combo Chart
C) Insert Pie or Doughnut Chart
D) Insert Stock, Surface or Radar Chart

Accepted Answer

The option "Insert Pie or Doughnut Chart" is the best choice as it specifically mentions "Pie" which matches with the required 3-D pie chart. The other options like "Insert Column Chart", "Insert Combo Chart", and "Insert Stock, Surface, or Radar Chart" do not match with the required chart type.

Question 2

To move a chart to another location on the sane worksheet, drag it to the location you want.

Accepted Answer

This is correct, you can simply click and drag the chart to the location you want on the same worksheet.

Question 3

Jack wants to insert a Win/Loss sparkline in Excel. To do this, he can click on the cell he wants to insert a Sparkline in, then click Apps tab, select Win/Loss Sparkline from the Sparklines group and then click OK.

Accepted Answer

This is the correct process for inserting a Win/Loss Sparkline in Excel.

Question 4

Bart needs to apply a sparkline style to a sparkline chart. To do so, he can click on the following: Sparkline chart > Design > Style (choose a style).

Accepted Answer

The answer of Bart needs to apply a sparkline style...

Question 5

Bertie wants to show data labels inside a text bubble shape. Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?
A) Best Fit
B) Inside End
C) Outside End
D) Data Callout

Accepted Answer

The option for showing data labels inside a text bubble shape is Data Callout. This will display the label within a text bubble that points to the data point on the chart. The other options (Best Fit, Inside End, Outside End) are more suitable for other chart types or label placement.

Question 6

How can you remove data labels from a chart?
A) Uncheck the box beside Data Labels in Chart Elements.
B) Click on Remove on the options on the right side of Data Labels.
C) Click on Delete on the options on the right side of Data Labels.
D) Click to select the Data labels, then click on Edit and then Delete.

Accepted Answer

Unchecking the box beside Data Labels in Chart Elements is the easiest and most straightforward way to remove data labels from a chart.

Question 7

To edit placeholder text in a chart element, select the cell whose placeholder text you want to edit, on Ribbon, click Data > Data Validation > Data Validation > Input Message tab and edit the text in the box.

Accepted Answer

The answer of To edit placeholder text in a chart...

Question 8

Which of the following should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart Tools > Design tab > Type group > Change Chart Type > All Charts > X > Clustered Column > OK?
A) Pie
B) Bar
C) Line
D) Column

Accepted Answer

The question asks to change the chart type to a clustered column chart. The options given are Pie, Bar, Line, and Column. Out of these, the correct option for a clustered column chart is D) Column.

Question 9

Which of the following will you select as X in the following series of clicks to change the chart layout for lines or bars that you want to change: Chart > Chart Tools > Layout tab > X > Layout option for any lines or bars that you want to add or change?
A) Axes
B) Labels
C) Analysis
D) Background

Accepted Answer

The answer of Which of the following will you select...

Question 10

To which of the following chart types can you not add axis titles?
A) Pie chart
B) Line chart
C) Area chart
D) Column chart

Accepted Answer

Pie charts do not have separate x and y axes, therefore there are no axis titles to add.

Question 11

A students wants to insert a column sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select the Sparkline type of choice from the Sparklines group and then select OK.

Accepted Answer

This is the correct process to insert a column sparkline in Excel.

Question 12

Penina wants to insert markers into a sparkline chart. To do so, she can click on the following: Sparkline chart > Design > Line > Markers check box.

Accepted Answer

The answer of Penina wants to insert markers into a...

Question 13

What will you do to explode a pie chart slice?
A) Right-click the pie chart, click on Format Data Series, then enter a number in the percentage box.
B) Right-click the pie-chart, then click Change Series Chart Type, click Pie, and then click Pie of Pie.
C) Right-click the pie-chart, then click Change Series Chart Type, click Pie, and then click Bar of Pie.
D) Click the pie chart, then double-click the slice you want to explode, and drag it away from the center of the chart.

Accepted Answer

Clicking and dragging a slice away from the center of the chart is the simplest and most direct way to explode a pie chart slice. This option is available without the need for any additional configuration options or changing the chart type.

Question 14

Which of the following will you select as X in the following series of clicks/entries to change the number format of data labels in a chart: (Double-click) Data labels > Format Data Labels > X > Number > Select choice in Category Box?
A) Label Options
B) Text Options
C) Chart Options
D) Series Options

Accepted Answer

When you double-click on data labels in a chart, the "Format Data Labels" window opens. Under this window, you can select various formatting options. The option "Number" allows you to change the number format of the data labels. The dropdown box under "Number" has various categories like "General", "Number", "Currency", etc. to choose from. Therefore, the correct choice is Label Options.

Question 15

Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK.

Accepted Answer

This is the correct process to insert a Line Sparkline in Excel.

Question 16

Which of the following will you select as X in the following series of clicks to lay the title over a chart: Chart Title box > Plus (+) sign > Arrow next to Chart title > X?
A) Above Chart
B) Over Chart
C) Below Chart
D) Below Chart.

Accepted Answer

The answer of Which of the following will you select...

Question 17

Which of the following will you select as X in the following series of clicks/entries to change the number format of a chart axis: (Double-click) Value Axis labels > Format Axis > Axis Options > X > Select choice in Category box?
A) Labels
B) Number
C) Tick Marks
D) Text Options

Accepted Answer

To change the number format of a chart axis, we need to select the "Number" option in the Axis Options. The "Labels" option is for editing the axis labels, the "Tick Marks" option is for formatting the tick marks on the axis, and the "Text Options" is for formatting the text style of the axis. Therefore, the best choice is B.

Question 18

Marianna wants to add a border to a legend. Which of the following should she select as X in the following series of clicks to do so? Legend > (right click) Format legend > Legend Options > X > Border > Solid Line
A) Effects
B) Text Options
C) Fill & Line
D) Legend Options

Accepted Answer

The option for border is found under Fill & Line, so Marianna should select "Fill & Line" as X.

Question 19

Arrow keys can be used to move any chart element.

Accepted Answer

Arrow keys can be used to move any chart element in most charting programs, including Microsoft Excel and Google Sheets.

Question 20

Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

Accepted Answer

This is the correct process for creating an X-Y scatter plot in Excel.

Quiz 4: Analyzing and Charting Financial Data

Which of the following will you select as X in the given series of clicks to insert a 3-D pie chart: Insert > Charts group > X > 3-D Pie?

To move a chart to another location on the sane worksheet, drag it to the location you want.

Jack wants to insert a Win/Loss sparkline in Excel. To do this, he can click on the cell he wants to insert a Sparkline in, then click Apps tab, select Win/Loss Sparkline from the Sparklines group and then click OK.

Bart needs to apply a sparkline style to a sparkline chart. To do so, he can click on the following: Sparkline chart > Design > Style (choose a style).

Bertie wants to show data labels inside a text bubble shape. Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?

How can you remove data labels from a chart?

To edit placeholder text in a chart element, select the cell whose placeholder text you want to edit, on Ribbon, click Data > Data Validation > Data Validation > Input Message tab and edit the text in the box.

Which of the following should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart Tools > Design tab > Type group > Change Chart Type > All Charts > X > Clustered Column > OK?

Which of the following will you select as X in the following series of clicks to change the chart layout for lines or bars that you want to change: Chart > Chart Tools > Layout tab > X > Layout option for any lines or bars that you want to add or change?

To which of the following chart types can you not add axis titles?

A students wants to insert a column sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select the Sparkline type of choice from the Sparklines group and then select OK.

Penina wants to insert markers into a sparkline chart. To do so, she can click on the following: Sparkline chart > Design > Line > Markers check box.

What will you do to explode a pie chart slice?

Which of the following will you select as X in the following series of clicks/entries to change the number format of data labels in a chart: (Double-click) Data labels > Format Data Labels > X > Number > Select choice in Category Box?

Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK.

Which of the following will you select as X in the following series of clicks to lay the title over a chart: Chart Title box > Plus (+) sign > Arrow next to Chart title > X?

Which of the following will you select as X in the following series of clicks/entries to change the number format of a chart axis: (Double-click) Value Axis labels > Format Axis > Axis Options > X > Select choice in Category box?

Marianna wants to add a border to a legend. Which of the following should she select as X in the following series of clicks to do so? Legend > (right click) Format legend > Legend Options > X > Border > Solid Line

Arrow keys can be used to move any chart element.

Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.