wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ICT EXAM

Total questions: 125

Worksheet time: 1hrs 12mins

Name
Class
Date
1.

Write your full name.

2 lines
2.

What is the difference between data and information?

a)

Data is meaningful; information is raw

b)

Data is processed; information is unprocessed

c)

Data is raw facts; information is processed and meaningful

d)

They mean the same thing

3.

Which Excel function correctly adds all numbers in a range?

a)

=ADD(A1:A10)

b)

=TOTAL(A1-A10)

c)

=SUM(A1:A10)

d)

=COMBINE(A1:A10)

4.

In PowerPoint, which view is best for rearranging slides?

a)

Normal View

b)

Notes Page

c)

Reading View

d)

Slide Sorter View

5.

What does the primary key in a database table ensure?

a)

The table has more space

b)

Records can be sorted

c)

Each record is unique

d)

The table loads faster

6.

Which device is an input device?

a)

Projector

b)

Printer

c)

Mouse

d)

Speaker

7.

Which feature in MS Word automatically adjusts the spacing between lines?

a)

Layout Grid

b)

Line Spacing

c)

Page Numbering

d)

AutoFit Text

8.

What is the purpose of a query in Microsoft Access?

a)

To print documents

b)

To edit relationships

c)

To search, filter, and extract specific data

d)

To design the interface

9.

What is verification?

a)

Checking data accuracy

b)

Checking data is sensible

c)

Checking data is entered correctly

d)

Checking data is formatted correctly

10.

Which Excel formula calculates the average of numbers?

a)

=MEAN(A1:A10)

b)

=AVERAGE(A1:A10)

c)

=MID(A1:A10)

d)

=MIDPOINT(A1:A10)

11.

In PowerPoint, what is the Slide Master used for?

a)

Editing only one slide

b)

Adding animations

c)

Changing background and design for all slides

d)

Cropping pictures

12.

Which of the following is an output device?

a)

Touchpad

b)

Barcode scanner

c)

Joystick

d)

Monitor

13.

Which type of software is an operating system?

a)

Utility software

b)

Application software

c)

System software

d)

Programming software

14.

What does the MAX() function do in Excel?

a)

Finds the smallest value

b)

Adds values

c)

Finds the largest value

d)

Counts text entries

15.

In Access, which object is best used to create a printed summary of data?

a)

Form

b)

Table

c)

Module

d)

Report

16.

What is the main purpose of transitions in PowerPoint?

a)

To move from one slide to another with visual effects

b)

To align images

c)

To adjust font sizes

d)

To insert charts

17.

Which file format is used to save a Word document?

a)

.xlsx

b)

.pptx

c)

.docx

d)

.mdb

18.

What does the COUNTIF function do in Excel?

a)

Counts all numeric data

b)

Counts only empty cells

c)

Counts cells that meet a condition

d)

Counts every cell in the sheet

19.

Which database object allows users to input data easily?

a)

Report

b)

Query

c)

Form

d)

Macro

20.

Which of the following is a phishing attempt?

a)

An email asking you to update your password through a fake link

b)

Saving a file to a USB

c)

Installing antivirus

d)

Opening a PowerPoint file

21.

What is the main purpose of a chart in Excel?

a)

To delete data

b)

To format headings

c)

To present data visually

d)

To encrypt data

22.

Which key combination copies selected text in Word?

a)

Ctrl + V

b)

Ctrl + X

c)

Ctrl + C

d)

Ctrl + P

23.

Which component processes all instructions in a computer?

a)

RAM

b)

Hard drive

c)

Motherboard

d)

CPU

24.

Which Access object retrieves specific information based on criteria?

a)

Relationship

b)

Report

c)

Macro

d)

Query

25.

How do you insert a table in Word?

a)

Home → Table

b)

Insert → Table

c)

Layout → Gridlines

d)

Design → Table Styles

26.

What is validation?

a)

Preventing incorrect data from being entered

b)

Re-entering data

c)

Sorting data

d)

Printing reports

27.

What is the purpose of the IF function in Excel?

a)

To copy formulas

b)

To test a condition and return different outputs

c)

To create charts

d)

To merge cells

28.

Which device is used for visually impaired users?

a)

QWERTY keyboard

b)

Screen reader

c)

Braille keyboard

d)

Webcam

29.

Which file type is used for databases in Access?

a)

.docx

b)

.accdb

c)

.pptx

d)

.xlsx

30.

Which option best describes information?

a)

Raw facts

b)

Processed data that has meaning

c)

Unsorted numbers

d)

Random binary digits

31.

Which function in Excel counts only numbers?

a)

COUNTA

b)

SUM

c)

COUNT

d)

SORT

32.

In PowerPoint, where can you add speaker notes?

a)

Slide Pane

b)

Notes Pane

c)

File Menu

d)

Animation Ribbon

33.

Which storage device uses optical technology?

a)

SSD

b)

USB Flash

c)

CD/DVD

d)

Hard Disk

34.

What does a firewall protect against?

a)

Slow internet

b)

Unauthorized access to a network

c)

Overheating

d)

Data formatting issues

35.

Which type of chart is best for showing percentages?

a)

Bar chart

b)

Pie chart

c)

Line chart

d)

Scatter chart

36.

What is formatting in Word?

a)

Changing the content

b)

Changing the appearance of text

c)

Printing the document

d)

Saving the document

37.

What is a macro in Access?

a)

A small robot

b)

An automated action

c)

A computer virus

d)

A data type

38.

Why is strong password protection important?

a)

Makes the computer faster

b)

Prevents unauthorized access

c)

Helps save storage

d)

Improves graphic quality

39.

In Excel, which symbol is used for absolute cell referencing?

a)

@

b)

#

c)

$

d)

%

40.

What device captures images?

a)

Speaker

b)

Microphone

c)

Video camera

d)

Router

41.

Which feature in PowerPoint controls how text appears on a slide?

a)

Transitions

b)

Animations

c)

Templates

d)

Slide Sorter

42.

What is the purpose of RAM?

a)

Permanent storage

b)

Storing the operating system only

c)

Temporary storage used by programs while running

d)

Processing instructions

43.

What is the best reason to use a form in Access?

a)

To design charts

b)

To input and view data easily

c)

To print data

d)

To backup data

44.

Which Excel function returns the smallest number in a range?

a)

MIN()

b)

SMALL()

c)

LOW()

d)

TINY()

45.

What does a pie chart show best?

a)

Differences over time

b)

Percentages of a whole

c)

Highest and lowest values

d)

Detailed text descriptions

46.

Which of the following is an example of system software?

a)

Microsoft Word

b)

Adobe Photoshop

c)

Operating system

d)

Web browser

47.

What is a field in a database?

a)

A row of data

b)

A column that stores one type of data

c)

A group of tables

d)

A primary key

48.

What is the purpose of the “Slide Master” in PowerPoint?

a)

Controls background and layout for all slides

b)

Adds animations

c)

Deletes slides

d)

Edits only one slide

49.

Which device converts printed text into digital form?

a)

OCR scanner

b)

Webcam

c)

Barcode reader

d)

Speaker

50.

Which Excel formula checks if a value is greater than 50?

a)

=IF(A150,"Yes","No")

b)

=IF(A1=50,"50","No")

c)

=IF(A1>=50,50,0)

51.

What is the purpose of a hyperlink in PowerPoint?

a)

To embed audio

b)

To link to another slide, file, or website

c)

To replace images

d)

To run macros

52.

Which formula returns the number of cells that meet a condition?

a)

COUNTA

b)

COUNTIF

c)

COUNT

d)

SUMIF

53.

Which key starts a slideshow in PowerPoint?

a)

F1

b)

F5

c)

F9

d)

F12

54.

What is the purpose of AutoSum in Excel?

a)

Sort text

b)

Automatically add a column or row of numbers

c)

Create charts

d)

Format cells

55.

What does the CPU stand for?

a)

Central Processing Unit

b)

Computer Power Unit

c)

Control Processing Utility

d)

Central Power Utility

56.

What is the purpose of the “Design View” in Access?

a)

To change data

b)

To design or change the table structure

c)

To print data

d)

To sort records

57.

In Access, what does a relationship connect?

a)

Queries to forms

b)

Reports to tables

c)

Two tables through matching fields

d)

d) Tables to printers

58.

Which company developed the Windows operating system?

a)

Apple

b)

IBM

c)

Microsoft

d)

Google

59.

Which of the following is a web browser?

a)

Windows

b)

Excel

c)

Chrome

d)

Word

60.

What is the function of a motherboard?

a)

Store data

b)

Connect all components of a computer

c)

Provide power to the computer

d)

Process graphics

61.

Which programming language is primarily used for web development?

a)

C#

b)

Java

c)

HTML

d)

Swift

62.

What type of device is a printer?

a)

Input device

b)

Output device

c)

Storage device

d)

Processing device

63.

What is the main purpose of an operating system?

a)

To manage hardware and software resources

b)

To provide internet access

c)

To run applications

d)

To store files

64.

Which of the following is a primary storage device?

a)

Hard Disk Drive

b)

USB Flash Drive

c)

RAM

d)

DVD

65.

Which of the following file formats is commonly used for images?

a)

.txt

b)

.jpg

c)

.doc

d)

.exe

66.

What does the term "GUI" stand for?

a)

Graphical User Interface

b)

General User Interface

c)

Graphical Unified Interface

d)

Generalized User Interface

67.

What does "SSD" stand for?

a)

Solid State Drive

b)

Super Speed Disk

c)

Secure Storage Device

d)

Solid Storage Drive

68.

Which of the following is not an operating system?

a)

Windows

b)

Linux

c)

HTML

d)

macOS

69.

What is the main advantage of using a VPN?

a)

Increases download speed

b)

Provides anonymity and security online

c)

Decreases data usage

d)

Enhances graphics performance

70.

Which file extension indicates a text file?

a)

.exe

b)

.jpg

c)

.txt

d)

.mp4

71.

Which of the following is not a type of malware?

a)

Virus

b)

Worm

c)

Firewall

d)

Trojan

72.

What does the acronym "URL" stands for?

a)

Uniform Resource Locator

b)

Universal Resource Locator

c)

Unique Resource Locator

d)

Unified Resource Locator

73.

What is the purpose of the task manager in Windows?

a)

To manage files

b)

To monitor system performance

c)

To update software

d)

To configure network settings

74.

What type of software is Microsoft Office?

a)

Operating System

b)

Utility Software

c)

Application Software

d)

System Software

75.

What does "2FA" stand for?

a)

Two-Factor Authentication

b)

Two-Fold Authentication

c)

Two-Factor Access

d)

Two-Fold Access

76.

Which technology is commonly associated with block chain?

a)

Crypto currency

b)

Virtual reality

c)

Machine learning

d)

Cloud computing

77.

Which of the following is a characteristic of a relational database?

a)

Uses tables to store data

b)

Lacks relationships between data

c)

Is not structured

d)

None of the above

78.

What is a "search engine"?

a)

A software that helps you find files on your computer

b)

A system that retrieves information from the web

c)

A hardware component

d)

A type of database

79.

What does "debugging" refer to?

a)

Writing new code

b)

Identifying and fixing errors in code

c)

Compiling code

d)

Testing hardware

80.

Which of the following is an example of a digital assistant?

a)

Google Assistant

b)

Siri

c)

Alexa

d)

All of the above

81.

Which of the following is a common method of data visualization?

a)

Tables

b)

Graphs

c)

Charts

d)

All of the above

82.

What is the primary role of an IT professional?

a)

To design software

b)

To maintain and support technology systems

c)

To develop hardware

d)

To manage business operations

83.

Ctrl + V =

a)

paste

b)

highlight

c)

copy

d)

save as

84.
What is malware?
a)
Malicious software
b)
A hardware component
c)
A type of keyboard
d)
A computer language
85.
What is identity theft?
a)
Stealing someone's personal information
b)
Buying a new computer
c)
Installing software
d)
Sending emails
86.
Which of the following can help prevent identity theft?
a)
Using strong passwords
b)
Sharing passwords
c)
Ignoring software updates
d)
Posting personal details online
87.
What does copyright law protect?
a)
Original creative works
b)
Physical property
c)
Computer viruses
d)
Spam emails
88.

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")

89.

What is an advantage of using cloud computing in healthcare?

a)

Increased local storage requirements

b)

Easier sharing and access to patient data

c)

Higher costs

d)

Reduced data security

90.

Which medical tool uses sound waves to create images of the inside of the body?

a)

MRI

b)

Ultrasound

c)

X-ray

d)

CT Scan

91.

What is a strategy to reduce back problems related to computer use?

a)

Sitting closer to the monitor

b)

Avoiding eye tests

c)

Taking regular breaks

d)

Using a non-adjustable chair

92.

What is a common health risk associated with staring at a screen continuously?

a)

Headaches

b)

Improved vision

c)

Reduced eye strain

d)

Enhanced concentration

93.

I link to a smart phone using Bluetooth and I am wearable technology.

a)

Smart watch

b)

Tablet PC

c)

Desktop PC

94.

Compared to a desktop PC, we are not very good to use when creating presentations, documents or websites.

a)

Tablet PC

b)

Smart phone

c)

Smart watch

d)

Laptop

95.

What is the full form of ISP.

a)

Intranet Service Provider

b)

Internal Service Provider

c)

Intranet Service Protocol

d)

Internet Service Provider

96.

What is the full form of CLI.

a)

Computer Line Interface

b)

Central Line Interface

c)

Circle Line Interface

d)

Command Line Interface

97.

What does WLAN stand for?

a)

Wired Local Arena Name

b)

Wireless Local Area Network

c)

Wireless Area Name

d)

Wired Local Area Network

98.

Your computer is the _______ in a client-server relationship

a)

Client

b)

Server

99.

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

100.

What is number 3?

a)

Web browser

b)

ISP

c)

Router/Modem

d)

Hub/ Switch

101.

Which network covers a large geographical area?

a)

LAN

b)

WAN

102.

What does the following report calculation do?

a)

Avg is spelt wrong so there is an error

b)

Grade is spelt wrong so there is an error

c)

nothing will display in report

d)

Gives the average grade from the whole database

103.

Which icon do you click to change to Design View?

a)

A

b)

B

104.
a)

Query criteria

b)

Wildcards

c)

Datatypes

d)

Field names

105.

To hide a field from the query result

a)

Delete Field from the Query Grid

b)

Remove Show Box Checkmark

c)

Add Show Box Checkmark

d)

Put IS Null in the Criteria Cell

106.

Like R* will display

a)

All Records that end in "R"

b)

No Records

c)

All Records Greater Than R

d)

All records that Begin with "R"

107.

What does the following calculation do?

a)

Anything bigger than 500, smaller than 1000

b)

Smaller than 500, bigger than 1000

c)

Equal to or bigger than 500, equal to or smaller than 1000

d)

Equal to or smaller than 500, equal to or bigger than 1000

108.

What symbol means GREATER THAN or EQUALS to?

a)

<=

b)

>=

c)

>

d)

<

109.

What query would get you the same results as the one below?

a)

NOT White

b)

EQUALS White

c)

Black AND White

d)

Black OR White

110.

There are 30 records in the database. How many will be found with this query?

a)

30

b)

0

c)

ERROR

d)

20

111.

What table has been used in the design of this query?

a)

Query1

b)

Shapes

c)

Access

d)

ID

112.

When would MS Access be used instead of MS Excel?

a)

When using one large worksheet with mostly numeric data

b)

Creating complex graphs or charts

c)

Creating essays with included data

d)

For multiple tables, lots of data & using external databases

113.

A foreign key is a normal field in one table which is used as a (a)   in another table

114.

To search a database

a)

Report

b)

Query

c)

Label

d)

Table

115.

A database is an

a)

interesting collection of facts

b)

a computer-based data storage technology

c)

organised collection of data

d)

a large disorganised bucket of data

116.
Telephone number fields should have this data type.
a)
alphanumeric
b)
number
c)
currency
d)
Boolean
117.
This kind of wildcard query will find all records that end with an 'a'.
a)
*a
b)
a*
c)
*a*
118.
This kind of wildcard query will find all records beginning with an 'a'.
a)
a*
b)
*a
c)
*a*
119.

This query string will find all values from 5 to 10 inclusive.

a)

BETWEEN 5 AND 10

b)

>5 AND <10

c)

=5 OR 10

d)

5-10

120.
This query string will find all values that contain the word 'happy'.
a)
Like "*happy*"
b)
Like happy
c)
Like "*happy"
d)
Like "happy*"
121.
When the primary key from a table appears as a field in another table, it is called a...
a)
foreign key
b)
secondary key
c)
linked key
d)
related key
122.
A runtime query calculates a value when the query is run with the format Field:[Calculation]. How would you calculate profit?
a)
Profit:[Sale]-[Cost]
b)
Profit = Sale - Cost
c)
Proft = [Sale] - [Cost]
d)
[Sale]-[Cost]:Profit
123.
A runtime query calculates a value when the query is run with the format Field:[Calculation]. Which syntax would calculate sales tax at 20%?
a)
Sales tax:[Total]*0.2
b)
[Total]*20 = "Sales tax"
c)
Sales tax = total * 20%
d)
"Sales tax":"total"*"0.2"
124.

This query string will find all records that aren't zero.

a)

NOT 0

b)

=0

c)

=!0

d)

0

125.

This query string will find all records that aren't zero.

a)

<>0

b)

=!0

c)

="0"

d)

=^0

Similar Resources on Wayground

PAS Genap IPA Fisika Kelas X A

120 questions

PAS Genap IPA Fisika Kelas X A

quiz

Worksheet

•

10th Grade

G10-TLE-Computer-2022-2023

121 questions

G10-TLE-Computer-2022-2023

quiz

Worksheet

•

10th Grade

Đề Cương Ôn Tập HK2 TIN HỌC 10

120 questions

Đề Cương Ôn Tập HK2 TIN HỌC 10

quiz

Worksheet

•

10th Grade

WJEC GCSE DIGI TECH - Digital Systems

129 questions

WJEC GCSE DIGI TECH - Digital Systems

quiz

Worksheet

•

10th Grade

Câu hỏi ôn tập dạng 2 (trích xuất cho kiểm tra lớp 10)

122 questions

Câu hỏi ôn tập dạng 2 (trích xuất cho kiểm tra lớp 10)

quiz

Worksheet

•

10th Grade

Page 1

120 questions

Page 1

quiz

Worksheet

•

10th Grade

Sinh 11 GKII

129 questions

Sinh 11 GKII

quiz

Worksheet

•

10th Grade

Q3 Study Guide

125 questions

Q3 Study Guide

quiz

Worksheet

•

9th - 12th Grade