Free Printable G3 - Review - Final 2

1.

Which program is used to create spreadsheets?

a)

b)

c)

d)

2.

In Excel, how we start a formula?

a)

b)

c)

d)

3.

In Excel, how to do addition?

a)

b)

c)

d)

4.

To calculate the total quantity of pens & pencils, which formula should we use?

a)

=A2+B2

b)

=A1+B1

c)

A2+B2

d)

C2-B2

5.

Which one is the correct formula for the total quantity of candies?

a)

SUM(B1:B5)

b)

SUM(B2:B5)

c)

=SUM(B1+B5)

d)

=B2+B3+B4+B5

6.

To combine two cells into one, which function do you use?

a)

b)

c)

d)

7.

To show a very long text in a cell into many lines, which button do you click?

a)

b)

c)

d)

8.

Which tab do we use to create a graph in Excel?

a)

Home tab

b)

Insert tab

c)

Page Layout tab

d)

Formulas tab

9.

Which one is a column chart?

a)

A

b)

B

c)

C

10.

What is this?

a)

Column Chart

b)

Pictogram

c)

Chart

d)

Other

e)

Bar Chart

11.

Which one is the first step used to make a column chart?

a)

Highlight the Data table

b)

Click on Insert tab

c)

Click the Column chart

12.

Which button is used to add Axis titles?

a)

1

b)

2

c)

3

d)

4

13.

Which tab is used to make a chart?

a)

File

b)

Home

c)

Insert

14.

Which type is this chart?

a)

Column Chart

b)

Pie Chart

c)

Radar Chart

d)

Bar Chart

15.

Identify this chart.

a)

Column

b)

Bar

c)

Line

d)

Pie

16.

Identify this chart.

a)

Line

b)

Bar

c)

Column

d)

Pie

17.

According to this chart, which type of pork do people prefer most?

a)

Bacon

b)

Ribs

c)

Ham

d)

Other

18.

What is the name of the chart

a)

column chart

b)

pie chart

c)

bar chart

d)

line chart

19.

What is the name of the chart?

a)

Column chart

b)

Bar chart

c)

Pie chart

d)

Line chart

20.

what picture do you see in C8?

a)

Face

b)

LL

c)

Z

21.

What type of chart is this?

a)

bar chart

b)

area chart

c)

stock chart

d)

column chart

22.

What is this?

a)

Column Chart

b)

Line Chart

c)

Pie Chart

d)

Bar Chart

23.

Select 2 BAR charts

a)

b)

c)

d)

e)

24.

Select 2 COLUMN charts

a)

b)

c)

d)

e)

25.

How to calculate the Total of Lemon?

a)

C2*D2

b)

=C2*D2

c)

C3*D3

d)

=C3*D3

e)

=C3xD3

26.

How to calculate the Total of Strawberry?

a)

=C4*D4

b)

C5*D5

c)

=C5*D5

d)

C5xD5

27.

How to calculate the Total of Sneaker?

a)

C2*D2

b)

=C2*D2

c)

C3*D3

d)

=C3*D3

e)

=C3xD3

28.

How to calculate the Total of Water Bottle?

a)

=C4*D4

b)

C5*D5

c)

=C5*D5

d)

C5xD5

29.

How to calculate the "Number of cookies for each kid"?

a)

=A2/B2

b)

=A2:B2

c)

=A2*B2

d)

A2/B2

30.

How to calculate the "Number of lollipops for each kid"?

a)

=A2/B2

b)

=A2:B2

c)

=A2*B2

d)

A2/B2

31.

What is this?

a)

Sheet

b)

Cell

c)

Row

d)

Column

32.

What is this?

a)

Sheet

b)

Cell

c)

Row

d)

Column

33.

What is this?

a)

Sheet

b)

Cell

c)

Row

d)

Column

34.

What is this?

a)

Formula Bar

b)

Tab List

c)

Ribbon

d)

Name box

35.

What is this?

a)

Cell address

b)

Row Number

c)

Column header

d)

Formula Bar

36.

Which formula is correct?

a)

*B1+B2

b)

B1+B2

c)

?B1+B2

d)

=B1+B2

37.

What can we find in Number 2?

a)

Column Heading

b)

Formula Bar

c)

Tabs

d)

Cell Reference

38.

Where can we find Cell Reference?

a)

1

b)

2

c)

3

d)

4

39.

Which key helps us to select columns that aren't next to each other?

a)

b)

c)

d)

40.

To select columns B and column D, which key should I use?

a)

b)

c)

d)

41.

Choose the correct cell address:

a)

3

b)

D

c)

3D

d)

D3

42.

Choose the correct cell address:

a)

G

b)

G5

c)

5

d)

5G

43.

In Excel, which one is the correct formula of AutoSum?

a)

SUM(A1+C1)

b)

=SUM(A1+C1)

c)

SUM(A1:C1)

d)

=SUM(A1:C1)

44.

In Excel, which function is used for addition?

a)

b)

c)

d)

45.

Which is the icon of MS Paint?

a)

b)

c)

d)

46.

If we make a little mistake, what do we press to erase that part?

a)

letter

b)

c)

47.

What does "Duplicate" mean?

a)

Delete

b)

Make a Copy

c)

Move

d)

Erase

48.

How to duplicate the ice cream?

a)

b)

c)

d)

49.

In MS Paint, how to duplicate an image?

a)

b)

c)

d)

50.

Which one should I use to fill red into the heart shape?

a)

1

b)

2

c)

3

d)

4

e)

5

51.

How to change the direction of the image?

a)

b)

c)

d)

e)

52.

How to change the direction of the image?

a)

b)

c)

d)

e)

G3 - Review - Final 2 - 21.22

Total questions: 52

Worksheet time: 27mins

Similar Resources on Wayground