Quiz 5

QUIZ 5
Instruction: Type / Write your answer in separate sheet (Letter

ONLY)
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. Bottom of Form
B. She can simply cut and paste the chart to a different worksheet or to a different part of the
current worksheet.
C. She needs to delete the current chart and first select a blank sheet or space before inserting the
chart again.
D. She needs to right-click the chart and select Move Below Data Table from the menu list.
E. 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.
DENNIS Q. LABRADOR BSCRIM
ANSWERS:
1. D
2. C
3. B
4. B
5. C
6. A
7. C
8. D
9. B
10.B

Quiz 5

Uploaded by

Copyright:

Available Formats

Quiz 5

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Quiz 5

Uploaded by

Copyright:

Available Formats

QUIZ 5

Instruction: Type / Write your answer in separate sheet (Letter

You might also like