wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Quiz 7

Total questions: 15

Worksheet time: 13mins

Name
Class
Date
1.

What kind of chart is it?

a)

A Line graph

b)

A Bar chart

c)

A Pie graph

d)

It is not a graph

2.

In this graph, what is the chart title?

a)

Countries

b)

Percentages

c)

Drivers in the World

d)

This graph does not have a title

3.

After making a graph in Excel, if the values in the table change, the graph changes automatically.

a)

b)

4.

The horizontal lines behind the graph are called ...

a)

horizontal grid lines

b)

vertical grid lines

c)

just lines

d)

data

5.

From which of the following options can we change the color of the graph?

a)

b)

c)

d)

6.

From which of the following options can we add or remove chart elements?

a)
b)
c)
d)
7.

I drew a line graph but i want to change chart type and want to make it a pie graph. Which of the followings would do that?

a)
b)
c)
d)
8.

What will appear in the blue box if I type +244 in the yellow box?

a)

Algeria

b)

Angola

c)

Argentina

d)

Armenia

9.

What kind of formula do we use to make such a program in Excel?

a)

The sum formula

b)

The average formula

c)

The IF formula

d)

The conditional formatting

10.

What is the right way to write the IF function?

a)

IF(A5=A1,B1,0)

b)

=IF(A5=A1,B1,0)

c)

=IF(0,A5=A1,B1)

11.

When I type 1 in blue box, I want yellow to show in the yellow box. Similarly, for 2 I want blue and for 3 I want Green in the yellow box. is the following formula correct?

=IF(A5=A1,B1,IF(A5=A2,B2,IF(A5=A3,B3,"Error")))

a)

b)

c)

It is half correct and half wrong

12.

Which of the following function arrange numbers from biggest to smallest?

a)

Sort

b)

Average

c)

CONCAT

d)

PROPER

13.

Which of the following function would write "abdullah" as "Abdullah"?

a)

Sort

b)

Average

c)

CONCAT

d)

PROPER

14.

Can we resize the graph in Excel? (make a graph look bigger or smaller)

a)

Yes

b)

No

15.

Which of the following can arrange numbers from biggest to smallest??

a)
b)
c)
d)