WorksheetsYear 7 Revision Quiz Units 7.1-7.3
Total questions: 28
Worksheet time: 14mins
A) Name
B) Address
C) Phone Number
D) None of the above
What is an example of a primary source of data?
A newspaper article you read.
A questionnaire you carried out yourself.
Wikipedia.
Rumours you've heard.
Which of the following is a correct cell reference?
G6
6G
#6
*6
What is a cell?
A vertical line of items within a spreadsheet.
A location where malicious programs are isolated when quarantined.
A singular item within a spreedsheet.
A horizontal line of items within a spreadsheet.
What is meant by formatting in spreadsheets?
Laying out the cells in a spreadsheet in alphabetical order.
Resetting a spreadsheet and removing all of the content.
Ordering the items in a spreadsheet based on conditions.
Changing the appearance of cells.
What is conditional formatting?
Determining the order of cells using conditions.
Scrambling the contents of a spreadsheet so only people with the key can read it.
Determining the appearance of cells using conditions.
Comparing 2 rows and swapping them if a condition is met and vice versa.
What type of graph is this?
Pie chart
Line graph
Bar chart
Pictograph
What type of graph is this?
Pie chart.
Bar chart.
Pictograph.
Line graph.
What is a formula (in reference to spreadsheets)?
Another name for a condition that decides the appearance of a cell.
The plan for how a spreadsheet is to be laid out during creation.
A mathematical expression which operates on the values of cells.
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
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
A ‘*’ 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
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
Server
Network cable
Hub
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 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
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 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 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
