Font size
WorksheetsInformation Technology Basics Worksheet
Total questions: 150
Worksheet time: 1hrs 15mins
In MS Excel, identify the conditional function.
AVERAGEIF
MAX
AVERAGE
SUM
MIN
In MySQL, which command inserts data into a table?
INSERT
DELETE
JOIN
CREATE
SELECT
Information stored in a computer is recorded in which numeral system?
Binary
Decimal
Octal
Hexadecimal
Any numeral system
In computer memory, how much space does any character occupy?
1 byte
8 bytes
2 bytes
1 bit
9 bits
In MySQL, which command adds a new column to a table?
ALTER
SELECT
CREATE
JOIN
DELETE
What is the set of a computer’s physical devices called?
Hardware
Typical equipment
Software
Operating system
Firmware
Which set represents a basic configuration of a computer?
System unit, keyboard, monitor
Microprocessor, bus, interactive whiteboard
Joystick, streamer, hard drive
Memory module, modem
System unit, printer, monitor
Select the incorrectly written file name.
Alua/.doc
Alua$.doc
Alua\ .txt
alua.doc
alua.txt
What is the key feature of ROM?
Used for reading data only
Temporarily stores data
Stores user files permanently
Acts as the main processor
Used for network caching
Which memory is erased when the computer is turned off?
Temporary memory (RAM)
External memory for temporary storage
Read-only memory (ROM)
Cache stored on disk
Optical storage
What are the main types of printers?
Dot-matrix, laser, inkjet
Monitor, keyboard, mouse
Scanner, modem, web camera
Processor, RAM, motherboard
HDD, SSD, CD-ROM
Which device is not inside the system unit?
Keyboard
RAM
Motherboard
Hard drive (HDD/SSD)
Processor
Which device performs arithmetic and logical operations?
Microprocessor
Keyboard
Scanner
Punch cards
Monitor
Identify the devices that allow data input to a computer.
Keyboard, scanner
Monitor, printer
Printer, scanner
Joystick, monitor
Monitor, scanner
Service programs that provide additional capabilities and improve the computer’s performance are called:
Utilities
Word processor
System development tools
Application programs
Add-ons
What is the main function of an operating system?
Manage all hardware and provide a convenient user interface
Control the Internet network
Provide electrical power to the computer
Install antivirus protection
Create application programs
Identify the false statement about an operating system.
It is a peripheral of the computer
It loads when the computer starts
It manages system resources
It controls the computer
It interacts with the user
What role does the kernel (core) of an operating system play?
Controls hardware and coordinates processes
Installs application programs
Organizes data exchange between applications
Provides external protection for the computer
Sends files over the network
Information stored in a computer is recorded:
Using 0 and 1
In decimal digits
In any numerals
As text, graphics, and audio
As + and − signs
Information stored in a computer is recorded using:
The binary number system
The decimal number system
Any numeral system
Textual, graphical, and audio forms
The +/− system
In computer memory, how much space does any character occupy?
1 byte
1 bit
10 bits
16 bits
8 bytes
In computer memory, how much space does any character occupy?
8 bits
1 bit
10 bits
16 bits
8 bytes
1 byte consists of:
8 bits
1 bit
16 bits
1 byte
8 bytes
5 bytes are equal to:
40 bits
64 bits
1024 bits
1024 bytes
1 TB
Which set represents a basic configuration of a computer?
System unit, keyboard, monitor
Memory module, modem
Microprocessor, bus, adapter
System unit, printer, monitor
Joystick, streamer, hard drive
The electronic circuit that controls external computer devices is called a:
Adapter
Hard drive
Bus
Microprocessor
RAM
Monitor is used for:
Displaying graphical and textual information
Storing information
Exchanging information
Printing graphical and textual information to paper
Entering graphical and textual information
Printer types include:
Matrix, laser, inkjet
Matrix, monochrome
Dot
Ink, laser, inkjet
Tablet
Which of the following is not an input device:
Printer
Keyboard
Disk drive
Modem
Scanner
The device that performs arithmetic-logic operations is the:
Microprocessor
Memory
Mouse
Display
Keyboard
Identify the devices that allow data to be entered into a computer:
Keyboard, scanner
Monitor, scanner
Printer, joystick
Hard disk, bus
Adapter, microprocessor
Service programs that provide the user with additional capabilities are called:
Utilities
Interface systems
Word processors
Instrumental programs
Applications
Identify the false statement about an operating system:
A computer can work without an operating system
It loads when the computer is started
It communicates with the user
It controls the computer
It manages the computer’s resources
The process of converting information from one type to another is called:
Encoding
Formatting
Defragmentation
Scanning
Translation
Key that moves the cursor to the beginning of a line:
Home
End
PgUp
PgDn
Enter
Key that moves the cursor to the end of a line:
End
Home
PgUp
PgDn
Enter
Key that enables numeric output mode on the right side of the keyboard:
NumLock
End
PgUp
PgDn
Enter
To enter an uppercase letter by holding a key, you should press and hold:
Shift
End
Home
Insert
Enter
To type in uppercase letters continuously, you should use:
CapsLock
End
Home
Insert
Enter
The key that deletes the character to the left of the cursor is:
Backspace
CapsLock
Space bar
Shift
Delete
The key that inserts a space between words is:
Space bar
CapsLock
Backspace
Shift
Delete
Which group consists of operating systems:
Windows, MS-DOS, Unix
PageMaker, Corel Draw, PhotoShop
NC, WinCom, MS-DOS
Basic, Pascal, C+
Word, Excel, Unix
Which group is a set of system software:
Utilities, software shells, operating systems
PageMaker, Corel Draw, PhotoShop
Utilities, application programs
Word
Excel
Which of the following is a group of system programs:
DrWeb, MS-DOS, WinRAR
PageMaker, Corel Draw, PhotoShop
DrWeb, MS-DOS, MS Word
Text editor, operating system
Operating systems, Excel
Which protocol is used to transfer web pages over a network:
HTTP
FTP
XLS
DNS
DOC
The scientific and engineering field that studies the interaction between users and computer systems is:
Human–computer interaction
Multimedia
Computer
IPC
Cloud
Command files have the extensions:
.exe, .com, .bat
.prn, .lpt, .cm1
.aux, .nul, .con
.txt, .lex, .doc
.xls, .wri
The architecture level that defines the logical view of a database is the:
Conceptual level
Internal level
External level
Standard level
Application level
In MySQL, the command to create a table is:
CREATE TABLE
INSERT TABLE
DELETE TABLE
JOIN TABLE
SELECT TABLE
Temporarily deleted files are stored in the folder:
Recycle Bin
My Computer
Network Neighborhood
Taskbar
An operating system security system is:
Firewall
Unix
GNOME
File system
GUI
Select the types of operating system interface:
Graphical user interface (GUI)
Command-line interface (CLI)
File system
Device driver
In Windows, the Ctrl + C key combination performs the operation:
Copies data to the clipboard
Cuts data to the clipboard
In Windows, what action is performed by the key combination Ctrl + V?
Pastes the copied data from the clipboard
Copies the selected data to the clipboard
Cuts the selected data to the clipboard
Redoes the last operation
Which of the following is a system software program?
Dr.Web antivirus
MS Word
MS PowerPoint
MS Excel
MS Access
Informatics is defined as:
A scientific discipline that studies the laws and methods of collecting, storing, delivering, and using information via computers
A pedagogical discipline that studies information
A branch of science about information in general
A scientific discipline studying only methods of storing information
A science about the history and development of computing technology
What does a computer’s internal memory consist of?
ROM, RAM, and cache memory
External and small memory
Hard disk, CD-R, CD-RW, DVD-RW
Hard disk and USB drive
Hard disk and streamer
How many basic digits are in the octal numeral system?
Eight
Seven
Sixteen
Ten
Five
In the Windows environment, what does the Alt + F4 key combination do?
Closes a program window
Closes a document window
Closes a dialog box
Moves a window
Opens a document window
In the Windows environment, what does the Ctrl + F4 key combination do?
Closes a document window
Closes the main window
Closes a dialog box
Moves a window
Opens a document window
The term bit (binary digit) is an abbreviation for:
Binary digit
Decimal digit
Octal digit
Hexadecimal number
Tally mark
Select the correctly written spreadsheet formula:
SUM(A1:B3)
SUM(1A:B3)
SUM(1A-3B)
SUM(A1:3B)
SUM(A1-B3)
Identify the utility program:
Antivirus
MS Word
MS PowerPoint
MS Excel
MS Access
Which of the following are image (photo) file types?
.png
.dot
.doc
.xls
.txt
Which are application-layer Internet protocols?
HTTP, FTP
TCP, Wi‑Fi
Token Ring, Wi‑Fi
Wi‑Fi, Bluetooth
TCP, UDP
What is a file path?
The list of the disk and folders where the file is located
A file located on a disk
A file located in the current folder
The properties of a file
A shortcut to a file
In a file name, what does the part after the dot indicate?
The file format (extension)
A file property
The file size
That it is a shortcut
The file address
In Notepad, what is the default file type for saved files?
.txt
.doc
.rtf
.bat
.bmp
Which was the earliest operating system among the following?
Multics
Unix
DOS
Windows
Linux
What is the default file type in the WordPad editor?
.rtf
.exe
.bat
.xls
.mdb
In Windows, which characters are not allowed in a file name?
? " « » / \ : | *
Hyphen and non‑Latin letters
Uppercase letters
Lowercase letters
Digits
What is the file extension for a Microsoft Word 2007 document?
.docx
.xlsx
.xlsb
.mdb
.accs
Files created in which application commonly have the .bmp extension?
Paint
MS Excel
MS Word
MS Access
Notepad
In a word processor, which shortcut saves a file?
Ctrl + S
Ctrl + N
Ctrl + P
Ctrl + A
Ctrl + O
Which shortcut creates a new document?
Ctrl + N
Ctrl + P
Ctrl + S
Ctrl + A
Ctrl + O
Which shortcut opens a document?
Ctrl + O
Ctrl + N
Ctrl + P
Ctrl + S
Ctrl + A
Which shortcut sends a document to print?
Ctrl + P
Ctrl + N
Ctrl + U
Ctrl + S
Ctrl + A
Which of the following is an audio file format?
.mp3
.doc
.dot
.pptx
.txt
In Excel, what is the IF function used for?
Testing logical conditions
Summing a range of numbers
Sorting table data
Formatting cells
Symbols used in the octal number system:
0, 1, …, 7
0, 1
0, 1, …, 9, A, B, C, D, E, N
0, 1, …, 9, A, B, C, D, M, G
0–9
Properties of information:
objective, accessible, relevant
duration, capacity, actuality
authenticity, subjectivity
special
visuality, reliability, interval
Move the cursor one page up:
PgUp
PgDn
Backspace
End
Home
Types of printers:
dot‑matrix, laser, inkjet
dot‑matrix, monochrome
inkjet, laser, dot‑matrix
dot‑matrix, tablet, drum
tablet, handheld scanner, laser
Types of scanners:
flatbed, handheld, drum
dot‑matrix, laser, inkjet
dot‑matrix, flatbed, drum
flatbed, handheld, laser
inkjet, handheld, laser
Key that deletes the character to the right of the cursor:
Delete
Caps Lock
Backspace
Spacebar
Shift
Key that deletes the character to the left of the cursor:
Backspace
Spacebar
Shift
Delete
Insert
Move the cursor to the beginning of the line:
Home
End
PgUp
PgDn
Enter
RAM (main memory) is:
memory whose contents are erased when the computer is turned off
special memory for permanent storage of information
external memory for permanent storage of information
memory whose contents are not erased when the computer is turned off
a disk intended for transport
The main function of the motherboard:
connect and control all devices
control only the processor
supply the computer with power
process audio signals
store files
Computer components:
hardware and software
information and software
hardware and peripherals
system and application
hardware only
Delete a file without sending it to the Recycle Bin:
Shift+Del
Del
Backspace
Shift+Backspace
Alt+F4
MySQL command to search rows by pattern:
LIKE
LIMIT
INSERT
JOIN
HAVING
MySQL data types for approximate floating‑point numbers:
FLOAT, REAL
INT
INTEGER
TEXT
BIGINT
MySQL command to remove duplicate rows from results:
DISTINCT
INSERT
LIKE
ORDER BY
LIMIT
In MS Word, to select all text:
Ctrl+A
Ctrl+N
Ctrl+E
Ctrl+U
Ctrl+P
In MS Excel, remove duplicate data (choose the function/command name):
UNIQUE
SEQUENCE
TEXTJOIN
SORT
FILTER
SQL command to create a table:
CREATE TABLE
INSERT INTO
SELECT
UPDATE
ORDER BY
SQL command to add (insert) data:
INSERT INTO
CREATE TABLE
SELECT
UPDATE
ORDER BY
SQL command to update data:
UPDATE
INSERT INTO
SELECT
CREATE TABLE
ORDER BY
SQL command to sort results:
ORDER BY
INSERT INTO
SELECT
UPDATE
DELETE
SQL command to view data:
SELECT
INSERT INTO
ORDER BY
UPDATE
DELETE
SQL command to join tables:
JOIN
INSERT INTO
SELECT
UPDATE
DELETE
In MS Excel, by default text is aligned:
left
center
right
justified by width
justified by length
In MS Excel, by default numbers are aligned:
right
center
left
justified by width
justified by length
Which of the following is not a program in the MS Office suite:
Visual Studio
Word
Excel
PowerPoint
Access
In Windows, which set lists the available calculator modes?
Standard, Scientific, Programmer, Statistics
Complex, Numeric
Complex, Scientific
Programmable
Numeric, Statistics, Standard
Which key moves the cursor one page down?
PgDown
Backspace
End
Home
PgUp
Which programs are used to create databases?
SQL and Access
SQL and Word
Excel and Word
Word and Excel
Access and PowerPoint
In MS Excel, which function is used to find the number of non-empty cells?
COUNT
SUM
AVERAGE
MAX
MIN
In MS Excel, data in a cell that contains a calculation begins with which symbol?
=
+
*
/
-
Which of the following is an application software program?
MS Excel
Utility program
Archivers
Operating system
Antivirus
MS Excel: Which formula is written correctly?
A3+A4+5
A3+A4+6A
A1+A2+3A
A1+2A
1A+2A
Which of the following is an application software program?
MS Word
Utility program
Archivers
Operating system
Antivirus
Which keyboard shortcut is used to print a document?
Ctrl + P
Ctrl + C
Ctrl + A
Ctrl + L
Ctrl + S
Which of the following are computer peripheral devices?
Printer, scanner, modem
Monitor, system unit, keyboard
Monitor, keyboard, scanner
Scanner, keyboard, modem
Printer, monitor, mouse
MS Excel: Which of the following formulas is written correctly?
A1$* SUM(F1:F4)
1A+5/B4
3F - SUM(A1:A5)
SUM(C5-C30)
SUM(A1:B14) - 1A/B14
What is the complex multilayer board to which all internal components are connected?
Motherboard
Monitor
Scanner
Keyboard
Modem
What is considered the brain of the computer?
Microprocessor
Monitor
Scanner
Keyboard
Modem
Which device performs operations such as addition and subtraction?
Arithmetic–logic unit
Control unit
Printer
Scanner
Input/output devices
Which device temporarily stores information in binary form?
Register
Input devices
Control unit
Output devices
Auxiliary device
Which of the following is an archive file type?
.rar
.dot
.xls
.jpg
Which of the following is an archive file type?
.zip
.dot
.xls
.jpg
MS Excel spreadsheet processor provides which capabilities?
Processing tabular data
Applying animations to data
Creating embedded objects of various types
Creating images
Formatting data by width
What is the typical file extension for web pages?
.html
.dot
.png
.jpg
What are the main types of software?
System, application, and programming languages
Primary and peripheral
Command and peripheral
Internal and external
Service and hardware
In a spreadsheet, the range A1:F6 is selected. How many cells are in this range?
36
5
32
4
7
Identify an operating system.
Linux
MS Excel
MS Word
AI
RAMAC
Identify an operating system.
macOS
MS Excel
MS Word
AI
RAMAC
Monolithic kernels are used by which operating systems?
Linux and Unix
MS-DOS
Windows NT and macOS
Windows NT
In a local network, which device connects multiple devices?
Switch
Modem
Router
Host
USB
MS Excel. In the Excel spreadsheet processor, what is the minimal element intended for data entry?
Cell
Block
Column
Row
Range
Networks are classified by the geographic area they cover. Which grouping reflects this?
LAN, CAN, MAN
Bus, ring
Mesh, CAN, IaaS
Hybrid, personal, private
Relation, GAN, WAN
Which application creates files with the .xls extension?
MS Excel
MS Word
Paint
MS Access
Notepad
Which of the following is a static multimedia document type?
Tabular
Video
Animation
Image
GIF format
Types of IP addresses include which of the following?
Static, dynamic
Statistical, didactic
Mathematical, dynamic
Logical, dynamic
Time/period
Which of the following is a dynamic multimedia type?
Video material
Table
DBMS
Text editor
Operating system
MS Excel. The functions MIN, MAX, and AVERAGE belong to which category?
Statistical
Mathematical
DBMS
Logical
What is a computer virus?
A type of malicious program that attaches to other programs, self-replicates, and spreads from one computer to another
Information installed for easy access, management, and updating
A set of connected computers, servers, mainframes, network devices, peripherals, or other devices that enable shared use of data
An organized collection of information or data usually stored electronically in a computer system
A group of two or more computers or other electronic devices connected for data exchange
MS Excel. The functions IF, AND, and OR belong to which category?
Logical
Statistical
DBMS
Mathematical
Time/period
Which of the following is one of the main objects of a database?
Tables
Slides
Connection
Drawings
Charts
What are the types of cloud computing?
Private clouds, public clouds, hybrid
Public clouds, hybrid, bus
Private clouds, public clouds, ring
Private clouds, public clouds, hybrid clouds, tree
Private clouds, public clouds, CAN, WAN
Which protocol is used to send email messages?
SMTP
FTP
HTTPS
IMAP
HTTP
How are networks classified by the transmission medium?
Wired, wireless
Departmental, state
Wired, high-bandwidth
By radio channels, corporate
Local, regional, wide-area
Database. Which list shows database model types?
Hierarchical, relational, hybrid
Hierarchical, personal
Relational, public
Conceptual, object-oriented
Basic, hybrid
Which cloud technology level consists of physical assets such as servers, network devices, disks, etc.?
Infrastructure level (IaaS)
Monitoring as a Service (MaaS)
Software as a Service (SaaS)
Platform as a Service (PaaS)
Communication as a Service (CaaS)
Monitoring as a Service (MaaS) corresponds to which cloud technology level description?
A security tool delivered in the cloud
Consists of physical assets such as servers, network devices, disks, etc.
Cloud-based management of hardware and software
Distributing software accessible to clients via the internet
Providing an integrated platform for developing, testing, deploying, and supporting web applications
What are the types of network topology?
Bus, star, ring
Bus, star, host
Star, ring, diagram
Bus, star, query
Bus, star, server
Which type of database treats data as objects?
Object-oriented
Hierarchical
Relational
Matrix
Index
In HTML, what is the function of the HR tag?
Draws a horizontal line on the screen
Center-aligns text on the line
Center-aligns the text in the line
Creates a table
Changes the background
Which virus type modifies macros in programs like Microsoft Word and Excel, filling them with malicious code?
Macro viruses
Antivirus
System virus
Trojan virus
Worm
