NEW
Font size
WorksheetsInformation Technology Quiz
Total questions: 45
Worksheet time: 23mins
A school is implementing an online student management system. Which aspect of Information Technology does this system most relate to?
Hardware infrastructure
Data storage and retrieval
Network security
Peripheral devices
A company wants to improve its customer service using an AI chatbot. This is an example of:
Database management
Artificial intelligence application
Spreadsheet automation
Embedded systems
A weather forecasting agency needs a powerful computer to process massive amounts of climate data. Which type of computer should they use?
Mainframe
Supercomputer
Desktop
Mobile device
A retail chain requires a system to process sales data in real-time across multiple locations. Which type of computer is most suitable?
Mainframe
Desktop computer
Laptop
Game console
A business executive who travels frequently needs a computer that is portable, lightweight, and capable of handling office tasks. Which device is most appropriate?
Supercomputer
Mainframe
Laptop
Embedded system
A cashier scans a barcode, and the product’s price appears on the screen. Which stage of the IPOS cycle is taking place when the price is displayed?
Input
Processing
Output
Storage
A photographer stores high-resolution images and videos on his computer. Which type of storage would be best for long-term archival?
RAM
SSD
CD-ROM
External hard drive
An engineer is developing a smart thermostat that can adjust room temperature automatically. What type of computer system does the thermostat use?
Mainframe
Embedded system
Supercomputer
Desktop computer
A company wants to access its files from any location and ensure data security. Which storage option is best?
Flash drive
Local hard drive
Cloud storage
Optical disk
A graphic designer works with large multimedia files that require frequent offline access. Which storage option is best?
Cloud storage
Local SSD
Flash drive
DVD
A factory automates its product packaging by scanning items with a sensor. Which type of input device is most appropriate?
Joystick
Optical Mark Reader
Barcode Scanner
Biometric Scanner
A doctor uses a voice recognition system to dictate patient records. Which type of input device is being used?
Optical Scanner
Microphone
Biometric Reader
Barcode Scanner
A hotel wants to install software to manage guest reservations, staff schedules, and billing. What type of software is best suited for this?
System software
Utility software
Application software
Embedded software
A video game developer needs to install an operating system before working on game design software. What type of software is the operating system?
Application software
System software
Utility software
Database software
A visually impaired user needs a system that reads text aloud. Which type of user interface should be used?
Graphical user interface (GUI)
Command-line interface
Touch interface
Voice interface
An ATM machine allows customers to select options from a screen using a touchpad. What type of user interface does it use?
Command-line
Menu-driven
Graphical user interface
Command-driven
A lawyer needs to track edits made to a legal contract. Which word processing feature should they use?
AutoCorrect
Track Changes
Mail Merge
Text Wrapping
A student needs to include automatic citations in a research paper. Which document processing feature would be most helpful?
Mail Merge
Footnotes
AutoCorrect
Spelling and Grammar Check
A sales manager wants to calculate total revenue using a formula. Which spreadsheet function is most appropriate?
SUM
AVERAGE
COUNT
VLOOKUP
A teacher wants to display student performance trends over a semester. Which chart type is most suitable?
Pie chart
Line chart
Bar chart
Scatter plot
A hospital needs to ensure that each patient’s record is uniquely identified. Which database feature should be used?
Foreign key
Primary key
Candidate key
Secondary key
A supermarket uses a database to keep track of inventory. Which database object is used to retrieve specific product details?
Table
Query
Form
Report
A student is designing an algorithm to determine if a number is even or odd. Which logical condition should be used?
If number > 0
If number / 2 = 0
If number / 2 > 1
If number = 2
A programmer wants to execute a block of code multiple times until a condition is met. Which control structure should they use?
IF-THEN
FOR Loop
WHILE Loop
CASE statement
A user’s computer screen remains black even though the computer is turned on. What is the most likely cause?
Loose power cable
Corrupt operating system
Printer malfunction
Outdated software
A user’s laptop battery drains quickly, even when not in use. What is the most probable cause?
Incorrect display settings
Loose charging port
Overloaded RAM
Weak battery health
A supermarket wants to track sales and generate reports. Which application software should they use?
Word Processor
Spreadsheet
Database Management System
Presentation Software
A business wants to automate sending personalized emails to multiple clients. Which feature should they use?
Spell Check
Track Changes
Mail Merge
AutoCorrect
A school administrator wants to ensure students cannot edit official documents. What security feature should they apply?
Header and Footer
Password Protection
Page Break
AutoSave
What does Information Technology primarily deal with?
The study of human behaviour
The use of computers and software to manage information
The study of electrical circuits
The development of mechanical devices
Which type of computer is best suited for complex scientific calculations?
Mainframe
Supercomputer
Desktop
Embedded system
A bank requires a powerful computer to handle millions of transactions per day. Which type of computer is most appropriate?
Supercomputer
Mainframe
Laptop
Tablet
Which of the following devices is considered an embedded system?
Desktop computer
Microwave controller
Gaming laptop
Smartphone
What is the function of RAM in a computer system?
Stores permanent data
Temporarily holds data for processing
Manages hardware components
Controls input and output operations
Which storage device offers the largest capacity for long-term storage?
RAM
Hard disk
CD
Flash drive
What is the correct sequence of the IPOS cycle?
Input → Storage → Output → Processing
Input → Processing → Storage → Output
Processing → Input → Output → Storage
Output → Input → Processing → Storage
Which of the following is a disadvantage of cloud storage?
High capacity
Internet dependency
Limited security measures
Read-only access
What type of input device is best suited for a bank's check processing system?
Optical Mark Reader (OMR)
Magnetic Ink Character Recognition (MICR)
Barcode Scanner
Joystick
A graphic designer requires a high-quality visual output device. Which device should be recommended?
Dot Matrix Printer
Inkjet Printer
Laser Printer
3D Printer
Which of the following is an example of system software?
Microsoft Word
Windows OS
Photoshop
Google Chrome
A software package that includes a word processor, spreadsheet, and presentation software is called:
Custom software
Integrated software
Utility software
Firmware
Which user interface requires users to type specific commands?
GUI
Menu-driven
Command-line interface
Touch interface
Which feature allows a document to automatically update its table of contents?
Word Wrap
Auto-numbering
Auto Table of Contents
Find and replace
What document feature is used to restrict editing by unauthorized users?
Spell Check
Track Changes
Password Protection
Page Break
What function would you use to count the number of non-empty cells in a range?
COUNT
COUNTA
SUM
AVERAGE
