Question 1

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?

Accepted Answer

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

Question 2

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.

Accepted Answer

A) True 
 B)False  True

Question 3

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  False

Question 4

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?

Accepted Answer

A)   Axes
B)   Labels
C)   Analysis
D)   Background

Question 5

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.

Accepted Answer

A) True 
 B)False

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

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?

Accepted Answer

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

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

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 10

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?

Accepted Answer

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

Question 11

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.

Accepted Answer

A) True 
 B)False

Question 12

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?

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 15

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?

Accepted Answer

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

Question 16

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 17

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?

Accepted Answer

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

Question 18

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 19

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 20

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

Exam 4: Analyzing and Charting Financial Data

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?

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.

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?

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

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?

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?

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.

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 change the change the color of a data series: (double-click) Data Series > Format Data Series > Series Options > X > Color > Color of your choice?

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

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.

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 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 given series of clicks to remove a data series from a chart: Chart > Chart Tools > Design Tab > Select Data > Data series > X?

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 a chart axis: (Double-click) Value Axis labels > Format Axis > Axis Options > X > Select choice in Category box?

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?