wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Data_modelling_Assessment

Total questions: 104

Worksheet time: 1hrs 5mins

Name
Class
Date
1.

Which of these is an example of a appropriate use of a spreadsheet?

a)

Writing a Letter for a Job

b)

Presenting Information to students

c)

Storing results of a Science Experiment

d)

Creating an animation for a film

2.

Which of the following is not part of a spreadsheet

a)

Cell

b)

Table

c)

Column

d)

Row

e)

Box

3.

What is the definition of "Cell Reference"

a)

The address of a cell

b)

Where a cell is

c)

What data is referenced in a cell

d)

How much data a cell can store

4.

Which is the correct format for writing cell references?

a)

Letter Number (A1)

b)

Number Letter(1A)

c)

Letter Letter (AA)

d)

Number Number (11)

5.

What cell is highlighted?

a)

4C

b)

B4

c)

C4

d)

4B

6.

Which Cell should the total of the scores be entered?

a)

D2

b)

A3

c)

B3

d)

C3

7.

What is the range of the cells highlighted?

a)

A1:D1

b)

A1,D4

c)

A1:D4

d)

A1:D3

8.

What is the range of the cells not highlighted?

a)

A1:D1

b)

A4,D4

c)

A1:D4

d)

A4:D5

9.

What would the answer be to C1 + C2

a)

7

b)

20

c)

21

d)

4

10.

What would the answer be to A1 / A2

a)

3

b)

20

c)

10

d)

5

11.

What would the answer be to A1 + D2 + A2 - C1

a)

20

b)

22

c)

25

d)

5

12.

Which of the following facts about spreadsheets is false?

a)

Spreadsheets can be used for mathematical calculations

b)

Spreadsheets are able to produce useful charts and graphs

c)

Spreadsheets are helpful for people creating financial budgets

d)

Spreadsheets are not very good at handling large amounts of data

13.

Which of the following formulas will return the result 8

a)

=D3-C2

b)

=A1+B1

c)

=A4-C2

d)

=C1+D1+D2

14.

Which of the following formulas will return the result 3

a)

=A1/D1

b)

=D2*C1

c)

=A1-D1

d)

=D3-D4

15.

What would the result of (B1-A1)*D1

a)

15

b)

25

c)

3

d)

12

16.

What would the result of =Sum(A1:D1)

a)

43

b)

40

c)

35

d)

3

17.

What would the result of =Average(D1:D4)

a)

30

b)

4

c)

8

d)

32

18.

What would the result of =MAX(A1:D4)

a)

27

b)

56

c)

12.75

d)

86

19.

What would the result of =MIN(A1:D4)

a)

1

b)

3

c)

12.75

d)

-56

20.

Which of the following Formulas is wrong?

a)

=A1+A2

b)

=A1/A2

c)

=Sum A1:A4

d)

=Min(A1:A4)

21.

Which of the following formulas add all the numbers in a range together?

a)

=SUM

b)

=AVERAGE

c)

=MIN

d)

=MAX

22.

Which of the following formulas finds the average number from a range of numbers?

a)

=SUM

b)

=AVERAGE

c)

=MIN

d)

=MAX

23.

Which of the following formulas finds the smallest number from a range of numbers?

a)

=SUM

b)

=AVERAGE

c)

=MIN

d)

=MAX

24.

Which of the following formulas finds the biggest number from a range of numbers?

a)

=SUM

b)

=AVERAGE

c)

=MIN

d)

=MAX

25.

What does formatting a spreadsheet mean?

a)

Changing the appearance of the spreadsheet

b)

Changing data in the spreadsheet

c)

Changing the formulas in a spreadsheet

d)

Changing how a spreadsheet handles data

26.

Which of the following is not a way to format a spreadsheet?

a)

Merge Cells

b)

Changing the Font

c)

Colour Fill

d)

Adding Borders

e)

Adding columns

27.

What formatting has taken place in C1

a)

Added Border

b)

Colour Fill

c)

Font Colour

d)

Font Change

28.

What formatting has taken place in A2

a)

Added Border

b)

Colour Fill

c)

Font Colour

d)

Font Change

29.

What formatting has taken place in B3

a)

Bold Text

b)

Colour Fill

c)

Italic Text

d)

Font Colour

30.

What formatting has NOT taken place in A4

a)

Added Border

b)

Border Colour

c)

Cell Size

d)

Font Colour

31.

Conditional Formatting is when...

a)

A spreadsheet is formatted by the user

b)

Data is formatted when a button is pressed

c)

Spreadsheet is formatted when certain conditions are True

d)

Spreadsheet is formatted in certain condtions by the user

32.

If I wanted to highlight all the cells that had a value smaller than 1, which of the following rules should I use?

Format Cells if...

a)

Greater Than 1

b)

Less Than 1

c)

Less Than or Equal to 1

d)

< 1

33.

If I wanted to highlight all the cells that had the word "Yes" in, which of the following rules should I use?

Format cells if ...

a)

Text contains "yes"

b)

Text is exactly "Yes"

c)

Cell is not empty

d)

Cell is "Yes"

34.

Why do we use conditional formatting?

a)

So we can make important data stand out

b)

To make our spreadsheets look good

c)

To make non - important data less obvious

d)

To show conditions which we like

35.

Which of the following could be used to conditionally format this table?

Format cells if...

a)

Text is exactly 5

b)

Text is less than 7

c)

Less than 6

d)

Greater than 0

36.

What rule should be used to highlight the remaining cells as red?

Format cells if...

a)

Text is exactly 20

b)

Text is less than 21

c)

Less than 50

d)

Greater than 5

37.

What will appear in my cell if I used the following formula:

=IF(A1>B1,"Yes","No")

a)

Yes

b)

No

c)

A1

d)

15

38.

What will appear in my cell if I used the following formula:

=IF(A1<B1,"Yes","No")

a)

Yes

b)

No

c)

A1

d)

15

39.

What will appear in my cell if I used the following formula:

=IF(A1<B1,"Yes",IF(A1<C3,"Maybe","No"))

a)

Yes

b)

No

c)

A1

d)

15

40.

Using Cells D1 and B4, which formula would return "Awesome"?

a)

=IF(D1>B4,"Awesome","Boo")

b)

=IF(D1=>B4,"Awesome","Boo")

c)

=IF(1D<4B,"Awesome","Boo")

d)

=IF(D1<B4,"Awesome","Boo")

41.

Nested If Statements are...

a)

IF Statements with no False value

b)

IF Statements within another IF Statement

c)

IF Statement repeated a number of times

d)

IF Statements that say something only if the condition is True

42.

What would be the result of the following formula?

=SUM(A3:D3)

a)

26

b)

33

c)

35

d)

9

43.

What would be the result of the following formula?

=MIN(A1:A4)

a)

15

b)

5

c)

6

d)

16

44.

What would be the result of the following formula?

=MAX(C1:C4)

a)

3

b)

17

c)

8

d)

1

45.

Which of the following formulas could you use to get the answer in D4 using any of the other cells?

a)

=IF

b)

Arithmetic (/*-+)

c)

=Sum

d)

All of these are possible

46.

Which of the following Cells is not highlighted?

a)

C1

b)

D1

c)

C4

d)

A2

47.

Which Cell has the answer to the following formula:

= A2+B3-B1-C1

a)

C3

b)

D1

c)

A4

d)

B3

48.

Which Cell has the answer to the following formula:

=SUM((A3:C3)-D3)-C4

Remember BODMAS!

a)

C3

b)

D1

c)

A1

d)

B3

49.

Which formula is used to calculate the number of target sales that were met?

a)

=IF

b)

=SUM

c)

=COUNT

d)

=COUNTIF

50.

What should be used to highlight any sales figures over £1000

a)

Formatting

b)

Conditional Formatting

c)

IF Statements

d)

SUM function

51.

Which formula has been used to calculate average sales?

a)

average

b)

=Average

c)

=Sum

d)

=Sum

52.

Which formula has been used to calculate Total Stock

a)

average

b)

=Average

c)

=Sum

d)

Sum

53.

Which formula has been used to calculate restock

a)

=IF

b)

=Average

c)

=Sum

d)

=Count

54.

Adding Borders, Colour Fill Cells and Bold and Underlining data is known as what?

a)

Conditional formatting

b)

Formatting

c)

Formulas

d)

Designing

55.

What formula could be used to calculate the Sales figures for teddy bears?

a)

=D2*G2

b)

=D2/G2

c)

=Sum(D2*G2)

d)

=Multi(D2*G2)

56.

To meet their sales targets, 60% of the must be sold. How many products did not meet this target?

a)

3

b)

4

c)

8

d)

5

57.

Which product has the following product number: 11885

a)

Monopoly

b)

Uno

c)

Fidget Block

d)

Football

58.

How many Barbies were sold?

a)

75

b)

50

c)

25

d)

35

59.

How much is the Lego Set?

a)

10

b)

3

c)

25

d)

3125

60.

Was the target sales met for the rugby ball?

a)

Yes

b)

No

c)

Can't Tell

d)

Maybe

61.
What do all formulas begin with?
a)
%
b)
[ ]
c)
=
d)
:
62.
What symbol do we use for multiplication in a Spreadsheet program? 
a)
/
b)
=
c)
^
d)
*
63.
What symbol do we use for addition in a Spreadsheet program? 
a)
/
b)
+
c)
=
d)
*
64.
What symbol do we use for subtraction in a Spreadsheet program? 
a)
/
b)
*
c)
+
d)
-
65.
What symbol do we use for division in a Spreadsheet program? 
a)
/
b)
*
c)
+
d)
=
66.
Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?
a)
A4-A3=
b)
A3-A4=
c)
=A4-A3
d)
=A3-A4
67.
Which of the following tells a Spreadsheet to Divide the value in cell A3 by 27?
a)
=27/A3
b)
= A3/27
c)
= 27^A3
d)
=A3*27
68.
Which of the following formulas will add cells A1 thru A5?
a)
=SUM(A2+A5)
b)
=A1+A2+A3+A4+A5
c)
=A1:A5
d)
=A1-A2-A3-A4-A5
69.
Which of the following is a formula that will add cells C9 and C10?
a)
=C9+C10
b)
C9+C10
c)
=C9:C10
d)
=C9*C10
70.
Which of the following is a formula that will multiply cells A1 and A2?
a)
A1*A2
b)
=A1:A2
c)
=A1*A2
d)
=Multiply(A1:A2)
71.
Which of the following is a formula that will divide cell D10 by 2?
a)
=D10/A2
b)
10/2
c)
=D10*2
d)
=D10/2
72.
Which of the following is a formula that will subtract cell B4 from cell B3?
a)
=3-4
b)
=B3-B4
c)
=B3*B4
d)
B3-B4
73.
Which of the following is a formula that will divide cell A10 by cell A1?
a)
=A10/A1
b)
=A1/A10
c)
=A10*A1
d)
=Divide(A10:A1)
74.
Which of the following is a correct example using the AUTOSUM function?
a)
sum(D14:D19)
b)
=D14:d19
c)
=sum(D14:D19)
d)
=D14+D15+D16+D17+D18+D19
75.
Which of the following is a correct example using the AUTOSUM function?
a)
=Sum(A1-A10)
b)
=Sum(A1:A10)
c)
=A1+A2+A3+...+A10
d)
=Sum(A1+A2+A3+...+A10)
76.
When a photo or video is shared on the internet, who might be able to see it?
a)
Anyone
b)
Just me, everything is automatically private on the internet.
c)
Only the people who I choose
77.
One of your classmates has shared a photo of you that you really don’t like.
What do you do?
a)
Share an embarrassing photo of them in return!
b)
Nothing; it’s up to them what they post online.
c)
Tell an adult and explain why you ’re unhappy.
78.
You took a photo of your friend doing something that might get her into trouble.
Do you share it?
a)
No, I wouldn’t like it if she did that to me.
b)
I’d only share it with my closest friends, so no one else will see it.
c)
She’d definitely see the funny side, and no one will remember!
79.
You want to share a video of yourself online, but are not sure.
Who should you ask before you do it?
a)
The website can tell me if it’s suitable or not.
b)
No one. I can delete it later if I need to.
c)
Your parents or carers.
80.
Using an avatar instead of a photo for an online profile
a)
Safe
b)
Unsafe
81.
Choosing your birthday as a password
a)
Safe
b)
Unsafe
82.

What is E-Safety?

a)

Knowing how to be safe online

b)

Knowing how to be safe in a public place

c)

Knowing how to cross a road

d)

Knowing how to be safe in school

83.

If you receive an abusive e-mail from an anonymous sender, what should you do?

a)

reply politely

b)

send an abusive message back

c)

confront the person you think it probably came from

d)

none of the above

84.
What is the minimum age requirement to use Snapchat?
a)
10
b)
11
c)
12
d)
13
85.
Online games are always safe
a)
TRUE
b)
FALSE
86.
You have received a bad message on your phone, what should you do?
a)
Ignore the message
b)
Block the person and Report to a responsible adult
c)
Delete the message
d)
Reply back politely telling them to stop
87.

Online safety is the same as internet safety and cyber safety.

a)

True

b)

False

88.

All resources you find online are free to use.

a)

True

b)

False

89.

Online safety represents the state of being protected from any security risks to your private information when using internet.

a)

True

b)

False

90.

All images you find online are free to use.

a)

True

b)

False

91.

Anything found online is under copyright unless the author/creator has explicitly indicated that their work is free to use.

a)

True

b)

False

92.

Which of the following is information that is not dangerous to share on the Internet?

a)

your country

b)

personal information

c)

your passwords

d)

famili information

93.

What should you never use when making a password?

a)

Personal data

b)

Numbers

c)

Letters

94.

What is a digital trace?

a)

Everything we leave on the Internet.

b)

Only uploaded images on the Internet

c)

Just what we write on the Internet

95.

What should we do if someone requests our personal information on the Internet?

a)

Write all the data because there is no danger on the Internet.

b)

Write all data except phone number.

c)

Ask an adult for advice.

96.

On the Internet it is desirable to:

a)

Share all your data.

b)

Talk to strangers.

c)

Publish whatever we want.

d)

To adhere to the rules of conduct, not to talk to strangers, not to write inappropriate things.

97.

Why should you be careful when using file sharing sites?

a)

You might be downloading malware.

b)

The person sharing the file can see your name and address.

c)

The person sharing the file will send you a bill.

98.

Someone has told you three reasons why you shouldn't let your mobile phone post your location on social networking sites. Which one is true?

a)

Your parents will be able to track where you've been and guess what you've been up to.

b)

The local shopping centre will notice you're there so often that they will offer you a job.

c)

Someone might go to your house while you're out and burgle it.

99.

What term describes the act of winding someone up online?

a)

Trolling

b)

Posting

c)

Phishing

100.

What should you do if you want to meet someone you only know online?

a)

Meet somewhere quiet, so you can get to know each other.

b)

Take an adult with you and meet in a public space.

c)

Don't tell anyone because that would be embarrassing.

101.

What software can you use to avoid getting viruses?

a)

Disk Cleanup software

b)

Firewall software

c)

Anti-virus software

102.

Which of these statements is true?

a)

It is illegal to download from file-sharing sites.

b)

It is free and legal to download anything you find online.

c)

It is legal to use file sharing sites, but not if you're downloading the latest blockbuster or best-selling album.

103.

What can you do to get less spam?

a)

Always tick the 'don't pass on my details' box when filling forms in.

b)

Change your email address every six months.

c)

Never give your email address to anyone.

104.

What might someone do if they steal your identity?

a)

Earn lots of money and leave it in your bank account.

b)

Try to give you all the credit for their hard work.

c)

Try to access your bank account or set up a loan in your name.

Similar Resources on Wayground

Programming Quiz Y10

100 questions

Programming Quiz Y10

quiz

Worksheet

•

KG - 10th Grade

RECF Programming Practice

100 questions

RECF Programming Practice

quiz

Worksheet

•

8th - 12th Grade

Tes Dasar Microsoft Excel

107 questions

Tes Dasar Microsoft Excel

quiz

Worksheet

•

8th Grade

Intro to Python

104 questions

Intro to Python

quiz

Worksheet

•

7th - 9th Grade

GR08

100 questions

GR08

quiz

Worksheet

•

8th Grade

Cyber Review

100 questions

Cyber Review

quiz

Worksheet

•

6th - 8th Grade

Everything Quiz!

100 questions

Everything Quiz!

quiz

Worksheet

•

5th - 10th Grade

ICT Form1 Revision

104 questions

ICT Form1 Revision

quiz

Worksheet

•

8th Grade