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?

To search for an online picture in the Insert Pictures window, you enter a format related to your subject of interest.

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

What will you select as X in the following series of clicks/entries to insert a Histogram chart: Range of cells > Insert tab > Charts group > X > Histogram group > Histogram chart icon > OK?

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?

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

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?

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?

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.

Which of the following will you select as X in the following series of clicks to apply a shadow effect: (Double-click) Text box > Format Options > Text Options > X > Shadow?

Which option will you click after selecting a chart and clicking on + at its top to add a trendline to a chart?

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

How can you remove data labels from a chart?

To insert a Scatter chart for a data set, we can click on the following series: Range of cells > Insert tab > Charts group > Insert Scatter (X,Y) or Bubble Charts > Scatter > Chart of choice > OK. ​

To insert a Sunburst chart for a data set, we can click on the following series: Range of cells > Data tab > Charts group > Insert Hierarchy Chart > Sunburst.

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?

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

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 3-D pie chart: Insert > Charts group > X > 3-D Pie?

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.