WorksheetsIC3 Basics LEVEL 2
Total questions: 50
Worksheet time: 50mins
Which of the following file extensions is commonly associated with spreadsheet files?
.docx
.xlsx
.pptx
.txt
What is the primary purpose of an antivirus program?
To speed up the computer
To detect and remove malicious software
To compress files
To manage disk space
In a spreadsheet, what does the function =SUM(A1:A10) do?
Counts cells from A1 to A10
Finds the average of cells A1 to A10
Adds all values in cells A1 through A10
Multiplies cells A1 through A10
Which keyboard shortcut is used to copy selected items?
Ctrl + X
Ctrl + V
Ctrl + C
Ctrl + Z
What does RAM stand for?
Random Access Memory
Read Always Memory
Remote Access Module
Runtime Application Manager
Which cloud storage service is developed by Microsoft?
Google Drive
iCloud
OneDrive
Dropbox
What is phishing?
A type of computer virus
A method of backing up data
An attempt to steal personal information through deceptive means
A way to compress files
Which file system permission allows a user to modify a file?
Read
Write
Execute
Hidden
What type of chart best displays parts of a whole?
Line chart
Bar chart
Pie chart
Scatter plot
Which device is an example of volatile memory?
Hard drive
RAM
USB flash drive
DVD-ROM
What is the purpose of a firewall?
To cool down the computer
To monitor and control network traffic
To store backup files
To improve display resolution
Which of these is a valid IP address format?
192.168.1.256
192.168.1.1
192.168.1
192.168.1.1.1
What does CPU stand for?
Computer Processing Unit
Central Processing Unit
Control Processing Unit
Central Program Utility
Which file extension is typically used for digital images?
.doc
.mp3
.jpg
.exe
What is the main function of an operating system?
To provide internet access
To manage hardware and software resources
To create documents
To send emails
Which network type typically covers a single building?
WAN
LAN
PAN
MAN
What is the purpose of HTTPS?
To make websites load faster
To secure data transmission
To store website data
To block advertisements
Which storage device typically has the fastest access speed?
Hard Drive
SSD
DVD
USB Flash Drive
What does URL stand for?
Universal Resource Locator
Unified Resource Link
Universal Reference Link
Unified Resource Locator
Which file compression format is most common?
.zip
.doc
.exe
.jpg
A strong password should contain at least 8 characters, including numbers, symbols, and both upper and lowercase letters.
TRUE
FALSE
RAM is a type of permanent storage.
TRUE
FALSE
CTRL + Z is used to undo the last action.
TRUE
FALSE
All file extensions must be three letters long.
TRUE
FALSE
A firewall can protect against all types of cyber attacks.
TRUE
FALSE
Cloud storage requires an internet connection to access files.
TRUE
FALSE
The same file can be saved in different file formats.
TRUE
FALSE
All wireless networks are automatically secure.
TRUE
FALSE
A CPU's clock speed is measured in hertz.
TRUE
FALSE
Cookies are always harmful to your computer.
TRUE
FALSE
The process of converting data into a code to prevent unauthorized access is called (a) .
A (a) is a collection of related records in a database.
The (a) key is used with other keys to perform special functions.
A (a) backup copies only files that have changed since the last backup.
The main circuit board in a computer is called the (a) .
A (a) is a malicious program that can replicate itself.
The (a) view in Windows shows a hierarchical display of folders.
A (a) is a unique identifier assigned to each device on a network.
The process of arranging data in a specific order is called (a) .
A (a) is a collection of computers and devices connected together.
Explain the difference between RAM and ROM.
Describe three characteristics of a strong password.
What is the difference between copying and moving a file?
List three ways to protect your computer from malware.
Explain the purpose of defragmenting a hard drive.
Create a folder structure for organizing your digital photos. Include at least three main folders and two subfolders each. Explain your organization method.
You receive an email asking for your bank account information. Describe three ways to verify if this email is legitimate.
Your computer is running slowly. List five steps you would take to improve its performance.
Create a basic spreadsheet formula to calculate the average of five test scores. Show your work and explain each part of the formula.
Design a backup strategy for your important files. Include frequency, storage location, and file selection criteria.
