Question 1

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 clustered column chart is a type of column chart where multiple columns are grouped together side by side, so the best choice for X is the 'Column' type.

Question 2

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 3

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 4

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. The other options may be confusing or may not even exist depending on the software being used.

Question 5

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 correct path is Sparkline chart > Design > Show > Markers check box. The "Line" option is not part of the path to add markers.

Question 6

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

X refers to the Number option in the Axis Options, which allows you to select the desired number format for the chart axis labels.

Question 7

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

To insert a 3-D pie chart, we need to select the "Insert Pie or Doughnut Chart" option in the given series of clicks.

Question 8

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

Axis titles are typically not applicable to pie charts because pie charts do not have a traditional x-axis and y-axis to label. They display data in a circular format, with slices representing parts of the whole, and thus do not use axes in the same way that line, area, and column charts do.

Question 9

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 Data Callout option adds data labels inside a text bubble shape, which satisfies Bertie's requirement. The other options (Best Fit, Inside End, and Outside End) do not provide the text bubble shape that Bertie wants.

Question 10

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

Marianna should select "Fill & Line" as X to access the options for customizing the border of the legend.

Question 11

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

To explode a pie chart slice, you need to click the chart, double-click the slice you want to explode, and drag it away from the center of the chart. Option D is the correct answer. Option A is incorrect because it allows you to change the percentage, not explode the slice. Option B and C refer to different types of pie charts and are not relevant to exploding a slice.

Question 12

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 for inserting a column sparkline in Excel.

Question 13

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 procedure to create an X-Y scatter plot in Microsoft Excel.

Question 14

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 to insert a Win/Loss sparkline in Excel.

Question 15

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

Accepted Answer

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

Question 16

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 17

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 18

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 19

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 given instruction correctly describes how to edit placeholder text in a chart element using the Data Validation feature in Microsoft Excel.

Question 20

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...

Quiz 4: Analyzing and Charting Financial Data

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/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.

How can you remove data labels from a chart?

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.

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?

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 which of the following chart types can you not add axis titles?

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?

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

What will you do to explode a pie chart slice?