wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

IGCSE ICT Revision

Total questions: 100

Worksheet time: 52mins

Name
Class
Date
1.
Which of these computers is the largest?
a)
PDA
b)
Desktop
c)
Mainframe
d)
Netbook
2.
Which of these is not a type of computer?
a)
Embedded Microprocessor
b)
Laptop
c)
Supercomputer
d)
Windows
3.
What are the two main categories of software?
a)
Systems and Applications
b)
OS and Office
c)
Windows and Applications
d)
Systems and Office
4.
Which computer component executes commands?
a)
CPU
b)
RAM
c)
ROM
d)
BIOS
5.
What do we call the computer's main memory which temporarily stores data when the computer is switched on?
a)
Random Access Memory
b)
Real Actual Memory
c)
Read Access Memory
d)
Random Actual Memory
6.
The ROM stores permanent instructions such as the...
a)
CMOS
b)
BIOS
c)
RAM
d)
CPU
7.
RAM loses its contents once the computer is switched off, therefore it is...
a)
Non-Volatile
b)
Volatile
c)
Read Only Memory
d)
Read Once Memory
8.
Which of these is not a type of user interface?
a)
Command Line
b)
Menu Driven
c)
Operating System
d)
Graphical User Interface
9.
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
10.
Which user interface are you currently using?
a)
Command Line
b)
Menu Driven
c)
Voice Recognition
d)
GUI
11.
Which of the following is not a image file?
a)
.png
b)
.jpg
c)
.gif
d)
.pdf
12.
Printer, Monitor, Speakers and Headphones are which type of devices?
a)
Input
b)
Output
c)
Software
d)
Hardware
13.

What is the purpose of an IP address?

a)

Allows a connection to the internet

b)

Modulates and demodulates data

c)

A identify's a devices location connected to the internet

d)

Allows two LAN's to connect to each other via cables

14.

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

15.

What is being described?

Sending a copy of a paper document over a telephone network.

a)

Fax

b)

Video Conferencing

c)

Email

d)

Social Media

16.

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

17.
What does MICR do?
a)
Reads the magnetic ink on cheques
b)
Reads the marks on a multi-choice test paper
c)
Read characters on a passport application
d)
Where you pay for goods
18.
Surveys, school records and libraries are examples of what type of applications?
a)
Data handling appliactions
b)
Measuring appliactions
c)
Banking applications
d)
Expert System appliactions
19.

Phishing generally refers to

a)

scams through websites

b)

scams through emails

c)

scams through phone calls

d)

scams through text messages

20.
What type of device is a hard disk drive?
a)
Input
b)
Output
c)
Storage
d)
Processing
21.
A large, expensive printer that might be used by architects to print plans
a)
Laser
b)
Dot Matrix
c)
Ink Jet
d)
Plotter
22.
What does EFTPOS stand for?
a)
Electronic Financial Transaction Processing Operating System
b)
Electronic Funds Transfer Point Of Sale
c)
Electronic Financial Transfer Processing Operating System
d)
Electronic Financial Tickets Point Of Sale
23.
Unit 1 Practical: Which of the following is a serif font?
a)
Times New Roman
b)
Corbel
c)
Arial
d)
Calibri
24.
Unit 2 Theory: Which of the following is an output device?
a)
Pressure Sensor
b)
Plotter
c)
Microphone
d)
MICR
25.
Unit 2 Practical: In a presentation the effects added between slides is known as...
a)
Transistion
b)
Animation
c)
Master Slide
d)
Ribbon
26.
Unit 3 Theory: Which of the following is NOT a method for backing up files?
a)
RAID
b)
Remote Backup
c)
Mirroring
d)
Archiving
27.
Unit 3 Practical: In MS Word the default line spacing is... 
a)
Single
b)
1.5
c)
Double
d)
2
28.

Give one advantage using an email to send information

a)

Can be received and read immediately

b)

Signatures can be easily included on a signed document

c)

Changes to an attachment can be easily changed

d)

There are no misunderstandings in the interpretation of email content

29.

What is the purpose of an IP address?

a)

Allows a connection to the internet

b)

Modulates and demodulates data

c)

A identify's a devices location connected to the internet

d)

Allows two LAN's to connect to each other via cables

30.

What does WLAN stand for?

a)

Wired Local Arena Name

b)

Wireless Local Area Network

c)

Wireless Area Name

d)

Wired Local Area Network

31.

These are some examples of activities you can do without leaving the house

a)

work from home

b)

put petrol in your car

c)

do your banking

d)

post a letter

32.

Over use of online games or social media could lead to

a)

more delivery drivers

b)

houses being cleaned by robots

c)

hotter houses

d)

lack of exercise and health problems

33.

This is not a mouse but is used to manoeuvre objects around the screen in computer video games.

a)

Touch pad

b)

Joystick

c)

keyboard

d)

scanner

34.

What is also called as "Cash points" or "hole in the wall"

a)

Credit cards

b)

ATM

c)

EFT

d)

Online banking

35.

How to recognise fake or bogus websites : Tick 2 of them

a)

Check the URL

b)

check for mistakes in spelling / grammar

c)

Identify user-id

d)

scan for viruses

36.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
37.

Zoe wants to add together a range of cells in her spreadsheet. She would like Excel to add only the cells in the range that are greater than 50. What function should she use?

a)

SUMIF

b)

AVERAGEIF

c)

TOTALIF

d)

COUNTIF

38.
If you see this code, what do you need to do?
#####
a)
Check your function syntax
b)
Re-enter the function formula
c)
Widen the column
d)
Use a different function
39.

If a student scores over 20 in the exam, the adjacent cell must state PASS otherwise it should say FAIL.

Select the correct formula that must be typed in cell C4.

a)

=IF(B4>20,"PASS","FAIL")

b)

=IF("PASS"=>20,B4,"FAIL)

c)

=IF(<20,B4,"PASS","FAIL")

d)

=IF(B4<20 "PASS","FAIL")

40.

You've been asked to Extract a list of countries that use dollar as their currency. How would you do this?

a)

Use a filter

b)

Use a formula

c)

Use a function

d)

Use a chart

41.

You have been asked In cell D10 enter a function to lookup the destination for Robert Maxwell.

What function would you use?

a)

VLOOKUP

b)

IF

c)

AVERAGE

d)

SUMIF

42.

You have been asked In Cell D2 use a count formula that counts the frequency of AQA in cell range E3 to E25.

Which is the most appropriate function to use?

a)

COUNTIF

b)

SUMIF

c)

VLOOKUP

d)

IF

43.

Which of the below formulae includes absolute cell referencing?

a)

=B7*$D$21

b)

=SUM(A2:D5)

c)

=IF(D5=5,"MET","FAIL")

d)

=AVERAGE(H7:H20)

44.

What is the correct format of an IF statement

a)

=IF (TEST, VALUE IF TRUE, VALUE IF FALSE)

=IF(A1>B1,"YES","NO")

b)

=IF (TEST VALUE IF FALSE VALUE IF TRUE)

=IF(A1>B1,NO, YES)

c)

=IF TEST,VALUE IF TRUE, VALUE IF FALSE

=IFA1>B1,"YES","NO"

45.
What does this mean?
a)
Clip
b)
Email
c)
Attachment
d)
Send
46.
What is this image the icon for?
a)
Microsoft PowerPoint
b)
Microsoft Word
c)
Microsoft Publisher
d)
Microsoft Excel
47.
What is this?
a)
Email
b)
Inbox
c)
Post
d)
Sent
48.
What does this mean?
a)
Search
b)
Paste
c)
Delete
d)
Copy
49.
If you need to compute the total sales which function will you use?
a)
MIN
b)
Max
c)
Avg
d)
SUM
50.
How would you find the lowest sale for a quarter of the year?
a)
SUM
b)
MIN
c)
MAX
d)
AVG
51.
Another name for a spreadsheet is....
a)
worksheet
b)
paper
c)
workbook
d)
tablet
52.
What is a spreadsheet used for?
a)
It is used to spread things.
b)
Spreadsheets are used to organize your food.
c)
They are used to edit data.
d)
Used to process and perform calculations of raw data.
53.
What is a Format?
a)
Alphabetical or numeric text that will not be used in calculations.
b)
Tells the software what to do with operands in a formula.
c)
Numeric characters that can be calculated in a spreadsheet.
d)
Arranging the shape, size, type, and general makeup of a cell or document.
54.
Which one of these steps do you not need to do when creating a spreadsheet?
a)
Start Word and open the document to which you want to add a spreadsheet.
b)
Choose File > Save As.
c)
Select the "Insert" tab and click the "Object" drop-down arrow in the Text group.
d)
Click "Object." Select a worksheet option from the Object Type list, such as "Microsoft Excel 97-2003 Worksheet," and click "OK."
55.
Which chart in Excel would best show the percentages of students' favorite ice cream flavors?
a)
Bar chart
b)
Line Chart
c)
Pie Chart
d)
Scatter Chart
56.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
57.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
58.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
59.

eg $A$6

a reference to a cell used in a formula where, when the formula is copied to a new address, the cell address does not change.

a)

Absolute reference

b)

wrap text

c)

label

d)

nested formula / functions

60.
A way of holding data in a file so that it can be transferred into databases or spreadsheets.
a)
CSV comma separated variables.
b)
Absolute reference
c)
wrap text
d)
label
61.
raw facts and figures, e.g. readings from sensors, survey facts, etc.
a)
Data
b)
CSV comma separated variables.
c)
Absolute reference
d)
wrap text
62.
validation check to ensure the data being entered is the same type as the data type specified for the field.
a)
Data type check
b)
Data
c)
CSV comma separated variables.
d)
Absolute reference
63.
entering the details into an ICT system twice; only if the two sets of data are identical will they be accepted for processing. It is a method of verification. This method is often used when you set up a new password.
a)
Double entry of data
b)
Data type check
c)
Data
d)
CSV comma separated variables.
64.
is data on the borderline of what the system will accept. For example, if a range check specifies that a number from 16 to 21 inclusive is entered, the extreme data would be 16 and 21.
a)
Extreme data
b)
Double entry of data
c)
Data type check
d)
Data
65.
validation check to make sure that the data being entered has the correct number of characters in it.
a)
Length check
b)
Extreme data
c)
Double entry of data
d)
Data type check
66.
data that is acceptable for processing and will pass the validation checks.
a)
Normal data
b)
Length check
c)
Extreme data
d)
Double entry of data
67.
validation checks used to ensure that data has been entered into a field.
a)
Presence checks
b)
Normal data
c)
Length check
d)
Extreme data
68.
when a cell is used in a formula and the formula is copied to a new address, the cell address changes to take account of the formula’s new position.
a)
Relative reference
b)
Presence checks
c)
Normal data
d)
Length check
69.

these are checks that a developer creates, using the software, in order to restrict the data that a user can enter to reduce errors.

a)

Validation checks

b)

Relative reference

c)

Presence checks

d)

Normal data

70.
checking that the data being entered into the ICT system perfectly matches the source of the data.
a)
Verification
b)
Validation checks
c)
Relative reference
d)
Presence checks
71.
checks performed on codes to make sure that they conform to the correct combinations of characters.
a)
Format checks
b)
Verification
c)
Validation checks
d)
Relative reference
72.

a rectangle or block in a worksheet. Any data that you want to enter into your worksheet must be placed in a cell.

a)

cell

b)

Format checks

c)

Verification

d)

Validation checks

73.
a cell that is currently opened for editing.
a)
Active Cell
b)
cell
c)
Format checks
d)
Verification
74.
cells that are vertical
a)
columns
b)
rows
c)
Active Cell
d)
cell
75.

The documents in the workbook. Also called sheets. You can have more than one worksheet in a workbook. Tabs at the bottom of the of the screen show which of your worksheets you are currently working on.

a)

worksheets / sheets

b)

columns

c)

rows

d)

Active Cell

76.
an Excel spreadsheet file. It has all of the data that you have entered and allows you to sort or calculate the results.
a)
workbook
b)
worksheets / sheets
c)
columns
d)
rows
77.
at the bottom of the of the screen there is a rectangle box sticking out from the worksheet, this shows which worksheet you are currently working on.
a)
tabs
b)
workbook
c)
worksheets / sheets
d)
columns
78.

there are different types of charts that are used to summarize and compare data. Such as bar, column and pie.

a)

charts

b)

tabs

c)

workbook

d)

worksheets / sheets

79.
A sequence inside a cell that is used to produce a value. It must begin with an equal (=) sign.
a)
formula
b)
pages
c)
charts
d)
tabs
80.

these are formulas that are pre-built into Excel. They are designed to make difficult formulas easier.

a)

function

b)

formula

c)

pages

d)

charts

81.

is another way of saying number data.

a)

numeric data

b)

function

c)

formula

d)

pages

82.
So it is easy to remember you can give a cell (eg C1) a name that describes the data in that cell (eg Tax%)
a)
named cell
b)
numeric data
c)
function
d)
formula
83.
is a collection of cells that have been identified as a group. So it is easy to remember you can give a range (eg A1:C12) a name that describes the data in those cells.
a)
named ranges
b)
named cell
c)
numeric data
d)
function
84.
formula or functions that are inside another, usually an IF function will hold other functions eg. IF(AVERAGE(B2:B10)>100,SUM(C2:G10),0)
a)
nested formula / functions
b)
named ranges
c)
named cell
d)
numeric data
85.

the text that is typed into the cells of a spreadsheet. They have no numeric value and cannot be used in a formula or function.

a)

label

b)

nested formula / functions

c)

named ranges

d)

named cell

86.

you can to apply a format to a cell or a range of cells based on certain rules. eg if the cell contains "A" fill the cell green

a)

Conditional formatting

b)

Numeric data

c)

Nested Formula

d)

Colour formatting

87.
Which of these is a search engine
a)
Google Chrome
b)
Microsoft Edge
c)
Ask Jeeves
d)
Mozilla Firefox
88.
What app is this?
a)
Instagram 
b)
Facebook
c)
Snapchat
d)
Twitter
89.
information is ............
a)
None of the below
b)
meanless
c)
numbers and characters 
d)
Data + Data 
90.
Computer alows you to ......and ........information 
a)
copy and paste 
b)
store and process
c)
save and play 
91.
Why do you need security on a computer?
a)
So no personal data can’t  be stolen and hacked also private information
b)
To share  everything with everyone
c)
To make it difficult for hackers
92.
Which of the below peripherals is not an output device?
a)
Monitor
b)
Speaker
c)
Headset
d)
Microphone
93.
An example of super computer is :
a)
MP3 players
b)
Desktop
c)
Cell phones
d)
Mainframe computers
94.
What is phishing?
a)
Catching fish
b)
Eating fish
c)
When people try to get your information or data
d)
Using cookies 
95.
Which network is faster and stronger?
a)
Wired
b)
Wireless
96.

What is BIOS stands for?

a)

BASIC INPUT OUTPUT SYSTEM

b)

BASIC INDUCT ONLINE SYSTEM

c)

BASIC INDUSTRY ONLINE STANDARDS

d)

BASIC INSULATOR OPEN SOURCE

97.

Identify the malwares.

a)

trojan

b)

virus

c)

spyware

d)

all of the choices

98.
What is ICT?
a)
Information Communication technology
b)
Integrating communication technologhy
c)
Information Connecting Technology
d)
Information communication technique
99.

What is download?

a)

To copy text from one document to another

b)

To create a new document

c)

To copy data from one computer system to another

d)

To send a message

100.
What is grooming?
a)
Washing your dog
b)
Playing outside
c)
Washing your hair
d)
How a predator tries to get you to trust them

Similar Resources on Wayground

Examen google ok

99 questions

Examen google ok

quiz

Worksheet

•

3rd Grade

Cálculo matemático

103 questions

Cálculo matemático

quiz

Worksheet

•

10th Grade

Informática Básica

100 questions

Informática Básica

quiz

Worksheet

•

Professional Development

Reforzamiento Tecnología 2°

97 questions

Reforzamiento Tecnología 2°

quiz

Worksheet

•

1st - 3rd Grade

Ag Structures Mid-term #2 2026

100 questions

Ag Structures Mid-term #2 2026

quiz

Worksheet

•

9th Grade - University

Técnicas de comunicación - Tema 3 - Ulpgc - Prueba

95 questions

Técnicas de comunicación - Tema 3 - Ulpgc - Prueba

quiz

Worksheet

•

University

Penilaian Tengah Semester PSPT-KR

100 questions

Penilaian Tengah Semester PSPT-KR

quiz

Worksheet

•

11th Grade

ÔN TẬP KTGK1

96 questions

ÔN TẬP KTGK1

quiz

Worksheet

•

11th Grade