Creating and Modifying Charts Test

Excel 2010 Training -
Charts
Free Online Microsoft Excel Tests

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Creating and Modifying Charts Test

1) Study the screenshot above. To insert this type of chart in Excel, which of the following options must you choose from the Insert Chart group?

a) Click on Other Charts and select Doughnut from the menu list.
b) Click on Other Charts and select Bubble from the menu list.
c) Click on Area and select 3D area.
d) Click on Pie and select Pie from the menu.

2) Which of the options below represent the method for inserting a title or heading for a chart?

a) Under Chart Tools, click on the Design tab and select Insert Chart Title in the Chart Layouts group.
b) Under Chart Tools, click on the Layout tab and select Insert Chart Heading from the Background group.
c) Under Chart Tools, click on the Layout tab, select Chart Title and choose the relevant option for where to insert the title.
d) Under Chart Tools, click on the Format tab and select Format Chart Title from the Headings group.

3) Charlotte selected data in her worksheet and then inserted a chart. However, the chart is obscuring her data. How can she rectify this?

a) She can simply cut and paste the chart to a different worksheet or to a different part of the current worksheet.
b) She needs to delete the current chart and first select a blank sheet or space before inserting the chart again.
c) She needs to right-click the chart and select Move Below Data Table from the menu list.
d) All of the options listed above are correct.

4) After a chart has been inserted and formatted, is it possible to change the data range it refers to or to add new rows of data?

a) No, additional data cannot be included in a chart once it has been created. Delete the chart and create a new chart.
b) Yes, click on the Select Data button in the Data group under the Design tab to extend or reduce the data range.
c) Yes, click on the chart, select the additional rows or columns of data you wish to add and press Enter on your keyboard.
d) Yes, double click the chart and select Properties from the list. In the Properties box insert the new data range to include in the chart.

5) Patrick has inserted a Bar Chart but his boss has asked him to rather use a Column Chart to represent the data range. How do you change a Bar Chart to a Column Chart?

a) Right-click the Bar Chart and select rotate from the menu list. This will turn the bar chart vertically to display as columns.
b) Select the chart, click on the Design tab and then select the Switch Row/Column button to rotate the data so that it displays as columns.
c) Select the chart, click on the Design tab and then select the Change Chart Type button and select the Column Chart from the list.
d) None of the options listed above are correct.

6) Study the screenshot above. In chart anatomy, what is the area circled in yellow called?

a) This is called the Legend of the chart.
b) This is called Data Labels.
c) This is called Axes Titles.
d) This is called Plot Area Labels.

7) Where will you find options to add or remove the background color or style of a chart?

a) Under the Design tab in the Chart Layouts group.
b) Under the Design tab in the Chart Styles gallery.
c) Under the Format tab in the Shape Styles group.
d) Under the Layout tab in the Insert group.

8) Study the screenshot above. How can the amounts in the data labels on each segment of the Pie Chart be displayed as percentages in addition to the amounts currently displayed?

a) By inserting a formula to convert data to percentages in the original data set that the chart is based on.
b) By deleting the amounts and typing in the percentages in the Data Labels.
c) By right-clicking on any of the Data Labels, selecting Format Data Series and ticking the box for Percentage under the Label Options.
d) By right-clicking on any of the Data Labels, selecting Format Data Labels and ticking the box for Percentage under the Label Options.

9) Study the screenshot above. How can you quickly change the colors for each of the bars in the chart from orange to purple, blue, green, turquoise, yellow and red, respectively?

a) Click on the bars to select them, then go to the Chart Styles group under the Design tab and select the relevant color style from the gallery.
b) Click on individual bars to select them, then go the Shape Styles group under the Format tab and select a color from the Shape Fill button.
c) Click on individual bars to select them, then go to the Chart Layouts group under the Design tab and select the relevant color style from the gallery to apply to individual bars.
d) Click on the bars to select them, then in the Styles group under the Format tab tick the Multicolor box in the list.

10) Where will you find options to add a border around the outside of your chart?

a) Under the Design tab in the Chart Layout gallery.
b) Under the Format tab in the Shape Styles group.
c) Under the Layout tab in the Background group.
d) None of the options above are correct.