WorksheetsMade in SHYMKENT
Total questions: 150
Worksheet time: 1hrs 15mins
What is the primary purpose of an operating system?
Managing hardware resources
Running applications
Printing documents
Which HTML element is used to define the structure of a webpage, such as headings, paragraphs, and lists?
<body>
<structure>
<content>
What is the purpose of data classification in data management?
To categorize data based on its sensitivity and importance
To randomly organize data
To assign a value to data for taxation purposes
What is a data repository in the context of data management?
A database management system
A specialized data analysis software
A physical storage room for data servers
What does the term "data governance" refer to in data management?
The practice of managing data as an organizational asset
A legal framework for data protection
The process of cleaning and formatting data
In data management, what is data deduplication?
The act of removing duplicate or redundant data entries
The process of collecting data from multiple sources
The practice of deleting all data backups
In HTML, what does the <img> tag represent?
An image
A video player
An audio player
What is data management?
The practice of organizing and maintaining digital data throughout its lifecycle
The process of storing physical documents in a filing cabinet
A method for encrypting sensitive information
Which feature in MS PowerPoint allows you to rehearse and time your presentation?
Presenter View
Animation
Spell Check
What is the purpose of the "Slide Master" in MS PowerPoint?
To define the overall look and formatting of slides in a presentation
To insert images into slides
To create speaker notes
What does HTML stand for?
Hypertext Markup Language
Hyper Transfer Text Language
Hypertext and Text Markup Language
- Which HTML tag is used to create a hyperlink?
<a>
<link>
<url>
What is the purpose of HTML tags?
To create and structure the content of web pages
To style web pages
To display images on web pages
Which HTML tag is used for creating an unordered list?
<ul>
<ol>
<li>
What does the HTML <img> tag represent?
An image
A paragraph
A hyperlink
What does HTML stand for?
Hypertext Markup Language
Hyper Transfer Markup Language
Hypertext Transfer Protocol
Which HTML tag is used to create a hyperlink?
<a>
<url>
<link>
What is the purpose of HTML tags?
To provide semantic meaning and structure to content
To style a webpage with CSS
To create interactive animations
- What is the default extension for saving a PowerPoint presentation?
.pptx
.doc
What is the primary purpose of MS PowerPoint?
To design and deliver visual presentations
To create and edit text documents
To send and receive emails
Which tab in MS PowerPoint is used to access slide layouts, themes, and transitions?
Design
Home
Insert
What is the purpose of speaker notes in MS PowerPoint?
To provide additional information or reminders for the presenter
To add visual effects to slides
To create hyperlinks
In telecommunications, what is the term for the modulation technique that allows digital data to be transmitted over analog telephone lines?
Modem
DSL
Fiber optics
What is a common method of authentication used in cybersecurity to verify a user's identity?
To protect computer systems and data from unauthorized access, attacks, and damage
To prevent all cyberattacks
To provide unrestricted access to all users
What is a common method of authentication used in cybersecurity to verify a user's identity?
Passwords
Encryption
Virus scan
- Which cybersecurity practice involves making multiple copies of data to ensure it can be restored in case of data loss or cyberattacks?
Data backup
Phishing
Encryption
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
Firewall
Password
Which cybersecurity concept involves limiting the access rights of users and systems to only the necessary resources for their legitimate tasks?
Least privilege principle
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 change the font style of cell contents
To insert images and graphics into a worksheet
Which function in spreadsheet software is used to find the highest value in a range of cells?
MAX
SUM
AVERAGE
What is the purpose of the "AutoFill" feature in spreadsheet editors?
To automatically generate a sequence of values or dates
To delete cells and data
To create new worksheets
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 prevent any changes from being made to the spreadsheet
To hide all data in the spreadsheet
- In a spreadsheet editor, what is the purpose of a formula?
To perform calculations on numerical data
To change the font style of a cell
To insert a picture into a worksheet
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 perform addition on a selected range of cells
To change the cell's formatting
To create a chart
Which type of chart is best suited for showing the distribution of data points and identifying outliers
Scatter plot
Bar chart
Pie chart
What does it mean to "format" a cell in a spreadsheet editor?
To apply styling, such as font, color, and number format, to a cell
To delete the cell's content
To change the cell's size
What is the primary purpose of MS PowerPoint in creating presentations?
To create and deliver visual presentations
To send emails
To edit photos
What is a slide master in MS PowerPoint used for?
To define the overall layout and formatting for all slides in a presentation
To insert pictures into slides
To create animations
What is a transition in MS PowerPoint?
A visual effect used to move from one slide to the next during a presentation
A type of animation
A method for importing data
Which view in MS PowerPoint allows you to see and organize all the slides in a presentation as thumbnails?
Slide Sorter view
Normal view
Outline view
In a spreadsheet, which type of chart is best suited for showing the relationship between two sets of data?
Line chart
Bar chart
Pie chart
What technology is used to transmit data wirelessly over short distances between devices such as smartphones and headphones?
Bluetooth
Ethernet
DSL
What does "VoIP" stand for in the context of telecommunications?
Voice over Internet Protocol
Virtual Optical Interface Port
Video Output and Input Processing
Which version of IP addresses is the most widely used and currently the dominant protocol on the internet?
IP version 4 (IPv4)
IP version 2 (IPv2)
IP version 6 (IPv6)
Which type of IP address is used to identify a specific device on a local network, typically assigned by a router?
Private IP address
Static IP address
Public IP address
What is the purpose of subnetting in IP addressing?
To divide a large network into smaller, manageable segments
To expand the size of the IPv4 address space
To hide a device's IP address from the internet
What does "IP" stand for in the context of IP addressing?
Internet Protocol
Internet Provider
Information Port
What is the purpose of an IP address in computer networking?
To identify a specific computer or device on a network
To determine the computer's brand and model
To encrypt data for secure transmission
Which version of the Internet Protocol introduced 128-bit IP addresses?
IPv6
IPv2
IPv4
In IPv4, how many bits are used to represent an IP address?
32 bits
8 bits
16 bits
What is the purpose of the subnet mask in IP addressing?
To specify the network portion of an IP address
To identify the type of device
To encrypt data in transit
What is the primary goal of cybersecurity?
To protect computer systems and data from unauthorized access, attacks, and damage
To prevent all cyberattacks
To provide unrestricted access to all users
How many bits are in an IPv4 address?
32 bits
4 bits
8 bits
What does "IP" stand for in the context of IP addressing?
Internet Protocol
Internet Provider
Information Port
Which network protocol is commonly used for sending and receiving emails?
SMTP
HTTP
FTP
In the context of medical databases, what is the significance of data validation rules?
They ensure data accuracy and consistency by enforcing data entry rules.
They determine which medical procedures to perform.
They schedule appointments for patients.
What does "ISP" stand for in the context of networks and telecommunications?
Internet Service Provider
Internet Service Provider
Internet Speed Protocol
Which network topology is characterized by a central hub or switch with all devices connected to it directly?
Star
Bus
Ring
In a bus topology, how are devices connected to the main cable?
They connect directly to the main cable.
They connect to a central hub.
They connect to a central server.
What is a disadvantage of a ring topology?
If one device fails, the entire network can fail.
It is difficult to set up.
It requires a lot of cabling.
Which network topology provides the highest level of redundancy and fault tolerance?
Mesh
Star
Bus
Which network topology connects all devices to a central hub or switch, forming a star-like structure?
Star topology
Mesh topology
Bus topology
In which network topology does each device connect to exactly two other devices, forming a circular structure?
Ring topology
Mesh topology
Bus topology
What type of network topology connects each device to every other device in the network, creating redundancy and reliability?
Mesh topology
Bus topology
Ring topology
Which network topology uses a central cable to which all devices are connected, and data is transmitted to all devices on the network?
Bus topology
Mesh topology
Ring topology
In which network topology does a combination of two or more different topologies connect to form a larger network structure?
Hybrid topology
Mesh topology
Bus topology
What is the process of examining, cleaning, transforming, and modeling data to discover useful information, draw conclusions, and support decision-making called?
Data storage
Data collection
Data visualization
Which statistical measure represents the middle value of a dataset and is not affected by extreme outliers?
Median
Mean
Mode
In data analysis, what does the acronym "EDA" stand for?
Exploratory Data Analysis
Effective Data Assessment
Expert Data Analytics
Which data analysis technique involves finding patterns and relationships in data to make predictions about future outcomes?
Predictive analysis
Inferential statistics
Regression analysis
What is the term for the graphical representation of data using bars to compare values in different categories?
Bar chart
Line chart
Pie chart
What is the primary goal of data analysis?
Extracting useful insights and information from data
Data collection
Data visualization
Which statistical measure represents the average of a dataset and is often used in data analysis?
Mean
Median
Mode
Which data analysis technique is used to discover hidden patterns or groups within a dataset?
Clustering
Regression analysis
Descriptive statistics
What is the purpose of hypothesis testing in data analysis?
To determine if a particular assumption about a population is valid or not
To clean and preprocess data
To visualize data using charts and graphs
What is the first step in the data analysis process?
Collecting data
Creating data visualizations
Drawing conclusions
Which statistical measure is used to describe the central tendency of a dataset?
Median
Standard deviation
Variance
What is the term for a graphical representation of data that displays the distribution of values along a continuous scale?
Histogram
Pie chart
Scatter plot
Which data analysis technique is used to identify patterns or relationships in data through machine learning algorithms?
Clustering analysis
Descriptive statistics
Inferential statistics
What is the purpose of hypothesis testing in data analysis?
To determine the statistical significance of an observed effect
To summarize data using statistics
make predictions about future data
Which of the following devices is commonly used to connect multiple computers in a local area network (LAN)?
Switch
Router
Modem
What does the acronym "LAN" stand for in the context of computer networks?
Local Area Network
Large Area Network
Local Access Network
Which networking protocol is commonly used for sending and receiving emails?
SMTP
TCP/IP
HTTP
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 connect to a local area network (LAN)
To route data between devices in a network
Which networking protocol is used to retrieve web pages from the World Wide Web?
HTTP
HTML
FTP
In data analysis, what does the term "correlation" refer to?
The strength and direction of a relationship between two variables
A type of data visualization chart
The process of data collection
What is network topology?
The arrangement of network devices and connections
The speed of a network connection
The process of securing a network
Which type of interface relies on physical sensations like vibrations or forces to provide feedback to the user?
Haptic interface
Graphical user interface (GUI)
Virtual reality interface (VR)
In a voice recognition interface, what is the main mode of input?
Speaking commands or text aloud
Typing on a keyboard
Moving a mouse
What is the benefit of using a natural language interface in human-computer interaction?
It allows users to communicate with the computer using everyday language
It requires specialized hardware
Hardware Control Interface
What is the primary role of Microsoft Access in a medical database system?
To manage and organize medical data
To perform surgeries
To diagnose medical conditions
What is the primary function of the "Reports" feature in Microsoft Access for medical databases?
To generate customized reports, such as patient summaries or billing statements
To schedule surgeries
To perform medical imaging scans
In a medical database, what type of information is typically stored in the "Patient Information" table?
Patient demographics and medical history
Employee work schedules
Medical billing records
Which of the following best describes the purpose of an Electronic Medical Record (EMR) system?
Storing and organizing patient health information electronically
Managing hospital finances
Conducting medical research experiments
What is the role of a menu-driven interface?
To display a list of options for the user to choose from
To provide a touch-sensitive screen
To hardware Control Interface
Which of the following is an example of an assistive technology interface designed for individuals with disabilities?
Screen reader software
Virtual reality interface
Augmented reality interface
Which of the following is not a major type of operating system?
Graphical operating system
Real-time operating system
Network operating system
«…”. is the main function of a device driver in an operating system.
Manage hardware resources
Run applications
Network operating system
Which of the following is not a major type of operating system?
Web-based operating system
Real-time operating system
Network operating system
What is the role of the kernel in an operating system?
Interacting with hardware
Interacting with the user
Managing application software
Which operating system is known for its open-source nature and is often used in server environments?
Linux
Windows
Android
«…” does the acronym GUI stand for in the context of operating systems.
Graphic User Interface
Graphical User Input
General Utility Interface
- In the context of operating systems, what is a process?
A part of the CPU
An independent program or task
An application
Which of the following is NOT a common function of an operating system?
Graphics design
Memory management
File management
- «…” is the purpose of a file system in an operating system.
To organize and manage files on storage devices
Global User Interaction
To create graphical user interfaces
Which type of kernel architecture separates core functions into separate modules, enhancing modularity?
Microkernel
Monolithic kernel
Global User Interaction
What is the primary purpose of an operating system?
Managing hardware resources
Running applications
Printing documents
«…” is software.
The programs and data used by a computer.
The physical components of a computer.
Global User Interaction
Which of the following is an example of system software?
Windows Operating System
Microsoft Word
Photoshop
- What type of software allows you to perform specific tasks, such as word processing or spreadsheet calculations?
Application software
System software
Android
Which software is designed to protect a computer from viruses, malware, and other security threats?
Antivirus software
Web browser
Android
- “…” is open-source software.
Software whose source code is freely available, allowing anyone to view, modify, and distribute it.
Software that is available for free download.
Word processing software
Which of the following is an example of a proprietary software?
Microsoft Office
Mozilla Firefox
Linux
What does the term "freeware" mean in the context of software?
Software that is always free and has no restrictions on its usage.
Software that is free to use for a limited trial period.
Software that is free but requires a paid license for advanced features.
- Which software category includes tools for managing and maintaining the computer's hardware and software components?
Utility software
Application software
Word processing software
What is the purpose of a web browser software?
To access and view websites and web content.
To edit photos and images.
To create documents and spreadsheets.
Which software type provides a bridge between the user and the computer hardware, managing resources and facilitating communication between the two?
System software
Application software
Utility software
Which of the following is an example of system software?
Windows Operating System
Microsoft Word
Adobe Photoshop
“…” type of software is designed for specific tasks, such as word processing or graphic design.
Application software
System software
Utility software
Which of the following is an example of freeware?
VLC Media Player
Microsoft Office
Adobe Photoshop
What is the purpose of an operating system's utility software?
To maintain and optimize system performance
To create documents and spreadsheets
To design graphics and images
Which type of software is permanently stored in hardware and cannot be easily updated or changed?
Firmware
Open-source software
Shareware
“…” is the term for software that is distributed for free, but users are encouraged to make voluntary payments if they find it useful.
Shareware
Commercial software
Freeware
What is the role of a software license?
To specify the terms and conditions under which the software can be used
To restrict users from using the software
To prevent software from being installed
Which component of a computer system is responsible for temporarily storing data that the CPU is actively using?
RAM (Random Access Memory)
Hard drive
Managing network connections
That is the purpose of the BIOS (Basic Input/Output System) in a computer system.
Initializing hardware components and booting the computer
Displaying graphics on the screen
Storing the operating system
Which type of storage device is known for its fast data access times but is typically smaller in capacity compared to traditional hard drives?
SSD (Solid State Driv
Optical drive
Magnetic tape
What is the purpose of the GPU (Graphics Processing Unit) in a computer system?
Displaying graphics and rendering images
Performing mathematical calculations
Managing network connections
Which computer architecture uses a single central processing unit to execute instructions one at a time?
CISC (Complex Instruction Set Computer)
RISC (Reduced Instruction Set Computer)
Managing network connections
What is the purpose of the bus in a computer system?
To transfer data between hardware components
To store data permanently
To connect external devices like printers
In a von Neumann architecture, which two major components share the same memory for both program instructions and data?
CPU and RAM
CPU and GPU
RAM and ROM
“…” is the central processing unit (CPU) responsible for in a computer system.
Performing calculations and executing instructions
Displaying graphics
Storing data
What is the primary role of the power supply unit (PSU) in a computer system?
Converting electricity from the wall outlet to power the computer's components
Executing software programs
Managing network connections
What is the central processing unit (CPU) in a computer responsible for?
Executing instructions and performing calculations
Displaying graphics on the screen
Managing storage devices
Which component of a computer's architecture stores data and programs for the short term, allowing the CPU to access them quickly?
RAM (Random Access Memory)
Hard drive
Managing network connections
What is the purpose of the BIOS (Basic Input/Output System) in a computer's architecture?
To initialize and test hardware components during startup
To control the computer's power supply
To manage the display settings
Which of the following is responsible for converting digital data to analog signals for transmission over telephone lines?
Modem (Modulator-Demodulator)
Network Interface Card (NI
Managing network connections
What does GPU stand for in the context of computer architecture?
Graphical Processing Unit
General Processing Unit
Managing network connections
Which computer architecture component is responsible for managing input and output devices such as keyboards, mice, and printers?
I/O Controller
CPU (Central Processing Unit)
RAM (Random Access Memory)
In a von Neumann architecture, what is the primary characteristic?
It stores data and instructions together in the same memory.
It uses separate memory for data and instructions.
It employs multiple CPUs for parallel processing.
Which of the following programming languages is commonly used for developing mobile applications?
Java
C++
Hard drive
Which operating system is known for its open-source nature and is commonly used in servers and embedded systems?
Linux
Windows
Android
Which of the following input devices is commonly used for pointing and selecting objects on the screen in a GUI?
Mouse
Keyboard
Monitor
What is the purpose of a touch screen interface?
To allow users to interact with a screen by touching it
To provide voice recognition
To recognize handwritten input
- What is the purpose of the system bus in computer architecture?
To transfer data and instructions between CPU, memory, and peripheral devices
To connect the computer to the internet
Managing network connections
Which computer architecture component is responsible for providing electrical power to the computer's internal components?
PSU (Power Supply Unit)
CPU (Central Processing Unit)
GPU (Graphical Processing Unit)
What is the primary purpose of an operating system's user interface?
To provide a way for users to interact with the computer
To manage hardware resources
To run software applications
Which of the following is an example of a graphical user interface (GUI)?
The Windows desktop with icons and windows
command-line interface (CLI)
A text-based interface
What does HCI stand for in the context of computer systems?
Human-Computer Interaction
High-Contrast Interface
A command-line interface (CLI)
