Font size
WorksheetsIct 160 11.01.23
Total questions: 160
Worksheet time: 1hrs 20mins
Computer networks can be classified by considering which of the following aspect
Local and wide area networks
fault-tolerant features
The functional relationship (Network Architectures)
Media Access Control (MAC) address
Data Link Control (DLC) address
Which one is a category of Connection method basis
DLC
Wireless LAN
Broadcasts
VoIP phones
Laptops
The basis of Metropolitan Area Network (MAN) category is a
Node
Scale
Network Topology
Area
Entity
A personal area network (PAN) a computer network that will be useful in communicating computerizes devices such as
Node and server
Telephones and PDAs
HUB and client
Firewalls and routers
Servers and clients
A computer network covering a small geographic area, like a home, office, or group of buildings is
Wide Area Network (WAN)
A local area network (LAN)
Security area Network
Mobile handheld devices
Firewalls
A group of computers and network devices connected across large physical areas such as states or countries is called
The Web Site connection
Wide Area Network (WAN)
Router Area
LAN
Broadcast area
The largest WAN in existence is
Mozilla
The Internet
Ethernet
Optical fiber
Home PAN
A network that interconnects users with computer resources in a geographic area or region larger than that covered by a local area network (LAN) but smaller than the area covered by wide area network (WAN) is called
Wireless LAN
Metropolitan Area Network (MAN)
Home PNA
The Internet
Firewall
Network topology`s category is
Client-server networking
Tree or Hierarchical topology
Peer-to-peer (workgroup)
Ethernet
Personal Area Network (PAN)
The basis of Active-Networking category is
Scale
Functional Relationship (Architecture)
Network topology
Home PNA
Client-server networking
Most of the computer viruses are designed to
Help uploading applications
Exploit some kind of an error (security hole)
Not self-replicate
Update installed programs
Improve systems` work
Which virus runs on computers memory
Multipartite virus
Resident virus
DirectActionVirus
Boots
Worms
Nonresident viruses are activated
Through the replication of malicious code
When user performs specific activity such as accessing floppy/removable media
Through the storage devices
By executable code found in specific system areas on a disk
Through email account
Which programs make it possible to automate series of operations so that they are performed as a single action
Anti-virus programs
MACROS
Cleaners
DevOps
Adobe Flash
The functions of e-mail servers
Provides a way to locate a resource on the web
To accept, forward, deliver, and store messages
Store,relocate
Archive,transmit
Restore , zip
An e-mail must have a
Address
Username followed by an @ (at sign) which is followed by the domain name with a domain suffix
Server
Recipient
ID
What is an email client
It is a server of the recipient`s email service
It is a computer program used to access and manage a user's email
It is the location you type your main message
It's a new message
It`s an online e-mail service
Each domain name represents a unique Web address which is called
An e-mail client
Internet protocol (IP) address
Carbon Copy
Signature
The SMTP Server
… is an electronic spreadsheet that runs on a personal computer
Microsoft Power point
Microsoft Excel
Microsoft Word
Microsoft Access
Microsoft Publisher
Which bar does give the user information about: the current worksheet, data the worksheet contains and etc.
The Formula bar
Status bar
The Quick Access toolbar
The Ribbon
The Title bar
Which command is used to check logical expression in MS Excel
Sum
If statement
Max
Min
Avr
Microsoft Excel consists of
Rows
Worksheets
Columns
Toolbars
Tabs
This function is used to add numbers
the MAX
the SUM
the AVR
the MIN
the SIN
In the MS Excel, a formula begins with … sign.
“/”
“=”
“@”
“*”
“&”
MS Excel. The MAX function is
automatically finds a minimum value of numbers
automatically finds a maximum value of numbers
automatically finds an average value of number
automatically adds a column of numbers
automatically counts an amount of numbers
MS Excel. The MIN function is
automatically finds a maximum value of numbers
automatically finds a minimum value of numbers
automatically finds an average value of numbers
automatically adds a column of numbers
automatically counts an amount of numbers
MS Excel. The Count function is
automatically finds a maximum value of numbers
automatically counts of the number of items in a list
automatically finds an average value of numbers
automatically adds a column of numbers
automatically finds a minimum value of numbers
MS Excel. What happens by pressing Esc key and clicking anywhere on the worksheet
adds the highlighted diapason
removes the highlighting
appears a new column
appears a new row
finds an average value of numbers
How many pages does The ribbon contain in MS Excel
5
8
10
9
3
Where does Microsoft Excel display the name of the workbook you are currently using.
On the Status bar
On the Title bar
On the ribbon
On the Formula bar
On the Quick Access tool bar
If the =SUM(C1:C10) function is nested within an =IF() function and value is equal to 10, which expression displays value “Excellent”?
=SUM(IF(C1:C10)=10;”Excellent”;”Bad”)
=IF(SUM(C1:C10)=10;”Excellent”;”Bad”)
=IF(SUM(C10:C1)=10;”Bad’;”Excellent”;”Bad”)
=IF(C1:C10)=10;”Excellent”;”Bad”)
=IF(SUM(C1:C10)=9;”Excellent”;”Bad”)
How is the combination of a column coordinate and a row coordinate called?
A formula bar
A cell address
A title bar
A worksheet name
Acolumncoordinate
What does “test!” mean in the following expression:
=IF(test!D11=1;1;0).
The reference to the worksheet ”test”
The name of the workbook
The address of the worksheet
The coordinate of the cell
Which expression calculates the SUM of the highlighted range (R1:R17) ?
=AVR(R3:R17)
=SUM(R3:R17)
=MAX(R3:R17)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
Which expression calculates the average of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=AVR(R18:R20)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
=MAX(R3:R17)
Which expression finds the maximum of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=MAX(R18:R20)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
=MAX(R3:R17)
Which expression finds the minimum of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=MIN(R18:R20)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
=MIN(R3:R17)
Each worksheet contains
Records
columns and rows
Numbers
data types
Symbols
During execution, the application program is stored:
invideomemory;
intheoperativememory;
intheprocessor;
ontheharddisk;
in ROM.
Function performed by peripheral devices ...
datastorage
input and output of information
informationprocessing
computer control of a given program
programinputcontrol
The server is
network program that conducts a dialogue between one user and another
A powerful computer to which other computers connect
an individual user's computer connected to a public network
standard defining the form of presentation and the method for forwarding the message
network program that does not conduct a dialogue between one user and another
A hard disk is a device, which provides
input of graphic information;
data storage with random access;
output of alphanumeric and graphic information;
storage of data on laser disks;
to connect computers to the global network.
Flash drives are devices that provide
output of alphanumeric and graphic information;
data storage with random access;
input of graphic information;
output of alphanumeric and graphic information on the sheet;
input alphanumeric and graphic information.
The biggest and complex integral microcircuit of the computer
Motherboard
CPU
Network Card
Sound card
Video card
Device used for transmitting information over telephone lines:
Microphone
Modem
Scanner
network card
Printer
Any information (text, graphic, sound, etc.) is written to disk in the form:
picture;
digits;
file;
extensions;
mathematical expressions.s
While the operating system is loading there is a
copying operating system files from a floppy disk to a hard disk;
sequential downloading of files from the operating system to the random access memory
copying operating system files from CD-ROM to hard disk;
copying the contents of RAM to the hard disk;
copying files to the hard disk.
The function of the operating system does not include:
dialogue with the user
transfer of information to a remote user
input-output and data management
allocation of resources (RAM, cache, processor, etc.)
launching programs for execution
Translate the number 32 from decimal to binary.
010010
100000
100001
111111
100001
Hardware is
one of the components of information technology - hardware
a hard disk inside the system unit
one of the components of information technology - software
CD
reboot program
Software is
one of the components of information technology - hardware
All programs that installed on a computer
a hard disk inside the system unit
CD
reboot program
Define the system software
This is the set of programs of the operating system
This is part of the software used to provide work of PC hardware and work with application programs
It is a means of creating application programs.
These are standard programs
This is part of the software that serves to solve user tasks.
Define the application software
This is part of the software needed to develop application programs.
This is part of the software for solving application problems.
This is the set of programs of the operating system
This is a collection of utilities.
This is part of the operating system program
Utilities are
application programs.
system programs for service purposes.
collection of tools.
resident programs.
used for creating application programs.
General Application Programs
This is part of the software needed to develop system programs.
These are the programs for solve problems in any area of the PC application.
This is a collection of applications for solving problems in a specific area of a PC application.
Is a collection of programs for service purposes.
This is the main part of the software needed to develop it.
Anti-virus programs are:
application programs.
system programs.
tools.
programming systems
Utilities
The software tools are designed for:
creation of application programs.
creation of system and application programs.
creation of system programs.
creating utilities.
programming languages
The software of the PC includes:
system, problem and application programs.
system, applied, instrumental software.
system and tool software.
applied, problematic and instrumental software.
none
Windows registry is an example of the following database:
Relational
Hierarchical
object-oriented
Related
Network
File is
RAM
Named area for storing documents
Microprocessor
Place on the disk in which the file names are stored
Scanner
A file that loads the drivers of external devices and sets the operating system parameters is represented as
MSDOS.SYS
CONFIG.SYS
AUTOEXEC.BAT
IO.SYS
NORTON COMMANDER
Define the operating system
It is an application program that allows the user to communicate with a PC
This is a system program that manages all operations in the PC.
This is a system program for controlling external devices.
This is a tool for developing user programs.
These are devices for controlling external devices.
Define drivers
These are application programs that serve individual peripheral devices.
These are system programs that serve individual peripheral devices.
These are the tools for developing operating systems.
These are devices for controlling external devices.
These are operating system control devices.
Catalog (or directory)…
This is a special place in the RAM where user files are stored.
This is a special place on the disk where file names are stored.
This is a system program for controlling external devices.
This is a special place for storing the parameters of the operating system.
This is the hard drive where user files are stored.
Specify a symbol that combines the name and file type
Colon
Dot
Star
Question mark
Comma
The file system on the disk has
relational structure.
tree structure.
linear structure
dynamic structure.
network structure.
2 Gigabyte is equal to
1024 Kilobytes
2048 Megabytes
2048 Terabytes
2048 Bytes
2000 bits
A hard disk is divided into tracks which is further subdivided into
Heads
Sectors
Foots
Vectors
Clusters
The file extension of MS-Power Point document is
.txt
.PPT
doc
.xlsx
. docx
The file extension of MS-Excel document in Office 2007 is
.txt
.xlsx
doc
.ppt
. docx
The main function of E-Government
the non-digital interaction among the Government, citizens, and the commercial institutions
the digital interaction among the Government, citizens, and the commercial institutions.
the usual interaction among the Government, citizens, and the commercial institutions.
The computer interaction among the Government
the interaction among citizens, and the commercial institutions.
E-learning
learning face-to-face
comprises of distributed learning, network or web-based learning
Learning with electronic text
Learning on a computer
Traditional learning
SMART stands for
Self-Managing Analysis and Regarding Technology
Self-Monitoring Analysis and Reporting Technology
Self-Meaning Analysis and Recording Technology
Safety-Monitoring Analysis and Recording Technology
Same-Monitoring Analysis and Recruitment Technology
Multimedia Components are
Text, IP address, file size, file name
text, sound, images, animation and video
animation and video
Sound, speech
Graphics, Sound, speech
Platform-as-a-service (PaaS) refers to
Internet services that supply software applications
cloud computing services that supply an on-demand environment for developing, testing, delivering and managing software applications.
Databases needed for development
software applications over the Internet
other datacenter infrastructure
The hexadecimal number system consists of the symbols
0..7
0..9,A..F
0..1
0..9
0..5, A..F
What is blog?
Intranet
A personal or corporate website in the form of an online journal
Data storage
A personal or corporate Google search
Online music
HTML stands for
Hyper Text Managing Links
Hyper Text Markup Language
Hyper Text Manipulating Links
Hyper Text Manipulation Language
Hyper Text Management Language
DNS in internet technology stands for
Dynamic Name System
Domain Name System
Distributed Name System
Digited Name System
Delivered Name system
The binary number system consists of the following symbols :
0 ..9
0..1
0..7
0..5
0..9; a..f
The octal number system consists of the following symbols :
0 .. 1
0..7
0..9
0..5
0..9; a..f
Which one of the following is an example of Operating System?
Microsoft Word
Microsoft Windows
Microsoft Excel
Microsoft Access
Microsoft Power Point
Which one of the following is not a network device?
Hub
CPU
Router
Switch
bridge
HTML is basically used to design:
Web-site
Web-page
Graphics
Tables and Frames
Calculations
Which is the largest unit of storage among the following?
Gigabyte
Terabyte
Megabyte
Kilobyte
Byte
RAM means:
Rapid Access Memory
Random Access Memory
Rigid Access Memory
Range Access Memory
Revolving Access Memory
WWW stands for
word wide web
world wide web
weird wide web
who what and where
Wind wild web
Which of the following is the appropriate definition of a computer?
Computer is a machine that can process information.
Computer is an electronic device that can store, retrieve and process both qualitative and quantitative data quickly and accurately
Computer is an electronic device that can store, retrieve and quickly process only quantitative data.
Computer is a machine that can store, retrieve and process quickly and accurately only qualitative information.
Computer is a car that can store, retrieve and process quickly and accurately only qualitative information.
ICT stands for
Inter connected Terminals
Information and Communication Technology
Intera Common Terminology
International Communication Technology
Internet and Communication Technology
A private cloud can be
located on the server of the user.
physically located on the company’s on-site datacenter.
located on my own computer.
located on every
logically located on the company’s on-site datacenter.
Types of cloud deployments:
public, private, hybrid
Public, common
Hybrid, common, public
General, middle, security
General, common, public
One byte equals to
8 bits
256 bits
1024 bits
1 bit
16 bits
Most cloud computing services fall into three broad categories
infrastructure as a cloud, platform as a network and software as a service
infrastructure as a service, platform as a service and software as a service
infrastructure as a provider, platform as a provider and software as a service
infrastructure as a speed, platform as a data and software as a hardware Productivity
infrastructure as a service, platform as a data and software as a Productivity
Benefits of cloud computing do not include
cost
User feeling
Global scale
Speed
Productivity
Companies offering these computing services are called
Computer engineering
Cloud providers
Cloud workers
Cloud makers
Cloud administrators
The main functions of the operating system include:
Dialogue with the user, creating a computer program.
Dialog with the user, control the resources of the computer, start the program.
Print information by the printer.
Management of computer resources, execution of computer programs.
Copying information from the scanner to the computer, starting the program
Types of addressing in Excel spreadsheet:
Absolute, mixed, simple.
Absolute, relative, mixed.
Relative, absolute, simple .
Relative, mixed, simple
Absolute, simple, mixed.
Access. The data representation model is
system of making managerial decisions involving computer.
logical structure stored in the database
diagram
a set of programs for data exchange;
software system for storing, adding, deleting and editing data in a database
Access. The data representation model is
system of making managerial decisions involving computer.
logical structure stored in the database
diagram
a set of programs for data exchange;
software system for storing, adding, deleting and editing data in a database
Specify a package that allows you to work with databases ...
MathCAD.
MS Access.
Math Lab.
MS word.
Notepad
Which one is used to connect tables in MS Access?
Forms
Data scheme
Table
Macros
Record
MS Access. Specify the field type if the field name is "date of birth"
Date Time
Number
Logical
Currency
Text
Query in MS Access:
An object in which the developer places controls that accept user actions or serve to enter, display, and modify data in fields
Formalized requirements for sampling data from tables or performing certain actions with data
Displays all the fields of a single entry, it is convenient for entering and editing data.
To enter and edit data.
Represents the macro sequence of the built-in Access language
The first computers appeared in ...
1948
1946
1936
1949
1951
List the main objects of the Access database:
In the Access database, the main objects are tables, queries, forms, reports, macros, and modules
In the Access database, the main objects are tables, queries, macros, and forms.
In the Access database, the main objects are tables, reports, macros, and modules.
In the Access database, the main objects are tables, queries, forms, reports.
In the Access database, the main objects are tables, queries, macros, and modules.
The average of the contents of the cells from A1 to A10 is calculated by the formula in Excel:
= SIGNAL (A1, A10).
= AVERAGE (A1: A10).
= SUM (A1: A10).
= CP3HA4 (A1; A10) ..
= DA1; A10)
1 megabyte is equal to
8 bytes
1024 KB
8 bits
2
1000 KB
MS Access. Specify the type of the field if the name of the field "number of medicines"
monetary
numerical
textual
logical
memo
MS Excel. Specify the correct summation formula entry ...
of the sums A1: A10
= sums (A1: A10)
= sumA1: A10
sums (A1: A10)
sum (A1: A10)
Specify which of the following is the "brain" of the computer
CD-R.
Processor.
Monitor.
Keyboard.
RAM.
The hyperlink allows:
save documents.
move to the place of the bookmark.
view pictures.
archive documents.
create new documents.
MSAccess. Macros is ....
An object that is a structured description of one action
An object that represents a structured description of several actions that Access Basic must perform
An object that is a structured description of one action that Access Basic must perform
An object that is a structured description of several actions that [Human computer interaction] must perform
An object that is a structured description of one or more actions that Access Basic must perform, and which allows you to break the process into smaller actions
What does allow web developers to alter the layout and appearance of their web pages
Domain Name System (DNS)
Cascading Style Sheet, CSS
Internet Engineering Task Force (IETF)
HyperText Transfer Protocol (HTTP)
The Internet Archive
Why are web pages called “hypertext documents”
Because it accepts information through text
Because when you click a word or a picture which is hyper linked you can go to another location
They contain only text
Because it is made for readable manner
Documents are used for storing text
FTP is commonly used to
Make connection
Transfer Web page files from their creator to the computer
Transmit the information from one place to the other
Download programs
Install applications
A computer which is capable of receiving the information from the server in the Internet is called a
Server
Client
Domain
Service
Locator
What is a browser
Set of rules and guidelines for communicating data
A computer software which can be used to view documents on the Internet
Foundation of data communication
Transmission of information from one place to the other
Largest service acquired amongst the services provided by the Internet
This type of virus can steal information from user`s computers and upload to web sites
Boots
Worms
Resident virus
Polymorphic virus
Multipartite virus
What is a computer virus
An application
A harmful computer program developed by a person that disrupts operations of a computer in various ways
Type of hardware
MS document
Browser
What is a router
A device which makes the use of computer technology cost effective
A networking device that forwards packets between networks using information in protocol headers
Devices used to connect end devices to the network
Device attached to the network to obtain human computer interaction
A device used to extend a network so that additional workstations can be attached
What do connect multiple network segments at the data link layer (layer 2) of the OSI model
Interfaces
Bridges
Security cameras
Network printers
Modems
An Internet Protocol (IP) address is a
Set of devices which form the interface between the human network and the underlying communication network
Numerical identification (logical address) that is assigned to devices participating in a computer network
Set of devices which obtain protection functions
Numerical identification (logical address) that is assigned to provide network
Set of devices which perform typical tasks for appropriate function of hard disk
What is the “HUB”
Is a device for providing programs` access
A device used to extend a network so that additional workstations can be attached
A device used to run applications
Type of operating system
Name of the Browser
What does have several processors rather than just one and may be dedicated to a specific support function
Router
Server
Broadcast
Network
Intermediary device
The device needed to connect computers to the local network:
TV tuner
Network Card
video card
tire
plume
The main element of MS Access is
Forms
Table
Field
Macros
Record
The protocol, domain, directories, and files are all separated by
Periods (.)
Forward slashes( / )
Commas (,)
Asterisks (*)
Low lines (_)
What are the systems of interconnected computers that share a central storage system and various peripheral devices
Networking
Computer systems
ICloud system
Hardware
Firmware
Computer programs installed in the computer are called …
Engineering
Software
Hardware
Firmware
Hard disc
The first technical characteristics of a CPU is a
Diligence
Speed
The accuracy
Reliability
No feeling
Most common type of computers in the society are …
Minicomputers
Personal computers
Super computers
Mainframes
Double computers
Which type of computer is capable of handling and processing very large amounts of data quickly
Microcomputers
Mainframes
Minicomputers
Super computers
Double computers
Which computer is used for performing complex scientific and numerical computations such as weather forecasting, fluid dynamics, and etc.
Microcomputers
Super computers
Mainframes
Minicomputers
Double computers
Which one defines the physical equipment that is involved in the computer functioning
Software
Hardware
Firmware
Nextware
Hard disc
The computer hardware is typically divided into four main parts which are
Printers, Xerox, input and output devices
Processing Devices, Memory Devices, Input/, Output Devices
Control Unit (CU) and the Arithmetic and Logic Unit (ALU)
Local, broadband, personal, regional
Printer, plotter, modem, headphones
A series of instructions that tells a computer how to perform the tasks is called
device
A program
Number
Command
Text
Any hardware component that allows you to enter data, programs, commands, and user responses into a computer is known as
An output Device
An Input Device
Processing
Power supply
BIOS
Which device is not classified as an input device
Keyboard
Printer
Trackball
Mouse
Joystick
How do we call the digital representations of non-text information such as drawings, charts, pictures and photographs
Text
Graphics
sound
number
video
Music, speech, or any other sound is called
Video
Audio
Text
Graphics
0..9
The number system whose base is 8 is known as
the Hexadecimal number system
the octal number system
the binary number system
the decimal number system
The non octal number system
What contains the CPU, BIOS, memory, mass storage interfaces, serial/parallel ports, expansion slots, and all the controllers required to control standard peripheral devices
RAM
the motherboard
Control unit
ALU
storage device
Type of Operating Systems
mini-user mini-task
single-user single-task
mini-user single-task
micro-user single-task
multi-user micro-task
Single-user single-task OS allows
many applications running at the same time
only one person running only one application at a time
Each user logged on to the system, their workspace and so on
Keep logs of how much processing time and resources they use
Work out the most efficient use of computer processing cycles
Which option below researches the design and use of computer technology, focused on the interfaces between users and computers
System software
Human–computer interaction
Computer Hardware
Shortcut Icons
Task Bar
What does Human–computer interaction study in communication
Computer and software
A human and a machine
A computer and Computer systems
User and users
A computer and applications
In HCI on the human side, there are not considered concepts such as
communication theory
computer graphics
linguistics
social sciences
cognitive psychology
The main problem of human-computer interaction is how to improve
the reliability of CPU
the usability of computer interfaces
the speed of CPU
The accuracy of computer interfaces
The diligence of computer interfaces
Which of the followings is used by the user to interact directly with the computer system by typing commands (instructions) in the command line
A Command Line interface
A Graphic userInterface
A Voice user interfaces
A Desktop Interface
A Text interface with menus
What kind of interface is considered as a visual way of interacting with the computer using the components like windows, icons, labels and etc.
A Text interface with menus
A Graphic interface
A Command Line Interface
A Voice user interfaces
A Desktop Interface
What type of chart is useful for comparing values over categories?
Column Chart
Line Chart
Pie Chart
Dot Graph
Big Chart
Which function in Excel tells how many numeric entries are there?
CHKNUM
NUM
SUM
COUNT
ADDRESS
Choose the suitable variant for Public Cloud
Drives efficiency, standardization and best practices while retaining greater customization and control.
Access limited to client and its partner network.
Client owned and managed.
Service provider owned and managed.
Service provider owned
Choose the Advantage of Cloud Computing
Since you use the Internet to connect to both your applications and documents, if you do not have an Internet connection you cannot access anything, even your own documents.
Web-based applications require a lot of bandwidth to download, as do large documents.
Cloud computing is impossible if you cannot connect to the Internet
Changes to computers, applications and documents follow you through the cloud.
Cloud computing needs connecting to the Internet
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
Query
Relational Schema
DDL(Data Definition Langauge)
DML(Data Manipulation Langauge)
Report
A relational database consists of a collection of
Tables
Records
Keys
Fields
Tabs
How will you graphically represent expenditure in different departments?
Line Chart
Column Chart
Dot Chart
Pie Chart
Big Chart
Choose right variant. Find example of ergonomics.
use of red for warning, green for okay, awareness of color-blindness
all answers are correct
physical position, environmental conditions temperature, humidity
seating arrangements adaptable to cope with all sizes of user
use of awareness of color-blindness
Choose right variant.
What is connect with Interface:
1) A point where two objects meet;
2) A point where human can tell the computer what to do;
3) A point where the computer displays the requested information
1.2
1.2.3
1.3
2.3
1
What is a sign of copyright protection?
$
#
^
©
&
