Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ict exam p2

Total questions: 77

Worksheet time: 39mins

Name
Class
Date
1.

Which data analysis technique is used to identify patterns or relationships in data through machine learning algorithms?

a)

regression analysis

b)

t-test

c)

inferential statistics

d)

clustering analysis

e)

descriptive statistics

2.

Which of the following devices is commonly used to connect multiple computers in a local area network (LAN)?

a)

router

b)

firewall

c)

switch

d)

modem

e)

hub

3.

What does the acronym "LAN" stand for in the context of computer networks?

a)

local access network

b)

longitudinal area network

c)

local area network

d)

large area network

e)

landline area network

4.

Which networking protocol is commonly used for sending and receiving emails?

a)

HTTP

b)

SMTP

c)

FTP

d)

UDP

e)

TCP/IP

5.

What is the primary purpose of a modem in a telecommunications system?

a)

to convert digital data to analog signals for transmission over telephone lines

b)

to provide wireless internet access

6.

Which networking protocol is used to retrieve web pages from the World Wide Web?

a)

HTML

b)

FTP

c)

HTTP

d)

TCP/IP

e)

POP3

7.

What does "ISP" stand for in the context of networks and telecommunications?

a)

interconnected switching platform

b)

internet speed protocol

c)

international security protocol

d)

integrated system processor

e)

internet service provider

8.

Which network protocol is commonly used for sending and receiving emails?

a)

FTP

b)

TCP/IP

c)

HTTP

d)

POP3

e)

SMTP

9.

In telecommunications, what is the term for the modulation technique that allows digital data to be transmitted over analog telephone lines?

a)

T1 line

b)

microwave transmission

c)

fiber optics

d)

modem

10.

What technology is used to transmit data wirelessly over short distances between devices such as smartphones and headphones?

a)

ethernet

b)

satellite communication

c)

DSL

d)

fiber optics

e)

Bluetooth

11.

What does "VoIP" stand for in the context of telecommunications?

a)

video output and input processing

b)

voice of intranet programs

c)

voice over internet protocol

d)

voltage over internet protocol

e)

virtual optical interface port

12.

What does "IP" stand for in the context of IP addressing?

a)

internet port

b)

internet provider

c)

intranet protocol

d)

internet protocol

e)

information port

13.

Which version of IP addresses is the most widely used and currently the dominant protocol on the internet?

a)

IP version 6 (IPv6)

b)

IP version 10 (IPv10)

c)

IP version 4 (IPv4)

d)

IP version 2 (IPv2)

e)

IP version 8 (IPv8)

14.

How many bits are in an IPv4 address?

a)

32 bits

b)

4 bits

c)

8 bits

d)

64 bits

e)

16 bits

15.

Which type of IP address is used to identify a specific device on a local network, typically assigned by a router?

a)

APIPA address

b)

static IP address

c)

dynamic IP address

d)

public IP address

e)

private IP address

16.

What is the purpose of subnetting in IP addressing?

a)

to hide a device's IP address from the internet

b)

to assign public IP addresses to all devices on a network

c)

to divide a large network into smaller, manageable segments

d)

to expand the size of the ipv4 address space

e)

to encrypt IP addresses for security purposes

17.

What is the purpose of an IP address in computer networking?

a)

to determine the computer's brand and model

b)

to connect to the internet

c)

to identify a specific computer or device on a network

d)

to route data packets to the correct website

e)

to encrypt data for secure transmission

18.

Which version of the Internet Protocol introduced 128-bit IP addresses?

a)

IPv10

b)

IPv6

c)

IPv4

d)

IPv2

19.

In IPv4, how many bits are used to represent an IP address?

a)

8 bits

b)

32 bits

c)

64 bits

d)

128 bits

e)

16 bits

20.

What is the purpose of the subnet mask in IP addressing?

a)

to assign a unique hostname to a device

b)

to specify the network portion of an IP address

c)

to determine the physical location of a device

d)

to identify the type of device

e)

to encrypt data in transit

21.

What is the primary goal of cybersecurity?

a)

to encourage the sharing of sensitive information

b)

to provide unrestricted access to all users

c)

to prevent all cyberattacks

d)

to maximize network speed and performance

e)

to protect computer systems and data from unauthorized access, attacks, and damage

22.

What is a common method of authentication used in cybersecurity to verify a user's identity?

a)

firewall

b)

passwords

c)

virus scan

23.

Which cybersecurity practice involves making multiple copies of data to ensure it can be restored in case of data loss or cyberattacks?

a)

phishing

b)

data backup

c)

encryption

d)

antivirus scanning

e)

firewall

24.

What is the term for a malicious program or code that is disguised as a legitimate software application and can harm a computer system?

a)

malware

b)

antivirus

c)

pharase

d)

firewall

e)

password

25.

Which cybersecurity concept involves limiting the access rights of users and systems to only the necessary resources for their legitimate tasks?

a)

encryption

b)

least privilege principle

c)

vulnerability assessment

d)

authentication

e)

intrusion detection

26.

In spreadsheet editors like Microsoft Excel, what is the purpose of a formula?

a)

to perform calculations using numerical data in cells

b)

to insert images and graphics into a worksheet

c)

to adjust the page layout of the spreadsheet

d)

to change the font style of cell contents

27.

Which function in spreadsheet software is used to find the highest value in a range of cells?

a)

IF

b)

SUM

c)

COUNT

d)

AVERAGE

e)

MAX

28.

What is the purpose of the "AutoFill" feature in spreadsheet editors?

a)

to automatically generate a sequence of values or dates

b)

to add comments and notes to cells

c)

to create new worksheets

d)

to change the cell formatting

e)

to delete cells and data

29.

In a spreadsheet, which type of chart is best suited for showing the relationship between two sets of data?

a)

radar chart

b)

line chart

c)

bar chart

d)

pie chart

e)

scatter plot

30.

What does it mean to "freeze" panes in a spreadsheet editor?

a)

to lock specific rows or columns in place while scrolling through the sheet

b)

to make the entire worksheet read-only

c)

to delete selected cells

d)

to hide all data in the spreadsheet

e)

to prevent any changes from being made to the spreadsheet

31.

 In a spreadsheet editor, what is the purpose of a formula?


a)

to insert a picture into a worksheet

b)

to apply conditional formatting to a cell

c)

to change the font style of a cell

d)

to perform calculations on numerical data

32.

What symbol is commonly used to indicate a cell reference in a formula within a spreadsheet?

a)

@

b)

%

c)

#

d)

&

e)

$

33.

In spreadsheet editors like Microsoft Excel, what is the function of the SUM function?

a)

to create a chart

b)

to insert a comment in a cell

c)

to calculate the average of a range of numbers

d)

to change the cell's formatting

e)

to perform addition on a selected range of cells

34.

Which type of chart is best suited for showing the distribution of data points and identifying outliers?

a)

line chart

b)

radar chart

c)

bar chart

d)

scatter plot

e)

pie chart

35.

What does it mean to "format" a cell in a spreadsheet editor?

a)

to merge the cell with adjacent cells

b)

to apply styling, such as font, color, and number format, to a cell

c)

to delete the cell's content

d)

to change the font style of a cell

e)

to insert a picture into a worksheet

36.

What is the primary purpose of MS PowerPoint in creating presentations?

a)

to write code

b)

to send emails

c)

to create and deliver visual presentations

d)

to edit photos

e)

to browse the internet

37.

What is a slide master in MS PowerPoint used for?

a)

to create animations

b)

to define the overall layout and formatting for all slides in a presentation

c)

to record audio narration

d)

to print handouts

e)

to insert pictures into slides

38.

What is a transition in MS PowerPoint?

a)

a method for importing data

b)

a way to print slides

c)

a type of animation

d)

a visual effect used to move from one slide to the next during a presentation

e)

a sound effect

39.

Which view in MS PowerPoint allows you to see and organize all the slides in a presentation as thumbnails?

a)

slide show view

b)

design view

c)

slide sorter view

d)

normal view

40.

What is the purpose of speaker notes in MS PowerPoint?

a)

to create hyperlinks

b)

to provide additional information

c)

to change the slide layout

d)

to record audio narration

e)

to add visual effects to slides

41.

What is the primary purpose of MS PowerPoint?

a)

to create and edit text documents

b)

to design and deliver visual presentations

c)

to send and receive emails

d)

to create and edit images

e)

to develop computer programs

42.

Which tab in MS PowerPoint is used to access slide layouts, themes, and transitions?

a)

format

b)

insert

c)

design

d)

home

e)

review

43.

What is the default extension for saving a PowerPoint presentation?

a)

.pptx

b)

.pdf

c)

.txt

d)

.doc

e)

.xlsx

44.

Which feature in MS PowerPoint allows you to rehearse and time your presentation?

a)
animation
b)

presenter view

45.

What is the purpose of the "Slide Master" in MS PowerPoint?

a)

to create speaker notes

b)

to insert images into slides

c)

to define the overall look

d)

to record and play audio during the presentation

e)

to apply animations to text

46.

What is the purpose of HTML tags?

a)

to display images on web pages

b)

to style web pages

c)

to encrypt web page data

d)

to create and structure the content of web pages

e)

to create animations on web pages

47.

What does the HTML tag represent?

a)

a video

b)

a table

c)

a hyperlink

d)

an image

e)

a paragraph

48.

Which protocol is used for secure communication over the internet?

a)

UDP

b)

HTTPS

c)

FTP

d)

TCP

49.

What is the primary function of a web browser?

a)

Run desktop applications

b)

Create video content

c)

Access web pages online

d)

Store files locally on a device

e)

Download software automatically

50.

Which type of network is the internet classified as?

a)

Office network

b)

Personal area network

c)

Wide area network

d)

Home area network

e)

Local area network

51.

What is the role of DNS in internet technology?

a)

Translates domain names to IP addresses

b)

Hosts website content online

c)

Manages internet data transmission

d)

Routes network traffic between servers

e)

Provides security encryption for websites

52.

What does HTTP stand for in internet technologies?

a)

Hypertext Technology Platform

b)

Hyperlink Text Transfer Program

c)

Hypertext Telecommunication Platform

d)

High Transfer Telecommunication Protocol

e)

Hypertext Transfer Protocol

53.

What technology allows devices to communicate without a physical connection?

a)

Satellite communication

b)

Fiber optics

c)

Wireless networking

54.

Which technology enables remote access to data and applications?

a)

Ethernet cables

b)

Fiber optics

c)

Cloud computing

d)

Wireless networking

e)

USB connections

55.

What is the main purpose of an IP address?

a)

Encrypt data transmissions

b)

Identify devices on a network

c)

Monitor internet usage

d)

Store web content

e)

Manage email accounts

56.

What does the term "bandwidth" refer to?

a)

Number of devices connected

b)

Distance between network nodes

c)

Physical size of a network cable

d)

Data transfer capacity of a network

e)

Speed of a computer processor

57.

Which technology is commonly used for video conferencing?

a)

FTP

b)

SMS

c)

VoIP

d)

HTTP

58.

What is the primary advantage of cloud computing?

a)

Limited server access

b)

Reduced hardware costs

c)

Slower data processing

d)

On-demand resource availability

e)

Local file storage

59.

Which service model offers software over the internet?

a)

Platform as a service

b)

Infrastructure as a service

c)

Database as a service

d)

Software as a service

e)

Hardware as a service

60.

What is a key feature of mobile applications?

a)

Inability to run offline

b)

Limited device compatibility

c)

Access on portable devices

d)

Manual data entry only

e)

Fixed functionality

61.

Which type of cloud is owned and operated by a single organization?

a)

Private cloud

b)

Distributed cloud

c)

Community cloud

d)

Public cloud

e)

Hybrid cloud

62.

What is the primary function of mobile cloud computing?

a)

Delivering services through mobile devices

b)

Limiting access to cloud-based software

c)

Providing offline storage options

d)

Storing data on physical servers

63.

What is a common advantage of using mobile technology in business?

a)

Decreased operational costs

b)

Inflexible work hours

c)

Slow response times

d)

Increased employee productivity

e)

Limited communication methods

64.

Which technology is crucial for mobile application development?

a)

Physical hardware

b)

Manual coding practices

c)

Static design principles

d)

In-person testing

e)

Programming languages

65.

What is the purpose of cloud storage?

a)

Eliminate data backup needs

b)

Keep files only on local devices

c)

Store data online for easy access

d)

Limit data accessibility

e)

Manage physical storage solutions

66.

What type of application is typically developed for mobile devices?

a)

Enterprise applications

b)

Server applications

c)

Web applications

d)

Desktop applications

e)

Native applications

67.

Which term describes the transition from traditional to cloud services?

a)

Network expansion

b)

System upgrade

c)

Application deployment

d)

Data migration

e)

Digital transformation

68.

Which format is commonly used for audio files?

a)

TXT

b)

EXE

c)

PDF

d)

DOC

e)

MP3

69.

What is the main purpose of multimedia software?

a)

Combine text, video, and sound

b)

Edit spreadsheets

c)

Create only text documents

d)

Perform complex mathematical calculations

e)

Design static graphics

70.

What is one benefit of multimedia in education?

a)

Increases reading time

b)

Enhances visual learning

c)

Limits interaction

d)

Reduces study materials

e)

Slows learning process

71.

What is a common multimedia presentation format?

a)
HTML
b)

PowerPoint

72.

Which of the following is a key feature of multimedia content?

a)

No use of audio components

b)

Static images without animation

c)

Interactivity between user and media

d)

Text-only format

e)

Single media type presentation

73.

What technology allows for the integration of text, audio, and video?

a)

Audio-only applications

b)

Multimedia technology

c)

Static image viewers

d)

Basic graphic design

e)

Text editing software

74.

What is the primary use of animation in multimedia?

a)

Store audio files

b)

Create lengthy text content

c)

Engage and inform audiences

d)

Limit audience interaction

e)

Display static images only

75.

Which tool is commonly used for video editing?

a)

Adobe Premiere Pro

b)

Excel

c)

PowerPoint

d)

Notepad

76.

What is the significance of resolution in multimedia?

a)

Limits the number of colors used

b)

Fixes sound quality issues

c)

Determines image clarity and quality

d)

Reduces file size significantly

e)

Increases loading time

77.

How can multimedia enhance presentations?

a)

Limits audience interaction

b)

Reduces overall presentation time

c)

Improves engagement and retention

d)

Focuses only on text

e)

Makes content harder to follow