Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Microsoft Office Excel

Computing

Quiz 4 :

Analyzing and Charting Financial Data

Quiz 4 :

Analyzing and Charting Financial Data

search
arrow
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?
Free
Multiple Choice
Answer:

Answer:

C

arrow
To move a chart to another location on the sane worksheet, drag it to the location you want.
Free
True False
Answer:

Answer:

True

arrow
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.
Free
True False
Answer:

Answer:

True

arrow
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).
True False
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
How can you remove data labels from a chart?
Multiple Choice
Answer:
arrow
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.
True False
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
To which of the following chart types can you not add axis titles?
Multiple Choice
Answer:
arrow
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.
True False
Answer:
arrow
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.
True False
Answer:
arrow
What will you do to explode a pie chart slice?
Multiple Choice
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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.
True False
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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
Multiple Choice
Answer:
arrow
Arrow keys can be used to move any chart element.
True False
Answer:
arrow
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.
True False
Answer:
Showing 1 - 20 of 48