Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Charts in MS Excel (Class:7th)

Total questions: 35

Worksheet time: 18mins

Name
Class
Date
1.

__________ is a area that holds all the elements of a chart.

a)

Plot Area

b)

Chart Title

c)

Chart Area

d)

Legends

2.

Vertical axis of a chart is _______

a)

X axis

b)

Y axis

c)

X axis

d)

B axis

3.

The lines that run across the plot area are known as _______

a)

Sparklines

b)

Slice

c)

Cross lines

d)

Gridlines

4.

The other name of X-axis is ______________

a)

Category axis

b)

Axes title

c)

Value axis

d)

Blocks

5.

What type of chart is this?

a)

Pie Chart

b)

Bar Chart

c)

Doughnut Chart

d)

Scatter Chart

6.

Click __________ tab to create a chart.

a)

CREATE

b)

INSERT

c)

FORMAT

d)

HOME

7.

What are the two additional tabs that appears after inserting a chart

a)

INSERT, FORMAT

b)

LAYOUT, DESIGN

c)

FORMAT, LAYOUT

d)

DESIGN, FORMAT

8.

To quickly create a chart press _______ function key.

a)

F8

b)

F9

c)

F10

d)

F11

9.

Click __________ group in DESIGN tab to move a chart to a new worksheet.

a)

Location

b)

Data

c)

Type

d)

Layouts

10.

Click __________ group in DESIGN tab to move a chart to a new worksheet.

a)

Location

b)

Data

c)

Type

d)

Layouts

11.

Legends are added at the ________ of a chart by default.

a)

top

b)

bottom

c)

middle

d)

right

12.

Vertical axis of a chart is _______

a)

X axis

b)

Y axis

c)

X axis

d)

B axis

13.

A Chart is a pictorial representation of data

a)

True

b)

False

14.

A Chart can be moved to a separate sheet.

a)

True

b)

False

15.

Once a type of graph is chosen it cannot be changed to other type

a)

True

b)

False

16.

Every chart must have a

a)

chart name

b)

chart title

c)

chart slogan

d)

chart word

17.

On our X and Y axis we must always

a)

insert axis titles

b)

leave these blank

c)

fill them in with numbers

d)

remove them

18.

we must add these so that the person reading the chart can see the exact figures clearly

a)

data labels

b)

information labels

c)

number labels

d)

item labels

19.
Part of a pie chart that represents one value from the series.
a)
axis
b)
data
c)
slice
d)
chart
20.
Data graphed as slices of a circular area is a 
a)
bar chart
b)
scatter plot
c)
pie chart
d)
column chart
21.
Once you have created a chart you cannot add another data series.
a)
True
b)
False
22.
a)

BAR

b)

LINE

c)

STOCK

d)

COMBO

23.
a)

RADAR

b)

LINE

c)

BAR

d)

STOCK

24.
a)

LINE

b)

CIRCLE

c)

PIE

d)

COMBO

25.
a)

Surface

b)

Line

c)

BAR

d)

COMBO

26.
a)

Area

b)

Stock

c)

Sunburst

d)

Radar

27.

What is the use of line chart in Microsoft excel?

a)

Used for data that may need to be compared.

b)

Used to illustrate changes in a value over a period of time.

c)

Used to compare individual items in a dataset.

28.
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
a)
Decrease/Increase
b)
Collapse/Expand
c)
Reduce/Add
d)
Subtract/Add
29.
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
30.
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?
a)
Bar
b)
Column
c)
Line
d)
Pie
31.
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
a)
Style
b)
Design 
c)
Layout
d)
Format
32.
Which is a tiny chart that provides a visual representation of data in a worksheet cell?
a)
Trendline
b)
Sparkline
c)
Dataline
d)
Flashpoint
33.

Which is NOT a type of chart?

a)

pie

b)

column

c)

bar

d)

axis

34.

Is a column vertical or horizontal?

a)

vertical

b)

horizontal

35.

Charts are made up of a variety of elements, also called data___________

a)

Labels

b)

Gridlines

c)

Objects

d)

None of these