Worksheetsict exam p2
Total questions: 77
Worksheet time: 39mins
Which data analysis technique is used to identify patterns or relationships in data through machine learning algorithms?
regression analysis
t-test
inferential statistics
clustering analysis
descriptive statistics
Which of the following devices is commonly used to connect multiple computers in a local area network (LAN)?
router
firewall
switch
modem
hub
What does the acronym "LAN" stand for in the context of computer networks?
local access network
longitudinal area network
local area network
large area network
landline area network
Which networking protocol is commonly used for sending and receiving emails?
HTTP
SMTP
FTP
UDP
TCP/IP
What is the primary purpose of a modem in a telecommunications system?
to convert digital data to analog signals for transmission over telephone lines
to provide wireless internet access
Which networking protocol is used to retrieve web pages from the World Wide Web?
HTML
FTP
HTTP
TCP/IP
POP3
What does "ISP" stand for in the context of networks and telecommunications?
interconnected switching platform
internet speed protocol
international security protocol
integrated system processor
internet service provider
Which network protocol is commonly used for sending and receiving emails?
FTP
TCP/IP
HTTP
POP3
SMTP
In telecommunications, what is the term for the modulation technique that allows digital data to be transmitted over analog telephone lines?
T1 line
microwave transmission
fiber optics
modem
What technology is used to transmit data wirelessly over short distances between devices such as smartphones and headphones?
ethernet
satellite communication
DSL
fiber optics
Bluetooth
What does "VoIP" stand for in the context of telecommunications?
video output and input processing
voice of intranet programs
voice over internet protocol
voltage over internet protocol
virtual optical interface port
What does "IP" stand for in the context of IP addressing?
internet port
internet provider
intranet protocol
internet protocol
information port
Which version of IP addresses is the most widely used and currently the dominant protocol on the internet?
IP version 6 (IPv6)
IP version 10 (IPv10)
IP version 4 (IPv4)
IP version 2 (IPv2)
IP version 8 (IPv8)
How many bits are in an IPv4 address?
32 bits
4 bits
8 bits
64 bits
16 bits
Which type of IP address is used to identify a specific device on a local network, typically assigned by a router?
APIPA address
static IP address
dynamic IP address
public IP address
private IP address
What is the purpose of subnetting in IP addressing?
to hide a device's IP address from the internet
to assign public IP addresses to all devices on a network
to divide a large network into smaller, manageable segments
to expand the size of the ipv4 address space
to encrypt IP addresses for security purposes
What is the purpose of an IP address in computer networking?
to determine the computer's brand and model
to connect to the internet
to identify a specific computer or device on a network
to route data packets to the correct website
to encrypt data for secure transmission
Which version of the Internet Protocol introduced 128-bit IP addresses?
IPv10
IPv6
IPv4
IPv2
In IPv4, how many bits are used to represent an IP address?
8 bits
32 bits
64 bits
128 bits
16 bits
What is the purpose of the subnet mask in IP addressing?
to assign a unique hostname to a device
to specify the network portion of an IP address
to determine the physical location of a device
to identify the type of device
to encrypt data in transit
What is the primary goal of cybersecurity?
to encourage the sharing of sensitive information
to provide unrestricted access to all users
to prevent all cyberattacks
to maximize network speed and performance
to protect computer systems and data from unauthorized access, attacks, and damage
What is a common method of authentication used in cybersecurity to verify a user's identity?
firewall
passwords
virus scan
Which cybersecurity practice involves making multiple copies of data to ensure it can be restored in case of data loss or cyberattacks?
phishing
data backup
encryption
antivirus scanning
firewall
What is the term for a malicious program or code that is disguised as a legitimate software application and can harm a computer system?
malware
antivirus
pharase
firewall
password
Which cybersecurity concept involves limiting the access rights of users and systems to only the necessary resources for their legitimate tasks?
encryption
least privilege principle
vulnerability assessment
authentication
intrusion detection
In spreadsheet editors like Microsoft Excel, what is the purpose of a formula?
to perform calculations using numerical data in cells
to insert images and graphics into a worksheet
to adjust the page layout of the spreadsheet
to change the font style of cell contents
Which function in spreadsheet software is used to find the highest value in a range of cells?
IF
SUM
COUNT
AVERAGE
MAX
What is the purpose of the "AutoFill" feature in spreadsheet editors?
to automatically generate a sequence of values or dates
to add comments and notes to cells
to create new worksheets
to change the cell formatting
to delete cells and data
In a spreadsheet, which type of chart is best suited for showing the relationship between two sets of data?
radar chart
line chart
bar chart
pie chart
scatter plot
What does it mean to "freeze" panes in a spreadsheet editor?
to lock specific rows or columns in place while scrolling through the sheet
to make the entire worksheet read-only
to delete selected cells
to hide all data in the spreadsheet
to prevent any changes from being made to the spreadsheet
In a spreadsheet editor, what is the purpose of a formula?
to insert a picture into a worksheet
to apply conditional formatting to a cell
to change the font style of a cell
to perform calculations on numerical data
What symbol is commonly used to indicate a cell reference in a formula within a spreadsheet?
@
%
#
&
$
In spreadsheet editors like Microsoft Excel, what is the function of the SUM function?
to create a chart
to insert a comment in a cell
to calculate the average of a range of numbers
to change the cell's formatting
to perform addition on a selected range of cells
Which type of chart is best suited for showing the distribution of data points and identifying outliers?
line chart
radar chart
bar chart
scatter plot
pie chart
What does it mean to "format" a cell in a spreadsheet editor?
to merge the cell with adjacent cells
to apply styling, such as font, color, and number format, to a cell
to delete the cell's content
to change the font style of a cell
to insert a picture into a worksheet
What is the primary purpose of MS PowerPoint in creating presentations?
to write code
to send emails
to create and deliver visual presentations
to edit photos
to browse the internet
What is a slide master in MS PowerPoint used for?
to create animations
to define the overall layout and formatting for all slides in a presentation
to record audio narration
to print handouts
to insert pictures into slides
What is a transition in MS PowerPoint?
a method for importing data
a way to print slides
a type of animation
a visual effect used to move from one slide to the next during a presentation
a sound effect
Which view in MS PowerPoint allows you to see and organize all the slides in a presentation as thumbnails?
slide show view
design view
slide sorter view
normal view
What is the purpose of speaker notes in MS PowerPoint?
to create hyperlinks
to provide additional information
to change the slide layout
to record audio narration
to add visual effects to slides
What is the primary purpose of MS PowerPoint?
to create and edit text documents
to design and deliver visual presentations
to send and receive emails
to create and edit images
to develop computer programs
Which tab in MS PowerPoint is used to access slide layouts, themes, and transitions?
format
insert
design
home
review
What is the default extension for saving a PowerPoint presentation?
.pptx
.txt
.doc
.xlsx
Which feature in MS PowerPoint allows you to rehearse and time your presentation?
presenter view
What is the purpose of the "Slide Master" in MS PowerPoint?
to create speaker notes
to insert images into slides
to define the overall look
to record and play audio during the presentation
to apply animations to text
What is the purpose of HTML tags?
to display images on web pages
to style web pages
to encrypt web page data
to create and structure the content of web pages
to create animations on web pages
What does the HTML tag represent?
a video
a table
a hyperlink
an image
a paragraph
Which protocol is used for secure communication over the internet?
UDP
HTTPS
FTP
TCP
What is the primary function of a web browser?
Run desktop applications
Create video content
Access web pages online
Store files locally on a device
Download software automatically
Which type of network is the internet classified as?
Office network
Personal area network
Wide area network
Home area network
Local area network
What is the role of DNS in internet technology?
Translates domain names to IP addresses
Hosts website content online
Manages internet data transmission
Routes network traffic between servers
Provides security encryption for websites
What does HTTP stand for in internet technologies?
Hypertext Technology Platform
Hyperlink Text Transfer Program
Hypertext Telecommunication Platform
High Transfer Telecommunication Protocol
Hypertext Transfer Protocol
What technology allows devices to communicate without a physical connection?
Satellite communication
Fiber optics
Wireless networking
Which technology enables remote access to data and applications?
Ethernet cables
Fiber optics
Cloud computing
Wireless networking
USB connections
What is the main purpose of an IP address?
Encrypt data transmissions
Identify devices on a network
Monitor internet usage
Store web content
Manage email accounts
What does the term "bandwidth" refer to?
Number of devices connected
Distance between network nodes
Physical size of a network cable
Data transfer capacity of a network
Speed of a computer processor
Which technology is commonly used for video conferencing?
FTP
SMS
VoIP
HTTP
What is the primary advantage of cloud computing?
Limited server access
Reduced hardware costs
Slower data processing
On-demand resource availability
Local file storage
Which service model offers software over the internet?
Platform as a service
Infrastructure as a service
Database as a service
Software as a service
Hardware as a service
What is a key feature of mobile applications?
Inability to run offline
Limited device compatibility
Access on portable devices
Manual data entry only
Fixed functionality
Which type of cloud is owned and operated by a single organization?
Private cloud
Distributed cloud
Community cloud
Public cloud
Hybrid cloud
What is the primary function of mobile cloud computing?
Delivering services through mobile devices
Limiting access to cloud-based software
Providing offline storage options
Storing data on physical servers
What is a common advantage of using mobile technology in business?
Decreased operational costs
Inflexible work hours
Slow response times
Increased employee productivity
Limited communication methods
Which technology is crucial for mobile application development?
Physical hardware
Manual coding practices
Static design principles
In-person testing
Programming languages
What is the purpose of cloud storage?
Eliminate data backup needs
Keep files only on local devices
Store data online for easy access
Limit data accessibility
Manage physical storage solutions
What type of application is typically developed for mobile devices?
Enterprise applications
Server applications
Web applications
Desktop applications
Native applications
Which term describes the transition from traditional to cloud services?
Network expansion
System upgrade
Application deployment
Data migration
Digital transformation
Which format is commonly used for audio files?
TXT
EXE
DOC
MP3
What is the main purpose of multimedia software?
Combine text, video, and sound
Edit spreadsheets
Create only text documents
Perform complex mathematical calculations
Design static graphics
What is one benefit of multimedia in education?
Increases reading time
Enhances visual learning
Limits interaction
Reduces study materials
Slows learning process
What is a common multimedia presentation format?
PowerPoint
Which of the following is a key feature of multimedia content?
No use of audio components
Static images without animation
Interactivity between user and media
Text-only format
Single media type presentation
What technology allows for the integration of text, audio, and video?
Audio-only applications
Multimedia technology
Static image viewers
Basic graphic design
Text editing software
What is the primary use of animation in multimedia?
Store audio files
Create lengthy text content
Engage and inform audiences
Limit audience interaction
Display static images only
Which tool is commonly used for video editing?
Adobe Premiere Pro
Excel
PowerPoint
Notepad
What is the significance of resolution in multimedia?
Limits the number of colors used
Fixes sound quality issues
Determines image clarity and quality
Reduces file size significantly
Increases loading time
How can multimedia enhance presentations?
Limits audience interaction
Reduces overall presentation time
Improves engagement and retention
Focuses only on text
Makes content harder to follow
