wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Grade-8 Ch-2 Advanced Features of Excel Quiz

Total questions: 12

Worksheet time: 7mins

Name
Class
Date
1.

Part of a pie chart that represents one value from the series.

a)

Slice

b)

Axis

c)

Data

d)

Legend

2.

The part of the chart area that displays data.

a)

Legend

b)

Axis

c)

Series

d)

Plot Area

3.

This describes what is charted. It can be placed above or below the chart.

a)

Chart Title

b)

Chart Area

c)

Pie Chart

d)

Bar Chart

4.

Once you have created a chart you cannot add another data series.

a)

True

b)

False

5.
a)

Bar Chart

b)

Column Chart

c)

Area Chart

d)

Scatter Chart

6.

John wants to identify the exact value that each column in his chart represents. Which option should he choose?

a)

Gridelines

b)

Arrows

c)

Pictures

d)

Labels

7.

Which chart would you use if you had two categories and you wanted to show distribution (how they add up to 100%) of those two categories?

Example: % of people who bought whole milk and % of people who bought skim milk in December.

a)

Pie

b)

Bar

c)

Line

d)

Column

8.

Sorting makes the data______________ to read.

a)

difficult

b)

easier

c)

complex

9.

To insert a chart in Ms Excel

a)

You should select the data you want to present

b)

No need to select the data you want to present

c)

You should copy the data you want to present

d)

You should delete the data you want to present

10.

Which tab we use it in Excel to add a graph?

(a)  

11.

In which chart there is no X-axis and Y-axis?

(a)  

12.

Which chart is used to display correlation between the two variables?

a)

Pie Chart

b)

XY (Scatter) Chart

c)

Line Chart

d)

Bar Chart