Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 6 Term 2 Quiz (Coding and Spreadsheets)

Total questions: 46

Worksheet time: 43mins

Name
Class
Date
1.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
2.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
3.
The location of a cell on a spreadsheet. It is a column letter followed by a row number.
a)
Cell range
b)
Cell reference
c)
Active cell
d)
Row
4.
The letter at the top of each column is called a:
a)
cell reference
b)
row header
c)
column header
d)
range
5.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
6.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
7.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)
=sum(c9:c10)
8.
Which is an example of a cell reference is a spreadsheet?
a)
6C
b)
B9
c)
45
d)
fall
9.
A mathematical operation is called a _____.
a)
formula
b)
range
c)
label
d)
graph
10.
A graph is a visual representation of data within a spreadsheet.
a)
True
b)
False
11.
A group of cells is called a _____.
a)
graph
b)
selecting
c)
range
d)
cell
12.
What symbol do we use for multiplication in a Spreadsheet program? 
a)
/
b)
=
c)
^
d)
*
13.
What symbol do we use for addition in a Spreadsheet program? 
a)
/
b)
+
c)
=
d)
*
14.
What symbol do we use for subtraction in a Spreadsheet program? 
a)
/
b)
*
c)
+
d)
-
15.
What symbol do we use for division in a Spreadsheet program? 
a)
/
b)
*
c)
+
d)
=
16.
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
17.
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
18.
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
19.

What will happen after this algorithm is run?

a)

an artist will draw a window

b)

an artist will draw a rocket ship

c)

an artist will draw a house

20.

A list of steps used to perform a task is called

a)

coding

b)

algorithm

c)

programming

d)

sequence

21.

Something a computer program can react to, such as a key being pressed or the mouse being clicked

a)

output

b)

event

c)

program

d)

algorithm

22.

What is an error in a program that prevents the program from running as expected?

a)

Algorithm

b)

Code

c)

Bug

23.
What is finding and fixing errors in programs?
a)
Debugging
b)
Program
c)
Bug
d)
Code
24.

In coding terms an action or event you want to repeat multiple times is called a

a)

loop

b)

do-over

c)

sequence

25.

An algorithm is

a)

a dance

b)

measures your heartbeat

c)

a list of steps to complete a task

d)

musical

26.

If you weren't able to complete a challenge the first time you should

a)

pout

b)

give up

c)

try again

d)

bang the keyboard

27.
A PROGRAM is a series of  _____________ for a computer or device to follow
a)
instructions
b)
windows
c)
suggestions
d)
voices
28.

Trying again and again, even when something is very hard.

a)

persistence

b)

algorithm

c)

computational thinking

d)

loop

29.

What does this code do?

a)

Moves forward 1 time

b)

Moves forward forever

c)

Moves forward 5 times

d)

Moves left

30.

What shape does this code make?

a)

Rectangle

b)

Triangle

c)

Square

d)

Circle

31.

If you have an extra block in your work area...

a)

Simply drag it back into the toolbox to put it away

b)

Leave it there. You may need it later

c)

See if you can make additional code to use it up

d)

Click the reset button and start over

32.

This image portrays the puzzle in the video. What is the name of this puzzle?

a)

Debugging with Scrat

b)

Programming with Angry Birds

c)

Collecting Treasure with Laurel

d)

Creating Art with Code

33.

Method of problem-solving to find digital solutions

a)

Decompose

b)

Computational thinking

c)

Programming

34.

A Theme that is repeated many times.

a)

Programming

b)

Repeat

c)

Pattern

35.

A part of the program that does not work correctly.

a)

Bug

b)

Break

c)

Loop

36.

To remove details from the solution so that it can work for many problems.

a)

Reaction

b)

Abstraction

c)

Subtraction

37.

To break a hard problem up into smaller and easier problems.

a)

Compose

b)

Loop

c)

Decompose

38.

The action of doing something over and over again.

a)

Looping

b)

Bugging

c)

Programming

39.

A list of steps to finish a task.

a)

Repeated

b)

Algorithm

c)

Guidelines

40.

A placeholder for a piece of information that can change.

a)

Loop

b)

Variable

c)

Function

41.

Look at the puzzle and the code below. What can you fix in the code to help the bird get to the pig?

a)

Remove a move forward block

b)

Add a move forward block

c)

Change the first turn block to left

d)

Change the second turn block to left

42.

Can this code be written better?

a)

Yes, by using loops (repeat blocks)

b)

No, this is the best way to right this code

43.

How long are the sides of this shape?

a)

2 pixels

b)

120 pixels

c)

150 pixels

d)

Purple pixels

44.

How do you start a puzzle over?

a)

click backspace

b)

click reset

c)

click run

45.
A PROGRAM is a series of  _____________ for a computer or device to follow
a)
instructions
b)
windows
c)
suggestions
d)
voices
46.

A way of representing information using only two options. They way computers store information.

a)

binary

b)

code

c)

sequencing

d)

while loop

Similar Resources on Wayground

Ms.Word

50 questions

Ms.Word

quiz

Worksheet

•

7th Grade

Remidial Analisis Data -Bank Soal

44 questions

Remidial Analisis Data -Bank Soal

quiz

Worksheet

•

7th Grade

Functions, Formulas, OH My

50 questions

Functions, Formulas, OH My

quiz

Worksheet

•

6th - 8th Grade

ICT in society

50 questions

ICT in society

quiz

Worksheet

•

5th Grade - University

ôn tập môn tin lớp 5

42 questions

ôn tập môn tin lớp 5

quiz

Worksheet

•

5th Grade

ÔN TẬP KIỂM TRA GIỮA KÌ 1-LỚP 7-NH 2021-2022

45 questions

ÔN TẬP KIỂM TRA GIỮA KÌ 1-LỚP 7-NH 2021-2022

quiz

Worksheet

•

6th Grade

Technology: Final exam review

44 questions

Technology: Final exam review

quiz

Worksheet

•

7th - 8th Grade

IC3 GS6-LV1-MODUL 1

42 questions

IC3 GS6-LV1-MODUL 1

quiz

Worksheet

•

6th - 8th Grade