WorksheetsKS2 Computing/ICT Quiz
Total questions: 49
Worksheet time: 25mins
What is a spreadsheet primarily used for?
Writing essays
Organizing and calculating data
Drawing pictures
Playing games
Which symbol is used to start a formula in most spreadsheet programs?
=
+
#
@
What is a cell in a spreadsheet?
A type of formula
A single box where a row and column meet
A type of chart
A type of font
Which function adds up a range of numbers in a spreadsheet?
AVERAGE
SUM
COUNT
MAX
What is the name of the horizontal sections in a spreadsheet?
Columns
Rows
Cells
Sheets
Which of the following is an example of spreadsheet software?
Microsoft Word
Microsoft Excel
Adobe Photoshop
Google Slides
What does the formula =A1+B1 do?
Multiplies the values in A1 and B1
Adds the values in A1 and B1
Subtracts the value in B1 from A1
Divides the value in A1 by B1
What is a chart in a spreadsheet used for?
To write text
To visualize data
To create formulas
To delete data
Which of the following is NOT a type of chart in spreadsheets?
Pie chart
Bar chart
Line chart
Paragraph chart
What does the term 'cell reference' mean?
The name of a spreadsheet
The address of a cell, such as A1 or B2
A type of formula
A type of chart
What is selection in programming?
Repeating a set of instructions
Making decisions based on conditions
Storing data
Drawing shapes
Which of the following is an example of a selection statement?
IF
FOR
ADD
What does the IF statement do?
Repeats a block of code
Makes a decision based on a condition
Adds two numbers
Deletes data
In programming, what is a condition?
A type of loop
A true or false statement
A type of variable
A type of output
Which symbol is often used to compare two values in programming?
+
=
==
#
What is the purpose of the ELSE statement?
To repeat a block of code
To provide an alternative action if the IF condition is false
To stop the program
To add two numbers
Which of the following is a logical operator used in selection?
AND
ADD
LOOP
What does the NOT operator do?
Reverses the condition
Adds two numbers
Repeats a block of code
Prints a message
In programming, what is a nested IF statement?
An IF statement inside another IF statement
A loop inside a condition
A type of variable
A type of output
Which of the following is an example of a selection structure?
IF age > 18 THEN print 'Adult'
FOR i = 1 TO 10
PRINT 'Hello'
ADD 5 + 5
What is iteration in programming?
Making decisions
Repeating a set of instructions
Storing data
Drawing shapes
Which of the following is an example of an iteration statement?
FOR
IF
ADD
What does a FOR loop do?
Repeats a block of code a specific number of times
Makes a decision
Adds two numbers
Deletes data
What is a WHILE loop?
A loop that repeats while a condition is true
A loop that repeats a specific number of times
A type of variable
A type of output
Which of the following is an example of an infinite loop?
WHILE True
FOR i = 1 TO 10
IF x > 5
PRINT 'Hello'
What is the purpose of a loop counter?
To count the number of times a loop runs
To make decisions
To store data
To draw shapes
Which of the following is NOT a type of loop?
FOR
WHILE
IF
DO...WHILE
What does the BREAK statement do in a loop?
Stops the loop early
Repeats the loop
Makes a decision
Adds two numbers
What is the purpose of the CONTINUE statement in a loop?
Skips the rest of the loop and starts the next iteration
Stops the loop
Makes a decision
Adds two numbers
Which of the following is an example of iteration?
FOR i = 1 TO 5 PRINT i
IF x > 10 PRINT 'Yes'
PRINT 'Hello'
ADD 5 + 5
What is input in computing?
Data sent to a computer
Data sent from a computer
A type of storage
A type of software
Which of the following is an example of an input device?
Keyboard
Monitor
Printer
Speaker
What is output in computing?
Data sent from a computer
Data sent to a computer
A type of storage
A type of software
Which of the following is an example of an output device?
Monitor
Keyboard
Mouse
Scanner
What does I/O stand for in computing?
Input/Output
Internet/Online
Internal/Operation
Input/Operation
Which of the following is both an input and output device?
Touchscreen
Printer
Keyboard
Monitor
What is the purpose of a printer?
To display output on paper
To input data
To store data
To process data
Which of the following is NOT an input device?
Speaker
Mouse
Scanner
Microphone
What is the purpose of a microphone?
To input sound
To output sound
To store data
To process data
Which of the following is an example of output?
A printed document
Typing on a keyboard
Scanning a photo
Clicking a mouse
What does WWW stand for?
World Wide Web
World Wide Word
Web Wide World
Wide World Web
What is a web browser?
Software used to access the internet
A type of computer
A type of printer
A type of keyboard
Which of the following is an example of a web browser?
Google Chrome
Microsoft Word
Adobe Photoshop
Windows
What is a URL?
The address of a webpage
A type of computer
A type of software
A type of printer
What does HTML stand for?
HyperText Markup Language
HyperText Machine Language
HighText Markup Language
HyperText Model Language
What is the purpose of a search engine?
To find information on the internet
To create websites
To store data
To print documents
Which of the following is an example of a search engine?
Microsoft Word
Adobe Photoshop
Windows
What is a hyperlink?
A clickable link that takes you to another webpage
A type of computer
A type of software
A type of printer
What is the purpose of a firewall?
To protect a computer from unauthorized access
To create websites
To store data
To print documents
