wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Advanced features of excel

Total questions: 14

Worksheet time: 28mins

Name
Class
Date
1.

A __________ is a graphical representation of data.

a)

Algorithm

b)

Steps

c)

Charts

d)

None of the above

2.

A column Chart use _______________ bar to represent data.

a)

Horizontal

b)

Vertical

3.

A chart is also called as graph.

a)

true

b)

false

4.

Observe the image and choose the correct type of Chart

a)

Line Chart

b)

Pie Chart

c)

Scatter Chart

d)

Area Chart

5.

Find the odd one.

a)

Pie Chart

b)

fundamental Chart

c)

Bar Chart

d)

Surface Chart

6.

Once a Chart is inserted a new window will appear.

a)

True

b)

False

7.

Chart gets updated automatically when you change data in:

a)

Word

b)

Excel

c)

Access

d)

None of them

8.

To move the Chart inside the document use ________________ option.

a)

Wrap Text

b)

WordArt Style

9.

Observe the given image and choose the correct answer.

a)

Scatter Chart

b)

Pie Chart

c)

Radar Chart

d)

Column Chart

10.

In __________ tab Chart button is available.

a)

File

b)

Illustratoins

c)

Design

d)

Insert

11.

The part of a chart area that displays data is_____

a)

Chart Title

b)

Plot Area

c)

Axis

d)

Data Series

12.

Which function key is used to insert a chart in a worksheet?

a)

F5

b)

F9

c)

F6

d)

F11

13.

....................... is a key that is used ti identify the colours, patterns, or symbols assigned to data series.

a)

Axis titles

b)

Plot area

c)

Legend

d)

Chart area

14.

What are the heading given to X-axis and Y- axis known as?

a)

Data Series

b)

Legends

c)

Axis Titles

d)

Gridlines