Exam 4: Analyzing and Charting Financial Data

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?

Arrow keys can be used to move any chart element.

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.

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.

What will you do in step X in the following series of clicks to change the font size of chart title: (Right-click) Chart Title > Font > Font tab > X> OK?

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

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.

What will you do to explode a pie chart slice?