Font size
WorksheetsY7 - Summer ROA
Total questions: 64
Worksheet time: 33mins
Which term describes a set of rules that computers on a network use to communicate with one another?
Method
Protocol
Instruction
Conduct
Which of the below is a valid protocol for email addresses?
An '&' character must be used
An '@' character must be used
A '/' character must be used
An '*' character must be used
This hardware device connects a number of computers together on a local network. This hardware device has ports that allow cables to be plugged in from each connected computer. What is the device?
Hub
Computer network
Network cable
Router
What is the name of a piece of hardware that is used to connect different devices together? This hardware is often made up of a number of wires.
Protocol
Server
Network cable
Hub
A common function of this hardware device is to join a home network to the internet via your internet service provider (ISP). What is the device?
Router
Server
Network cable
Hub
This device is often described as a powerful computer that provides services. One example of a service that it can provide is shared access to files such as text, images, sound, or video. What is the device?
Router
Hub
Network
Server
Which one of the below is an example of a wired communication technology?
4G
Network cable
WiFi
Bluetooth
Which term describes the amount of data that can be moved from one point on a network to another point in a given time?
Bandwidth
Speed
Flow
Bits per second
Which of the activities below requires downloading information to your computer?
Putting a video on YouTube
Adding an image to a post on your social media feed
Browsing a web page
Posting a comment on Snapchat
Which of the below describes the term 'buffering'?
Your device is making a connection to the internet
Data is arriving at your device at a slower rate than it is being processed
Data is sent from your device to another device across the internet
Data is arriving at your device at a faster rate than it is being processed
Which of the following is an advantage of a wired network?
No trailing wires
It allows portability
It is quick and cheap to connect new devices
Better security
Which term is described as a 'worldwide network of computers made up of cables, routers, and other pieces of hardware used to connect devices together'?
World Wide Web
Internet
Local network
4G
Which of the following is the address used to uniquely identify every device on the internet?
Machine address
Postal address
IP address
MAC address
Large amounts of data sent across the internet are split into smaller units. What is the name of these smaller units of data?
Letters
Parcels
Packages
Packets
Which of the following best describes an IP address?
4 numbers ranging between 0 and 255, separated by dots
8 numbers ranging between 0 and 10, separated by '@' signs
3 numbers ranging between 0 and 10, separated by dots
4 numbers ranging between 0 and 100, separated by dashes
Which protocol splits messages across the internet into smaller pieces of data?
IP
HTTP
HTTPS
TCP
Which of the following describes the World Wide Web?
Two or more computers connected together
A worldwide network of computers
Websites, web pages, and links
A very powerful computer that provides services
Which of the following internet services allows voice data to be sent over the internet?
VoIP
WWW
Instant messaging
Which of the following is used to describe taking everyday items and connecting them to the internet?
Web of Items
Online Devices
Internet of Things
Smart Devices
Which of the following is a piece of software used to view information on the World Wide Web?
Web server
Web browser
Web page
URL
Which of the following stores websites on the internet?
Web server
Web browser
Web page
URL
Which of the following best describes the purpose of websites that use a ".edu" top-level domain?
Sites used to inform and provide public services
Sites used by non-profit companies such as charities
Sites ranging from nursery schools' to universities'
Sites likely to promote something
Which of the following website activities should make use of HTTPS?
Checking the latest sporting news
Registering your details on a new social media site
Researching a holiday abroad
Watching a video
What is a vertical section of a spreadsheet called?
row
cell
rank
column
What is a horizontal section of a spreadsheet called?
(a)
What is an individual box where a row and column meet within a spreadsheet called?
square
range
reference
cell
rectangle
Which of the following is the correct way to type the location of a cell?
8B
B8
8-B
BB-8
The location of a cell on a spreadsheet is a column letter followed by a row number. What is this called?
Cell Range
Active Cell
Cell Reference
Row
What is the cell range in this diagram?
A1:F1
A1:A8
A1:F8
A1:1A
Which of the following is an absolute cell reference?
A2
$A$2
#A#2
A:2
What will clicking on the icon in the image do?
Make the text size bigger
Make the text colour red
Make the cell background colour red
Underline the text
Which format is best suited to display a whole number including the thousands (comma) separator?
Percentage
Number
General
Currency
All formulas in spreadsheets begin with which of the following symbol?
+
-
=
%
!
Which of these symbols is used for dividing in a spreadsheet?
\
/
*
|
The following formula =6>8 is inserted in to a cell. What will be shown in the cell when this formula is executed?
There is a mistake in the formula
6>8
TRUE
FALSE
Which formula is incorrect?
=C5<>C7
=A4>5
=C2!C3
=A3=A4
How would we type the formula to add the June and July Budgets?
=June+July
=1200+1500
=D10+D11
=C10+C11
What is the difference between a formula and a function?
A function deals with a whole range of cells in one go and has a function name at the beginning, whereas a formula lists each cell individually and puts the correct mathematical operator between them
A formula deals with a whole range of cells in one go and has a function name at the beginning, whereas a function lists each cell individually and puts the correct mathematical operator between them
There is no difference between a formula and a function, they are the same
A formula is something we use in maths, whereas a function is something we use in ICT
What word is used to describe re-organising the order of data in spreadsheets?
search
sort
fill
filter
Choose the correct word for the following: _______ are used to find all records matching a certain criteria at one place.
Sorting
Filters
AutoSum
Searches
What does ascending order mean?
It is the order of my ancestors
Starting at the bottom and going up. For example: 0, 1, 2, 3, 4
Starting at the top and going down. For example: 10, 9, 8, 7, 6
There is no such thing as ascending order
While creating a graph, the main reason to include logical title and axis labels is that
Excel will not save your graph without them
They make your graph look nice
They make your graph to be meaningful to other people
There is no reason to include them
Looking at the image, what part is circled in red?
Chart
Chart Title
Data Labels
Legend
What will happen when the green flag is clicked
the sprite will rotate 15 times
the sprite will rotate 10 times
the sprite will move 15 spaces
the sprite will move 10 spaces
What does this block do?
It writes notes for you
It plays a musical note
It beats the drum
What does this block do?
It allows sprites to talk to each other
It plays music on the radio
It writes a message in a bottle
What is the variable in this code?
keep score
random position
edge
What does this code do?
It clicks the sprite forever
It allows you to draw shapes
It generates sprites forever
What does this block do?
Repeat the code forever
Repeat the code 2 times
Repeat the code until touching the sprite
Which of the following sections of code will make the script follow the mouse pointer around the screen?
Study the script above which has been set up for your sprite. Which direction will your sprite move in if you press the up arrow?
Up
Down
Left
Right
What is a computer network?
Two or more computers connected together
A single computer
A powerful computer that provides a service
A set of rules
