Deck 4: Analyzing and Charting Financial Data

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

Answer 1

D

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

Answer 2

A

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.

Answer 3

True

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.

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.

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

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

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

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

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

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.

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.

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.

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.

Question 15

To move a chart to another location on the sane worksheet,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).

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

Question 18

Arrow keys can be used to move any chart element.

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.

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

Question 21

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?

A) Effects
B) Fill & Line
C) Shadow Effects
D) Series Options

Question 22

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?

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

Question 23

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.

Question 24

Which of the following will you select as X in the given series of clicks to remove a data series from a chart: Chart > Chart Tools > Design Tab > Select Data > Data series > X?

A) Add
B) Edit
C) Remove
D) Delete

Question 25

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.

Question 26

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.

Question 27

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?

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

Question 28

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.

Question 29

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?

A) Shape Fill
B) Shape Outline
C) Shape Effects
D) Shape Borders

Question 30

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?

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

Question 31

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?

A) Insert Bar Chart
B) Insert line Chart
C) Insert Area Chart
D) Insert Static Chart

Question 32

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

A) Axes
B) Legend
C) Gridlines
D) Trendline

Question 33

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?

A) Select a color in Color box.
B) Enter +Heading in Latin text font box.
C) Select Normal Spacing in Spacing box.
D) Enter the desired size of the chart title in the Size box.

Question 34

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?

A) Ctrl + Q
B) Alt + F
C) Esc
D) Delete

Question 35

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

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

Question 36

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?

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

Question 37

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?

A) Expand Tick Marks,and then select the options that you want in the Major type and Minor type boxes.
B) Type the number that you want in the text box.
C) Expand Tick Marks,and then in the Interval between tick marks box,and type the number that you want.
D) Expand Labels,then under Interval between labels,select Specify interval unit and type the number you want in the text box.

Question 38

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?

A) Align Top
B) Align Left
C) Align Center
D) Align Bottom

Question 39

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?

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 40

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?

A) Text Fill & Outline
B) Text Effects
C) Text Box
D) Size & Properties

Question 41

To edit an embedded object such as an Excel spreadsheet in its source application,double-click the drawer ID of the appropriate drawer in the Folders window,then double-click the folder containing the Excel spreadsheet,highlight it,choose Object > Edit Object to enter edit mode and make desired changes in it.

Question 42

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.

Question 43

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

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

Question 44

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

Question 45

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?

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

Question 46

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.

Question 47

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.