WorksheetsYear 9 ICT Summer Exam
Total questions: 68
Worksheet time: 37mins
What is the name of the spreadsheet package we have been using?
Google Slides
Microsoft Word
Microsoft Excel
Microsoft Access
What is the term used for each box in a spreadsheet?
Cell
Box
Field
Record
What is the term used for cells which appear going across the spreadsheet?
Column
Record
Field
Row
What is the term used for cells which appear going up and down the spreadsheet?
Field
Row
Column
Record
What symbol is used to multiply?
/
-
+
*
How must a cell containing a formula start?
SUM
=
+
( )
What function is used to add more than 2 cells?
+
=
SUM
( )
What word is used to describe re-organising the order of data?
Search
Sort
Fill
Filter
What symbol is used to make a cell reference absolute?
Dollar $
Exclamation mark !
Ampersand &
Colon :
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Because bar charts are taught early and so everyone understands them.
Because they don't require you to enter any formula.
Because the data is presented in a more visual way.
What is a group of cells in a spreadsheet called?
Cell range
Cell reference
Formula
Table
A single page in a Spreadsheet is called a:
Worksheet
Workbook
Data
Table
To find a value associated with another value we can use the formula...
VLOOKUP
MAX
SEARCH
MATCH
In the formula
=VLOOKUP(A1, A2:D10, 3)
What cell contains the value being searched for in the table
A2
A1
D10
3
Which formula would count the number of cells containing the word Yes in the D column?
=COUNT("Yes",D:D)
=COUNTIF("Yes",D:D)
=COUNT(D:D,"Yes")
=COUNTIF(D:D,"Yes")
You are creating a spreadsheet to calculate the cost of a party. You want to know how much you will spend on food. Why is it better to use a formula rather than working out the total yourself?
It will make it easier if you want to rearrange your spreadsheet
A formula will instantly calculate the change in cost if you update the price of the food
The spreadsheet will look tidier if your use a formula
It is always faster to calculate the answer in your head, you should not use a formula.
It is possible to automatically change how a cell looks based on the contents of the cell
TRUE
FALSE
What is the name of this gate?
AND
OR
NOT
What is the name of this gate?
AND
OR
NOT
What is the name of this gate?
AND
OR
NOT
Is this Truth table for AND Gate correct?
Yes
No
Is this Truth table for OR Gate correct?
Yes
No
Is this Truth table for NOT Gate correct?
Yes
No
What will the OR gate's output be?
0
1
What will the NOT gate's output be?
0
1
Convert this 4-bit binary number to denary
8
5
6
4
Convert this 4-bit binary number to denary
12
13
10
11
Convert this 8-bit binary number to denary
53
58
64
52
Convert this 8-bit binary number to denary
145
130
135
134
Convert 14 into binary
1010
1110
1111
1011
Convert 15 into binary
1010
1110
1111
1011
Convert 30 into binary
0001 1110
0011 0001
0011 0011
0111 1111
Binary uses electrical signals
True
False
Each 1 and 0 represented in binary is called a bit
True
False
What is a Sprite?
A object or character in a video game
The Code of Ethics
The background of a video game
The language used in video games
Which career allows you to create and design video games?
Video Game Tester
Lawyer
Video Game Developer
Programmer
Which of the following do we use in class to create video games?
Game Maker Studio 2.0
Scratch
Canvas
Google Doodle
How do you make a sprite in Game Maker Studio 2.0?
Learn Game Maker Language (GML)
Open up a room
Right click on sprite in the right panel and create a sprite
Create a squence
What is the plan/layout to create a rough draft of a video game?
Video Game Designer
Game Tester
Video Game Demo
Storyboard
In GameMaker, what is an event?
A type of sprite
A function that plays music
A trigger that causes an object to perform an action
A background image
What is the primary purpose of a sprite in GameMaker?
To store game levels
To represent visual elements like characters and objects
To manage game logic
To handle sound effects
Which of the following best describes an object in GameMaker?
A sound file
A collection of events and actions
A background image
A variable type
What is the role of a room in GameMaker?
To store variables
To define the game world or level layout
To create sound effects
To manage user input
What is the purpose of using variables in GameMaker?
To create sound effects
To store and manipulate data
To design game levels
To draw graphics
Which event would you use to check for a collision between two objects in GameMaker?
Create Event
Step Event
Collision Event
Draw Event
What is the function of the Draw Event in GameMaker?
To handle object creation
To update game logic
To render graphics on the screen
To manage sound playback
An Antivirus protects you from all attacks
True
False
What does malicious mean?
Something intended to do harm
Something that makes you ill
Something good
Tasty
What is the term for computer programs that attack your computer?
Malware
DangerDroids
RudeBots
Dangerware
Who should know your passwords?
Only you!
Your best friends
Anyone
What is malware?
Malicious software
Software made by a company called Mal
Malicious hardware
Clothes that hackers wear
What is a Trojan malware?
A type of malware that appears to be a legitimate program, but actually causes harm
A type of malware that deletes programs on the system each time replacing them with itself
A type of malware that spies on users without their knowledge
A type of malware that removes and sends all of your files to a third party, over time so you don't notice
The attempt to acquire sensitive information such as usernames, passwords, and credit card details by pretending you are a trustworthy entity in an electronic communication is known as?
Converting
Hacking
Phishing
Fishing
What should a strong password include?
At least one upper case letter
Short, easy to guess words
Date of birth
At least one number
At least 8 characters
an occasion when private information can be seen by people who should not be able to see it
data breach
data breech
data disruption
A network security device that monitors incoming and outgoing network traffic and decides whether to allow or block specific traffic based on a defined set of security rules.
Anti-virus
Firewall
Encryption
Malware
Which of the following passwords meet password requirements?
p455w0rd1
!@#$%^&*
akHGksmLN
uP1b@!Si7p
The mouse on your computer screen starts to move around on its own and click on things on your desktop. What do you do?
Turn your computer off
Disconnect your computer from the network
Unplug your mouse
Run anti-virus
All of the above
The technology and process that is designed to protect networks and devices from attack, damage, or unauthorized access
Cyber Security
White Hat Hacker
Domain Name Server
All of the above
What are the motives behind cyber crime?
Demanding ransom
Propagating religious or political beliefs
Financial loss to the target
Information thefts and manipulating data
All of the above
Individuals with wide range of skills motivated by religious or political beliefs to create fear by large- scale disruption of computer networks
State sponsored hacker
Hactivist
Cyber terrorist
Black hat hacker
Unauthorized access to control over computer network security systems
Security
Hacking
Surfing
Dancing
Detecting Vulnerabilities in a computer system/network also includes employee behaviours and procedures?
True
False
Businesses, Banks, Shops, Schools and Exam Boards all keep data on you and are required to keep it safe?
True
False
DDoS stands for...
Destroyed Denial of Service
Distributed Delivery of Service
Delivered Denial of Service
Distributed Denial of Service
