Exam 4: Analyzing and Charting Financial Data

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.

Which of the following will you do in step X in the following series of clicks to change the bounds of a chart axis: Chart > Chart Tools > Format tab > Current Selection > Format Selection > Format Axis > Axis Options > Vertical Axis crosses > At Category number > X?

Which of the following will you select as X in the following series of clicks to change the change the color of a data series: (double-click)Data Series > Format Data Series > Series Options > X > Color > Color of your choice?

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.

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

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.

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.

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

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

To insert a trendline that forecasts future trends into a chart,we need to follow this series: Chart > Data series > Chart > Add Trendline > Options tab > Forecast section > Up arrow in the Forecast box.

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?

Olivia wants to align a certain shape on her worksheet in a specific manner.To do so,she clicks on the shape,and then clicks on the Format tab under Drawing Tools.She then clicks on Align in the Arrange group.What should Olivia click on next to align the picture to the left?

Which of the following will you select as X in the following series of clicks to apply a shape fill to a chart element: Chart > Chart Tools > Format > Shape Styles > X?

Which of the following will you select as X in the given series of clicks to add a legend to the bottom of a chart: Chart > + sign > X > Bottom?

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

Nadine wants to insert a sparkline in Excel using the Quick Analysis tool.She can do this by selecting the data for which she wants to add Sparklines,then in the empty column to the right side of the data click the Quick Analysis button,click Sparklines and select the type of Sparkline she wants.

To move a chart to a different worksheet,click on the Chart > Chart Tools > Design tab > Location group > Move Chart > New sheet,and then in the New sheet box,type a name for the worksheet.