Question 1

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?

Accepted Answer

A)   Best Fit
B)   Inside End
C)   Outside End
D)   Data Callout D

Question 2

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?

Accepted Answer

A)   Pie
B)   Bar
C)   Line
D)   Column D

Question 3

Rainn wants to switch rows to column in his chart.To do so,he can click on the following series: chart with data series that he wants to plot on different axes > Chart Tools > Design tab > Data group > Switch Row/Column.

Accepted Answer

A) True 
 B)False  True

Question 4

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

A) True 
 B)False

Question 5

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

Accepted Answer

A)   Insert Column Chart
B)   Insert Combo Chart
C)   Insert Pie or Doughnut Chart
D)   Insert Stock,Surface or Radar Chart

Question 6

How can you remove data labels from a chart?

Accepted Answer

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.

Question 7

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?

Accepted Answer

A)   Above Chart
B)   Over Chart
C)   Below Chart.
D)  Below Chart

Question 8

Saul wants to add a legend to a chart.On which of the following boxes should he click in Chart Elements after selecting the chart and then the + sign?

Accepted Answer

A)   Color
B)   Legend
C)   Chart Titles
D)   Data labels

Question 9

What will you select as X and Y in the following series of clicks/entries to insert a Clustered Column - Line Combination chart: Range of cells > Insert tab > Charts group > Insert Combo Chart symbol > Create Custom Combo Chart > Insert Chart dialog box > All Charts > Series 1 > X (Chart type)> Series 2 > Y (Chart type)> OK?

Accepted Answer

A)   X - Scatter,Y - Stacked Bar
B)   X - Clustered Column,Y - Line
C)   X - Radar with Markers,Y - Area
D)   X- Clustered Bar,Y- Stacked Line

Question 10

Which of the following will you select as X in the following series of clicks to add a data table to a chart: Data Chart > Chart Tools > X > Data table > (Select check box)Show Data table?

Accepted Answer

A)   Layout
B)   Design
C)   Format
D)   Kutools

Question 11

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

A) True 
 B)False

Question 12

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

A) True 
 B)False

Question 13

To switch chart rows and columns,we can click anywhere in the chart containing the data series that we want to plot on different axes,click on the Design tab in Chart Tools,then in the Data group,and finally click Switch Row/Column.

Accepted Answer

A) True 
 B)False

Question 14

If you see a cells with blue fills of varying lengths representing the values,the cells most likely have ________ applied to them.

Accepted Answer

A)   themes
B)   icon sets
C)   data bars
D)   cell styles

Question 15

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?

Accepted Answer

A)   Labels
B)   Number
C)   Tick Marks
D)   Text Options

Question 16

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

Accepted Answer

A)   Effects
B)   Text Options
C)   Fill & Line
D)   Legend Options

Question 17

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?

Accepted Answer

A)   Label Options
B)   Text Options
C)   Chart Options
D)   Series Options

Question 18

Which of the following will you select as X in the following series of clicks/entries to insert a chart using the Quick Analysis tool: Range of cells > X > Charts > Select Chart Type you want?

Accepted Answer

A)   Ctrl + W
B)   Ctrl + R
C)   Ctrl + Z
D)   Ctrl + Q

Question 19

What will you select as X in the following series of clicks to insert a Recommended chart: Range of cells > X > Charts group > Recommended Charts > Clustered Column > OK?

Accepted Answer

A)   Data tab
B)   View tab
C)   Insert tab
D)   Page Layout tab

Question 20

Ngabile wants to insert a Treemap chart for a data set.To do so,she can click on the following series: Range of cells > Page Layout tab > Apps group > Insert Hierarchy Chart > Treemap.

Accepted Answer

A) True 
 B)False

Exam 4: Analyzing and Charting Financial Data

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?

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?

Rainn wants to switch rows to column in his chart.To do so,he can click on the following series: chart with data series that he wants to plot on different axes > Chart Tools > Design tab > Data group > Switch Row/Column.

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 given series of clicks to insert a pie chart: Insert > Charts group > X >?

How can you remove data labels from a chart?

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?

Saul wants to add a legend to a chart.On which of the following boxes should he click in Chart Elements after selecting the chart and then the + sign?

Which of the following will you select as X in the following series of clicks to add a data table to a chart: Data Chart > Chart Tools > X > Data table > (Select check box) Show Data table?

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.

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.

To switch chart rows and columns,we can click anywhere in the chart containing the data series that we want to plot on different axes,click on the Design tab in Chart Tools,then in the Data group,and finally click Switch Row/Column.

If you see a cells with blue fills of varying lengths representing the values,the cells most likely have ________ applied to them.

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

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?

Which of the following will you select as X in the following series of clicks/entries to insert a chart using the Quick Analysis tool: Range of cells > X > Charts > Select Chart Type you want?

What will you select as X in the following series of clicks to insert a Recommended chart: Range of cells > X > Charts group > Recommended Charts > Clustered Column > OK?

Ngabile wants to insert a Treemap chart for a data set.To do so,she can click on the following series: Range of cells > Page Layout tab > Apps group > Insert Hierarchy Chart > Treemap.