wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 9 Spitwa

Total questions: 196

Worksheet time: 2hrs 54mins

Name
Class
Date
1.
A single page or computerized spreadsheet in Excel
a)
Data group
b)
Workbook
c)
Worksheet
d)
Chart
2.
These appear vertically and are identified by letters at the top of the worksheet window.
a)
Text
b)
Data sets
c)
Rows
d)
Columns
3.
Appear horizontally and are identified by numbers on the left side of the worksheet window.
a)
Text
b)
Data sets
c)
Rows
d)
Columns
4.
The intersection of a column and row which forms the basic unit of an excel spreadsheet where data is entered.
a)
Cell
b)
Name box
c)
Cell reference
d)
Data box
5.
The cell surrounded by a thick green border in which data can be entered.
a)
Range
b)
Active cell
c)
Marquee
d)
Name box
6.
Stored in the individual cells of a worksheet.
a)
Numbers/Values
b)
Stuff
c)
Text/Labels
d)
Data
7.
Displays the cell reference of the active cell. Can also be used to navigate to a cell.
a)
Name box
b)
Range
c)
Formula bar
d)
Cell
8.
Displays the data stored in the active cell. Displays a formula when the cell contains a calculated value. It can also be used to enter or edit data in a cell.
a)
Name box
b)
Function bar
c)
Formula bar
d)
Function library
9.
Any set of characters containing a letter, hyphen, or space. Used to place titles on the worksheet, columns, and rows.
a)
Formula
b)
Text/Labels
c)
Numbers/Value
d)
Data
10.
In Excel this can only contain the following characters: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, +, -, ( ), /, comma, period, $, %, E, and e.
a)
Formula
b)
Text/Labels
c)
Numbers/Value
d)
Functions
11.
Prewritten formulas available in Microsoft Excel that perform calculations on number (values) in your worksheet.
a)
Formulas
b)
Absolute reference
c)
Functions
d)
Name box
12.
A mathematical equation that will calculate a new value from values currently in the worksheet.
a)
Formula
b)
Active cell
c)
Function
d)
Numbers/Values
13.
Identifies the location of a cell in a worksheet using the intersection of the column letter and row number. Sometimes known as the cell address.
a)
Data
b)
B20
c)
Marquee
d)
Cell reference
14.
A group of cells that have been selected or highlighted.
a)
Data set
b)
Formatting
c)
Marquee
d)
Range
15.
A group of selected cells that touch each other.
a)
Non-adjacent range
b)
Relative reference
c)
Adjacent range
d)
Cell style
16.
Includes two or more adjacent ranges and/or selected cells.
a)
Marquee
b)
Non-adjacent range
c)
Adjacent range
d)
Worksheet
17.
In a range reference this symbol identifies a nonadjacent range.
a)
Colon
b)
Question mark
c)
Comma
d)
Period
18.
In a range reference this symbol identifies an adjacent range.
a)
Colon
b)
Question mark
c)
Comma
d)
Period
19.
A moving border that surrounds cells when a range has been selected for a function or copying.
a)
Borders
b)
Marching ants
c)
Selection
d)
Marquee
20.
Specifies where data is lined up within the cell.
a)
Alignment
b)
Placement
c)
Right
d)
Left
21.
Moves data to a new line when the cell is not wide enough to display all the contents.
a)
Merge and center
b)
Wrap text
c)
Alignment buttons
d)
Row height
22.
Combines multiple cells into one cell.
a)
Adjacent range
b)
Merge
c)
Alignment
d)
Wrap text
23.
Done to emphasize certain entries and make the worksheet easier to read and look more professional.
a)
Currency style
b)
Cell styles
c)
Alignment
d)
Formatting
24.
The small black square located in the lower right corner of the heavy border around the active cell.
a)
Border box
b)
Fill handle
c)
Sizing handle
d)
Range
25.
Excel adjusts the row or column references when copying a formula or function relative to the direction of the copying.
a)
Mixed reference
b)
Absolute reference
c)
Relative reference
d)
Fill handle
26.
Displays the value of a cell with a thousands separator and inserts a comma every three positions to the left of the decimal point and displays numbers to the nearest hundredths (cents). Applies the Accounting style without a currency symbol.
a)
Percent style
b)
Comma style
c)
Currency style
d)
Dollar sign style
27.
Determines the best width for a column or the best height for a row.
a)
Column width
b)
Autofit
c)
Row height
d)
Worksheet
28.
A collection of pre-set formatting characteristics you apply to a cell or range of data.
a)
Fill style
b)
Style gallery
c)
Format tool
d)
Cell style
29.
Recognizes patterns in your data and will finish tedious tasks for you.
a)
Auto complete
b)
Flash fill
c)
F4
d)
Data set
30.
Displays the lowest value in a range.
a)
Max function
b)
IF function
c)
Min function
d)
Sum function
31.
Displays the highest value in a range.
a)
Max function
b)
IF function
c)
Average function
d)
Sum function
32.
Used to specify an absolute reference in a formula.
a)
?
b)
%
c)
!
d)
$
33.
Used to assign a floating dollar sign that displays immediately to the left of the first digit in the value no spaces.
a)
Accounting style
b)
Currency style
c)
Percent style
d)
Comma style
34.
Used to change the order of operations in a formula.
a)
Colon
b)
Parentheses
c)
Operators
d)
Dollar sign
35.
A button that removes a decimal place each time it is clicked.
a)
Comma style
b)
Increase decimal
c)
Currency style
d)
Decrease decimal
36.
Allows you to keep a cell reference constant when it copies a formula or function.
a)
Relative reference
b)
Parentheses
c)
Freeze reference
d)
Absolute reference
37.
Displays the cell reference of the active cell. Can also be used to navigate to a cell.
a)
Name box
b)
Wrap text
c)
Fill handle
d)
Comma style
38.
Contained inside round parentheses in functions and tells Excel what data is to be used in the calculation.
a)
Values/Numbers
b)
Range
c)
Function
d)
Arguments
39.
Button used to display additional decimal places in a cell.
a)
Number format
b)
Decrease decimal
c)
Increase decimal
d)
Comma style
40.
Used to assign a fixed dollar sign to the far left in the cell, often with spaces between it and the first digit.
a)
Currency style
b)
Dollar sign style
c)
Accounting style
d)
Comma style
41.
You can press this key to change a selected cell reference from relative, to absolute, or mixed.
a)
F1
b)
F2
c)
F3
d)
F4
42.
Sums the numbers in a range and then divides the sum by the number of nonzero cells.
a)
Max function
b)
Sum function
c)
Average function
d)
Min function
43.
What would the cell reference B20 look like in a formula if you wanted to make sure the column reference does not change but the row reference does when you copy the formula.
a)
B$20
b)
B20
c)
$B20
d)
No answers are correct
44.
What would the cell reference B20 look like in a formula if you wanted to make sure the column reference changes when you copy the cell but the row reference does not when you copy the formula.
a)
B$20
b)
B20
c)
$B20
d)
No answers are correct
45.
What displays in a cell when the column is not wide enough to display the contents of the cell.
a)
REF!
b)
**************
c)
NAME!
d)
##########
46.
What are the three parts of a function?
a)
Equal sign, Operator, Range
b)
Equal sign, Parentheses, Arguments
c)
Equal sign, Function name, Arguments
d)
Equal sign, Function name, Range reference
47.
The range reference (D12:G12) refers to
a)
Cells G10 and J20
b)
Columns D, E, F, G and Row 12
c)
Columns D and G and Row 12
d)
None of the answers are correct
48.
The range reference (D23,G26) refers to
a)
Columns D, E, F, and G and Rows 23-26
b)
Columns D, E, F, and G and Rows 23 and 26
c)
Cells D23 and G26
d)
None of the answers are correct
49.
Recognizes patterns in your data and will finish tedious tasks for you.
a)
Flash fill
b)
Fill handle
c)
Copy tool
d)
Fill series
50.
A cell reference with only one dollar sign before either the column or row.
a)
Relative reference
b)
Mixed reference
c)
Absolute reference
51.
You can center text across several columns using the ________ button.
a)
Align
b)
Merge & Center
c)
Merge
d)
Center
52.
The SUM function that adds the numbers in the range J5:J10 is _____
a)
SUM(J5:J10)
b)
(J5:J10)SUM
c)
=SUM(J5:J10)
d)
=(J5:J10)SUM
53.
Which cell reference in the formula =(C4+D4)*$K$36 is absolute?
a)
$K$36
b)
D4
c)
C4
54.
Which of the following is a an example of a relative reference?
a)
$D$5
b)
$D5
c)
D$5
d)
D5
55.
When selecting a non-adjacent renage in Excel you hold down the _____ key.
a)
Shift
b)
Ctrl
c)
Alt
d)
Tab
56.
This tool in Excel allows you to quickly copy formulas, functions, text, values, and series to adjacent cells.
a)
Copy tool
b)
Fill handle
c)
Auto copy
d)
Clipboard
57.
This function checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.
a)
AVERAGE Function
b)
PMT Function
c)
IF Function
d)
SUM Functon
58.
This function calculates the payment for a loan based on constant payments and a constant interest rate.
a)
MAX Function
b)
PMT Function
c)
IF Function
d)
MIN Function
59.

Which of these are potential health risks due to prolonged ICT usage? (select all the correct answers)

a)

Broken finger

b)

Repetitive Strain Injury

c)

Sprained ankle

d)

Back and neck ache

e)

Eye strain

60.

Which of this is a disadvantage to having more microprocessor controlled devices in the home?

a)

Free up more time

b)

More comfortable

c)

Unhealthy lifestyles

d)

Increase efficiency

61.

Adrian and John both take turns working as a programmer in SoftExcel. Adrian works in the morning and John takes over from him in the afternoon. What sort of working pattern is this called?

a)

Flexible working

b)

Compressed hours

c)

Part-time working

d)

Job sharing

62.

Which of these are advantages on employment brought forth by ICT? (select all the correct answers)

a)

Safer

b)

Job losses

c)

More efficient

d)

Cleaner

e)

More lower paying jobs

63.

RSI usually causes injury on the

a)

Fingers

b)

Eyes

c)

Back

d)

Neck

64.

RSI stands for

a)

Ready Set Injury

b)

Repeat Strain Injury

c)

Repetitive Strain Injury

d)

Random Strain Injury

65.

Which the following employment area is negatively affected by ICT?

a)

Software Industry

b)

Manufacturing Industry

c)

IT Security

d)

Robotic Engineers

66.

Which is a better way to prevent eye strain from prolonged use of the computer?

a)

Wear sunglasses

b)

Use a comfortable chair

c)

Look away from the screen or close your eyes at regular intervals

d)

Don't use a computer

67.

Rebecca only works 3 days in a week but she works longer hours each day to ensure she hits the 40-hour work week.

a)

Part-time working

b)

Compressed hours

c)

Job sharing

d)

Flexible hours

68.

Which of these are advantages of a robot vs human? (select all the correct answers)

a)

They are expensive

b)

Doesn't get bored from repetitive tasks

c)

Higher productivity

d)

Can work long hours without rest

69.

Which of these are NOT potential health risks caused by prolonged use of ICT? (select all the correct answers)

a)

Stress

b)

Trigger finger

c)

Kidney failure

d)

Pneumonia

70.

Unlike his co-workers, Brian only works 4 hours a day instead of the normal 8. Which type of working pattern is this?

a)

Part-time working

b)

Job sharing

c)

Compressed hours

d)

Flexible working

71.
What is the health effect  to us when we use a computer for many hours???
a)
Back and Neck Ache
b)
Heart disease
c)
Disfigurement
d)
Kidney failure
72.
What is the better way to prevent eye strain???
a)
Blind yourself
b)
Don't use computer
c)
Look away from the monitor at regular intervals – re-focus on distant or close objects to exercise the muscles in the eye.
d)
use comfortable chair
73.
Why do hackers hack???
a)
For fun
b)
Breaking in to access data, usually because the data has value.
c)
They have nothing to do
d)
they want to take revenge
74.
How can a Computer be Protected from Hacking?  
a)
 Place a firewall between your computer and any network
b)
Use strong passwords to protect your user login account
c)
Use weak passwords to protect your user login account
d)
Always lock your computer when away
75.
What is Malware?  
a)
Malware is short for malicious software.Malware is the name given to any software that could harm a computer system, interfere with a user's data.
b)
Malware is the software used or created to upgrade the computer operation....
c)
It helps in running your application smooth
d)
its needed to install the hardwarfe
76.
What is a Computer Virus?
a)
Virus is a software that help your computer to prevent a malware infecting your computer.
b)
A computer virus is a piece of software that can infect a computer (install itself) and copy itself to other computers
c)
A program to which save you from hackers
d)
For speeding up your system
77.
What are the ways to prevent a virus infecting your computer???
a)
Don’t open e-mail attachments
b)
Install anti-virus software and keep it up-to-date...
c)
Download and install software from the Internet that you dont know.
d)
use pen drive to install any program
78.
Under the laws of copyright, people must not do???
a)
Copy the software for other people
b)
Lend the software to other people
c)
Rent the software to other people
d)
above all
79.
An example of batch processing would be:
a)
A student checking how many library books they have out on loan
b)
A person booking a holiday using a travel website
c)
A gas company printing customer bills over night.
d)
A doctor checking patent information with the hospital computer system
80.
Which of below will not effects by computer.
a)
 Eye-strain
b)
headaches
c)
Stomach ache
d)
backache
81.
Areas of Increased Employment due to ICT
a)
Manufacturing
b)
Retail
c)
Office Work
d)
Computer Programmers
82.
Microprocessor-controlled devices in the home advantage
a)
People can become over reliant on these devices and can become lazy
b)
Manual household skills are lost
c)
Tasks do not need to be done manually 
d)
•Can lead to unhealthy eating due to dependency on ready meals.
83.
13.A worm is a
a)
A slimy pink thing that lives in dirt
b)
Pieces of malicious code that make copies of themselves and spread through computers without human interaction.
c)
An unsolicited email message.
d)
a tiny program when clicked open different pages on web browser
84.
A strong password should contain:
a)
Both uppercase and lowercase letters.
b)
A word that is easy to remember, such as the name of a pet.
c)
At least 8 characters, and a combination of letters, numbers, and characters
d)
spaces
85.
What is a firewall?
a)
A wall that is reinforced and cannot catch on fire.
b)
A program that protects against viruses.
c)
A filter for an internet connection that monitors outgoing and incoming activity
d)
A program for checking internet connection problems
86.
Which is the sub category of stock control system according to mind maps?
a)
simulate how a device can work using simulation program
b)
application using sensors
c)
Using barcodes
d)
medical diagnosis
87.
Chess game is an example of
a)
Virus
b)
Worm
c)
Gps monitoring
d)
Expert system
88.
For data handling we take surveys with the help of
a)
MICR
b)
Bar code reader
c)
OMR and OCR 
d)
RFID devices
89.
Which one is not the Advantage of ICT Effect on employment?
a)
Machines do not take holidays
b)
Safe working enviornment
c)
Fewer manual tasks
d)
Workers getting replaced
90.
Send victim a fake site to enter personal information
a)
Pharming
b)
Spam
c)
Spyware
d)
Phishing
91.

A manufacturing company has decided to use robots on the production line.


By placing ticks in the boxes on the right, indicate three disadvantages to the manufacturers of using robots on the production line.

a)

Redundancy payments to dismiss workers can be expensive

b)

Items produced are not made to a consistent standard

c)

Robots are unable to think for themselves and can repeat errors

d)

Remaining workers will need to be paid higher wages.

e)

Robots are expensive to buy and maintain

92.

Job losses are one of the disadvantages to workers of introducing ICT into the work place.


Describe three positive effects of introducing ICT into the workplace. Please number your answers. (6 pts)

4 lines
93.

Areas of Increased Employment due to ICT

a)

Manufacturing

b)

Retail

c)

Office Work

d)

Computer Programmers

94.

Microprocessor-controlled devices in the home advantage

a)

People can become over reliant on these devices and can become lazy

b)

Manual household skills are lost

c)

Tasks do not need to be done manually

d)

Can lead to unhealthy eating due to dependency on ready meals.

95.
What is the better way to prevent eye strain???
a)
Blind yourself
b)
Don't use computer
c)
Look away from the monitor at regular intervals – re-focus on distant or close objects to exercise the muscles in the eye.
d)
use comfortable chair
96.

What is the health effect to us when we use a computer for many hours???

a)

Back and Neck Ache

b)

Heart disease

c)

Disfigurement

d)

Kidney failure

97.

Which of these are potential health risks due to prolonged ICT usage? (select all the correct answers)

a)

Broken finger

b)

Repetitive Strain Injury

c)

Sprained ankle

d)

Back and neck ache

e)

Eye strain

98.

Which of this is a disadvantage to having more microprocessor controlled devices in the home?

a)

Free up more time

b)

More comfortable

c)

Unhealthy lifestyles

d)

Increase efficiency

99.

Which of these are advantages on employment brought forth by ICT? (select all possible correct answers)

a)

Safer working environment

b)

Job losses

c)

More efficient work

d)

Cleaner working environment

e)

More lower paying jobs

100.

RSI stands for

a)

Ready Set Injury

b)

Repeat Strain Injury

c)

Repetitive Strain Injury

d)

Random Strain Injury

101.

What are the examples of microprocessor-controlled devices that reduce the need to leave the house?


i. intelligent fridge

ii. e-commerce

iii. email facility

iv. chat rooms

a)

i, ii and iii

b)

i, ii and iv

c)

ii, iii and iv

d)

all of above

102.

What are the advantages of robot over human, choose 2.

a)

They are expensive

b)

Higher productivity

c)

Easy to deploy

d)

They don't get bored by repetitive task

103.

Name one area where ICT has had an effect on employment.

(a)  

104.

Give one advantage of MICROPROCESSORS in general.

4 lines
105.

A single chip integrating all the functions of a CPU of a computer

(a)  

106.

Which of these are potential safety risks or dangers that could lead to injury or loss of life due to improper ICT usage? (select all possible correct answers)

a)

Electrocution

b)

Fire risk

c)

Computer Virus

d)

Hacking

e)

Trailing wires (trip hazard)

107.

Describe one health or safety strategy.

4 lines
108.

A home that allows the owner to control their electronic appliances through their computer or mobile device with internet connection.

(a)  

109.

Appliances that can be controlled using mobile phones or applications in homes that are automated. (select three)

a)

Refrigerator

b)

Rice cooker

c)

Home theatre

d)

Vacuum Cleaner

e)

Electric fan

110.

Give one disadvantage of having homes automated.

(a)  

111.

Name three devices other than labour-saving devices which use embedded microprocessors. (3 pts)

4 lines
112.

A software that makes it much easier to modify and update documents.

a)

Databases

b)

Word processors

c)

Spreadsheets

d)

Presentation

113.

A software that is used in areas where calculations, graphs and charts need to be produced. One good example is a teacher monitoring the progress of their students by entering marks into this software.

a)

Databases

b)

Word processors

c)

Spreadsheets

d)

Presentation

114.

A software that is used for a more efficient way of updating personnal data on a regular basis. It allows you to store and retrieve data in a more structured manner.

a)

Databases

b)

Word processors

c)

Spreadsheets

d)

Presentation

115.

Describe how microprocessor controlled devices have affected social interaction. (5 pts.)

4 lines
116.

When an online order is received, an automatic confirmation message is sent to the customer. Name the method of communication used to send the confirmation.

a)

Letter

b)

Article

c)

Email

d)

Gmail

117.

Describe the features of an intranet

a)

An external internet

b)

LAN within the organization

c)

An output storage device

d)

An input storage device

118.

Name a device that can be used to connect to the internet

a)

Internet

b)

Microsoft

c)

Web processor

d)

Modem

119.

Which of these options are examples of bad email 'netiquette'

a)

Writing in all capitals

b)

Using reply all unnecessarily

c)

Silly subject line comments

d)

Strange colour backgrounds and weird text formatting

120.

Describe RAM

a)

RAM is volatile

b)

RAM is a secondary storage

c)

RAM is the same as ROM

d)

RAM never stores data

121.

What does bit stand for?

a)

Business Information Technology

b)

Binary digit

c)

Base Item Type

d)

Basic Information Technology

122.

What does GB (in ICT) stand for?

a)

Gigabyte

b)

Gegatera

c)

Gigabit

d)

Great Britain

123.

What is the full form of ICT

a)

Information and Computer Technology

b)

Information and Communication Technology

c)

Information and communication Terminology

124.

Which of them is the slowest method of system implementation.

a)

Direct

b)

Parallel

c)

Pilot

d)

Phased

125.

A company that wants the quickest method of implementation.

a)

Pilot

b)

Phased

c)

Direct

d)

Parallel

126.

EFT stands for

a)

Electronic funds transfer

b)

Email funds transfer

c)

Electronic files transfer

127.

ATM stands for

a)

Automatic teller model

b)

Automatic transfer machine

c)

Automatic teller machine

128.

Which of the following is NOT a type of computer?

a)

Desktop

b)

Netbook

c)

PDA

d)

Operating System

129.

Which of the following is an output device?

a)

Pressure Sensor

b)

Plotter

c)

Microphone

d)

MICR

130.

What is the first stage of the systems life cycle?

a)

Analysis

b)

Design

c)

Implementation

d)

Evaluation

131.

How many stages in system life cycle?

a)

Five

b)

Seven

c)

Six

d)

Eight

132.

Which device is used in EFTPOS?

a)

MICR

b)

Chip and pin reader

c)

ATM

d)

OMR

133.

A program which attaches itself to another program in order to spread and cause harm to your computer is known as a

a)

Worm

b)

Virus

c)

Trojan Horse

d)

Spyware

134.

___________________ is when employees are able to access their office desktop computer from a different location.

a)

Intranet

b)

Internet

c)

Remote Working

d)

Cloud Storage

135.

The following are areas of increased employment since establishing of Information Technology in workplaces except:

a)

Retail Shops

b)

Delivery Drivers

c)

Web Designers

d)

Computer Programmers

136.

Below are safety hazards connected to a room full of computers or prolonged use of computer equipment except:

a)

Tripping over cables

b)

Electrocution

c)

Back pain

d)

All of them

137.

_________________ can be installed to keep users safe from viruses.

a)

Antivirus program

b)

Updates

c)

Operating System

d)

An applet

138.

What is a network?

a)

Two or more computers connected to each other

b)

Clients receiving data from servers

c)

Computers in a circle

d)

Spiders doing a job

139.

Printer, Monitor, Speakers and Headphones are which type of devices?

a)

Input

b)

Output

c)

Software

d)

Hardware

140.

What device is used to connect two LAN's together?

a)

Hub/Switch

b)

Router/Modem

c)

Bridge

d)

Server

141.

To convert analogue to digital data you will need

a)

ADC

b)

ANA

c)

DIG

d)

DDC

142.

What is the physical components of a computer?

a)

Operating system

b)

Software

c)

System software

d)

Hardware

143.

A program that control devices such as printers.

a)

Utilities

b)

Command line

c)

Device driver

d)

GUI

144.

A printed circuit board that allocates power to hardware components.

a)

CPU

b)

RAM

c)

Motherboard

d)

Processor

145.

Example of application software

a)

Macintosh

b)

Symbian

c)

Word processing

d)

Windows 10

146.

What storage loses its data every time the computer is turned off?

a)

RAM

b)

CPU

c)

ROM

d)

Motherboard

147.

What is number 3

a)

ISP

b)

Web browser

c)

Hub/ Switch

d)

Router/Modem

148.

What device is used to connect a number of computers together to make a LAN?

a)

Hub/Switch

b)

Router/Modem

c)

Server

d)

Bridge

149.

In system life cycle, we have only two types of Verification

a)

True

b)

False

150.

A blog is a form of digital communication

a)

True

b)

False

151.

Quantum cryptography is a form of encryption that uses physics

a)

True

b)

False

152.

Computer is the combination of hardware and software

a)

True

b)

False

153.

Internet banking can only be done during normal bank working hours.

a)

True

b)

False

154.

ATM’s keyboards are used to enter text.

a)

True

b)

False

155.

2FA is an authentication system

a)

False

b)

True

156.

A hard drive is a type of primary storage.

a)

True

b)

False

157.

VR is a communication system

a)

True

b)

False

158.

A leaflet is a form of digital communication.

a)

True

b)

False

159.

The NIC will contain

a)

The MAC address.

b)

Place of birth, favourite colour, pet’s name etc.

c)

Tripping hazard.

160.

2FA Questions can be

a)

The MAC address.

b)

Place of birth, favourite colour, pet’s name etc.

c)

My first name

161.

Trailing wires present a

a)

Tripping hazard.

b)

Electrocution

c)

Fire hazard

162.

You can access to your file from anywhere on the earth

a)

By using cloud storage

b)

By using intranet

c)

By remote device

163.

Copyright laws make it a crime

a)

To use in a personal computer

b)

To copy software illegally.

c)

To keep a personal copy of it

164.

What is the main difference between hardware and software?

(a)  

165.

What is ISP and SSD?

(a)  

166.

Two advantages of external hard drive

(a)  

167.

What is the effective way to prevent a virus?

(a)  

168.

(a)   analysis and executes a program line by line

169.

(a)   produces output in the form of solid objects.

170.

(a)   produces output in the form of sounds.

171.

(a)   is used to authenticate the users of the computer systems.

172.

(a)   is the programs and data of a computer.

173.

Robots are being used in the mining industry to dig up minerals from under the surface of the earth. Give three advantages of using robots rather than humans for this task.

4 lines
174.

A parent is worried about the e-safety of their young children while they are using their internet. Describe three actions the parent can take to improve the e-safety of their children’s computer use.

4 lines
175.

Write down three netiquettes to follow while using ICT.

4 lines
176.

Write three advantages of internet shopping to a customer

4 lines
177.

What is WWW and HTTP?

(a)  

178.

Advantages of memory stick

(a)  

179.

Target audience needs to be considered

a)

While creating an ICT solution.

b)

While using internet

c)

While playing games

180.

Using a mouse for a long period can cause

a)

Repetitive strain injury

b)

Headache

c)

Eye strain headache

181.

The main purpose of establishing any network is to exchange the data.

a)

True

b)

False

182.

Biometric systems are used to check our health.

a)

True

b)

False

183.

Phishing is a type of virus.

a)

True

b)

False

184.

The intranet has more information than the internet

a)

True

b)

False

185.

The most common example of WAN is the internet.

a)

True

b)

False

186.

Which of these computers is the largest?

a)

PDA

b)

Desktop

c)

Mainframe

d)

Netbook

187.

Aftab and his family have three computers in their home. He wants to connect the computers into a network. which items he would need?

a)

A car

b)

A router

c)

A cable

d)

An ISP

e)

A browser

188.
Which computer component executes commands?
a)
CPU
b)
RAM
c)
ROM
d)
BIOS
189.
What are the 4 features of a Graphical User Interface (GUI)?
a)
Windows, Icons, Menus & Pointer
b)
Screens, Icons, Menus & Pointer
c)
Windows, Buttons, Menus & Pointer
d)
Windows, Icons, Mouse, Pointer
190.
What does CLI stand for?
a)
Command Line Interface
b)
Control Logical Interaction
c)
Control Line Interface
d)
Command Logical Interaction
191.

An intranet is...

a)

A public network of networks

b)

A private network of networks

c)

A set of web pages available via the internet

d)

An email system

192.

Select one advantage of video conferencing over a face to face meeting

a)

More personal

b)

Can exchange paper documentation

c)

Travel time and costs are minimal

d)

No issue with time differences

193.
 Some customers are concerned about using credit cards to pay online.
Identify a concern the customers may have. 
a)
Someone may delete it
b)
Someone may hack the personal details of the customer
c)
Someone can play with it
d)
The bank details may be given out
194.

In your email software the address book allows you to..

a)

See where people live

b)

Save the email addresses of certain people and contacts

c)

Save the street addresses of people

d)

see your own email addresses

195.

In email terminology what does CC stand for

a)

Correct Contact

b)

Confirmed Contact

c)

Constant Copy

d)

Carbon Copy

196.

What are the two types of verifications?

(a)