wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

G5 - Review - Final 2 - Excel+Access-21/22

Total questions: 64

Worksheet time: 33mins

Name
Class
Date
1.

Where is the cell address of Total Coconut?

a)

A4

b)

B4

c)

E4

d)

E2

2.

Where is the cell address of Total Lemon?

a)

E3

b)

B3

c)

A3

d)

E2

3.

Where is the cell address of Total Pear?

a)

A7

b)

E7

c)

B7

d)

E2

4.

Total of Bicycle is in cell.....

a)

A4

b)

C4

c)

E4

d)

E2

5.

Total of Water Bottle is in cell.....

a)

B5

b)

E4

c)

E5

d)

E6

6.

Which one is the correct cell address?

a)

D5

b)

5D

c)

5+D

d)

D+5

e)

=D5

7.

Which program is used to create spreadsheets?

a)
b)
c)
d)
8.

What is this?

a)

Sheet

b)

Cell

c)

Row

d)

Column

9.

What is this?

a)

Sheet

b)

Cell

c)

Row

d)

Column

10.

In Excel, to do multiplication, which symbol do we use?

a)
b)
c)
d)
11.

In Excel, how we start a formula?

a)
b)
c)
d)
12.

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

a)

SUM(B1:B5)

b)

=B2-B3-B4-B5

c)

=B2*B3*B4*B5

d)

=B2+B3+B4+B5

13.

Choose the correct cell address:

a)

G

b)

G5

c)

5

d)

5G

14.

Choose the correct cell address:

a)

9

b)

H

c)

9H

d)

H9

15.

What is this in MS Excel?

a)

Row G

b)

Column G

c)

Cell G1

d)

Sheet 1

16.

What is this in MS Excel?

a)

Row 6

b)

Column 6

c)

Cell G6

d)

Sheet 1

17.

Columns are called by.....

a)

Number: 1, 2, 3, 4, 5, ......

b)

Letters: A, B, C, ......

c)

1A, 2B, 3C, .....

d)

A1, 2B, 3C, .......

18.

Columns are called by.....

a)

Number: 1, 2, 3, 4, 5, ......

b)

Letters: A, B, C, ......

c)

1A, 2B, 3C, .....

d)

A1, 2B, 3C, .......

19.

Rows are called by.....

a)

Number: 1, 2, 3, 4, 5, ......

b)

Letters: A, B, C, ......

c)

1A, 2B, 3C, .....

d)

A1, 2B, 3C, .......

20.

Rows are called by.....

a)

Number: 1, 2, 3, 4, 5, ......

b)

Letters: A, B, C, ......

c)

1A, 2B, 3C, .....

d)

A1, 2B, 3C, .......

21.

Why is this formula wrong? (choose 2 options)

a)

* is wrong

b)

need = before the formula

c)

wrong cell address

d)

it should be +

22.

Choose the correct formula for Total Sneaker

a)

C3*D2

b)

=C2*D2

c)

=C3*D3

d)

=C3*D2

23.

How many cells are there?

a)

10

b)

2

c)

15

d)

30

24.

How many cells are there?

a)

10

b)

6

c)

60

d)

16

25.

How many cells are there?

a)

10

b)

16

c)

160

d)

610

26.

What is a database?

a)

A number or a word that has no meaning on its own

b)

Data has meaning

c)

A document

d)

A collection of data held in tables

e)

A collection of completed fields about one thing/person

27.

What is a field?

a)

One piece of information

b)

Data has meaning

c)

A document

d)

A collection of data held in tables

e)

A collection of completed fields about one thing/person

28.

What is a record?

a)

One piece of information

b)

Data has meaning

c)

A document

d)

A collection of data held in tables

e)

A collection of completed fields about one thing/person

29.

What is a field?

a)

One piece of information

b)

Data has meaning

c)

A document

d)

A collection of data held in tables

e)

A collection of completed fields about one thing/person

30.

What is a record?

a)

One piece of information

b)

Data has meaning

c)

A document

d)

A collection of data held in tables

e)

A collection of completed fields about one thing/person

31.

How can we make a database?

a)
b)
c)
d)
e)
32.

What databases can help us?

a)

Store information in an organized way

b)

Draw images

c)

Create documents

d)

Make a presentation

33.

When should we use a database?

a)

When creating a presentation for a subject

b)

When creating a document

c)

When storing information in an organized way

d)

When creating charts

34.

What is the length of a Ladybird?

a)

4 cm

b)

0 cm

c)

5 cm

d)

1 cm

35.

Look at the database

Where is the Habitat of Ant?

a)

garden

b)

burrows underground

c)

understone

d)

underground

36.

What is the Name of the chosen insect?

a)

Ant

b)

Dragonfly

c)

Butterfly

d)

Beetle

37.

What is the food of chosen insect?

(a)  

38.

What is the order date of Laura Giussani?

a)

2/6/2006

b)

3/6/2006

c)

1/22/2006

d)

1/20/2006

39.

What is the height of Susanne?

a)

30 m

b)

1.71 m

c)

1.73 m

d)

1.61 m

40.

What are they?

a)

Database

b)

MS Access

c)

Data

d)

Data types

41.

[Number, Date, Currency, Text, Boolean] are .....

a)

Table

b)

Database

c)

Fields

d)

Records

e)

Data types

42.

What is this datatype?

a)

Currency

b)

Boolean

c)

Yes/No

d)

Text

43.

What is this datatype?

a)

Number

b)

Boolean

c)

Yes/No

d)

Text

44.

What is this data type?

a)

Date/Time

b)

Currency

c)

Number

d)

Text

45.

What is this data type?

a)

Date

b)

Text

c)

Number

d)

Currency

46.

Only letters.....

a)

Text

b)

Boolean

c)

Number

d)

Currency

47.

Only number.....

a)

Text

b)

Number

c)

Date

d)

Currency

48.

To type money .......

a)

Text

b)

Boolean

c)

Date

d)

Currency

49.

What is the data type of the "Wings" field?

a)

Text

b)

Number

c)

Date

d)

Boolean

e)

Currency

50.

Which superhero is chosen?

a)

Cloudily

b)

Moledigger

c)

Skyman

d)

Treewisp

e)

Superhero Name

51.

Which superhero is chosen?

a)

Cloudily

b)

Moledigger

c)

Skyman

d)

Treewisp

e)

Superhero Name

52.

How many fields are there in this database?

(a)  

53.

How many fields in this database?

(a)  

54.

How many records are there in this database?

(a)  

55.

How many records are there in this database?

(a)  

56.

Which are not data types? (choose 2 options)

a)

Birthday

b)

Date

c)

Text

d)

Number

e)

Age

57.

Which are NOT data types? (choose more than one option)

a)

Price

b)

Currency

c)

Gender

d)

Date

e)

Date of birth

58.

YES/NO, TRUE/FALSE is .....

a)

Date

b)

Boolean

c)

Number

d)

Text

59.

Which data type is this?

YES/NO

a)

Date

b)

Number

c)

Text

d)

Boolean

60.

Which data type is this?

TRUE/FALSE

a)

Date

b)

Number

c)

Text

d)

Boolean

61.

How many fields are there in this table?

a)

7

b)

8

c)

10

d)

11

62.

How many records are there?

a)

7

b)

8

c)

10

d)

11

63.

How many records can you see?

a)

7

b)

8

c)

9

d)

10

64.

Which can you use databases for? (choose 3 options)

a)

Student list

b)

Movies

c)

Online supermarket

d)

E-book library

e)

Video Games

Similar Resources on Wayground

Preparing for MTA Certification

60 questions

Preparing for MTA Certification

quiz

Worksheet

•

KG - University

Ôn tập KSTA4

60 questions

Ôn tập KSTA4

quiz

Worksheet

•

4th - 5th Grade

Cyberbezpieczeństwo

59 questions

Cyberbezpieczeństwo

quiz

Worksheet

•

1st - 6th Grade

CF1+2

59 questions

CF1+2

quiz

Worksheet

•

1st - 5th Grade

ÔN TẬP TIN LỚP 5 HK2

63 questions

ÔN TẬP TIN LỚP 5 HK2

quiz

Worksheet

•

4th Grade

Final Exam Practice Computer 6

59 questions

Final Exam Practice Computer 6

quiz

Worksheet

•

5th - 7th Grade

Computer Basics Test

61 questions

Computer Basics Test

quiz

Worksheet

•

6th - 8th Grade

Módulos 4 – 7: Examen de conceptos Ethernet

66 questions

Módulos 4 – 7: Examen de conceptos Ethernet

quiz

Worksheet

•

1st - 5th Grade