Font size
WorksheetsИКТ РК1
Total questions: 145
Worksheet time: 1hrs 13mins
What does have several processors rather than just one and may be dedicated to a specific support function
broadcast
network
server
router
Each domain name represents a unique Web address which is called
Internet protocol (IP) address
Signature
Carbon copy
The SMTP Server
A group of computers and network devices connected across large physical areas such as states or countries is called
broadcast area
Router area
LAN
wide area network (WAN)
An e-mail must have
Recipient
Username followed by @ (at sign) which is followed by the domain name with a domain suffix
ID
Address
Define drivers
These are the tools for developing operating systems
These are operating system control devices
These are system programs that serve individual peripheral devices
These are devices for controlling external devices
In the MS Excel a formula begins with ... sign
{
=
+
@
The largest WAN in existence is
Home PAN
Mozilla
Ethernet
The Internet
Which of the followings is used by the user to interact directly with a computer system by typing commands (instructions) in the command line
A Command Line interface
A Desktop interface
A Text interface with menus
A Graphic User interface
This is a network model that offers centralized access to services and devices and one computer plays the role of a server
ATM
Peer to peer network
Client server network
Ethernet
Which device is not classified as an input device
Joystick
Printer
Mouse
Keyboard
The group of the local area networks unrolled in the compact territory of any establishment and servicing one building
WAN
LAN
CAN
PAN
A hard disk is divided into tracks which is further subdivided into
Sectors
Clusters
Heads
Vectors
The file extension of MS-Excel document is Office 2010 is
.txt
.docx
.xlsx
.pptC
RAM means
Rigid Access Memory
Rapid Access Memory
Range Access Memory
Random Access Memory
A personal area network (PAN) a computer network that will be useful in communicating computerizes devices such as
Telephones and PDAs
Servers and clients
Node and server
Hub and client
The main problem of human-computer interaction is how to improve
the reliability of CPU
the speed of CPU
the accuracy of computer interfaces
the usability of computer interfaces
Anti-virus programs are
application programs
system programs
tools
utilities
How is the combination of a column coordinate and a row coordinate called
a worksheet name
a formula bar
a title bar
a cell address
The service intended for data communication for the World Wide Web, where hypertext documents include hyperlinks to other resources that the user can easily access
POP3
HTTP
FTP
SMPT
MS Access. Specify the field type if the field name is "date of birth"
Text
Currency
Number
Date Time
A file that loads the drivers of external devices and sets the operating system parameters is presented as
CONFIG.SYS
IO.SYS
MSDOS.SYS
AUTOEXEC.BAT
Each worksheet contains (MS Excel)
data types
symbols
columns and rows
numbers
Technologies designed for the joint implementation of information and communication processes
robot technology and automation
cryptography
computer science
information and communication technology
Software is
A hard disk inside the system unit
Reboot program
CD
All programs that installed on a computer
What contains the CPU, BIOS, memory, mass storage interfaces, serial/parallel ports, expansion slots, and
the motherboard
ALU
storage device
RAM
A computer network covering a small geographic area , like a home, office, or group of buildings is
Firewalls
A wide area network (WAN)
A local area network (LAN)
Mobile handled devices
Gigabyte is equal to
1024 bits
2048 Terabytes
2048 Bytes
2048 Megabytes
Which bar does give the user information about: the current worksheet, data the worksheet contains and etc.
Status bar
The Ribbon
The Title bar
The Formula bar
Which type of computer is capable of handling and processing very large amounts of data quickly
Super computers
Microcomputers
Minicomputers
Mainframes
MS Excel. What happens by pressing Esc key and clicking anywhere on the worksheet
appers a new row
removes the highlighting
appears a new column
adds the highlighted diapason
One byte equals to
1024 bits
256 bits
8 bits
16 bits
Type of Operating Systems
single-user single-task
multi-user micro-task
micro-user single-task
mini-user single-task
Specify a package that allows you to work with databases...
MathCAD
MS Word
Notepad
MS Access
General Application 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
This is the main part of the software needed to develop it
This is part of the software needed to develop system programs
While the operating system is loading there is a
copying operating system files from CD-ROM to hard disk
copying the contents of RAM to the hard disk
sequential downloading of files from the operating system to the random access memory
copying files to the hard disk
AVR Microsoft Excel consists of
Rows
Columns
Tabs
Worksheets
The server is
an individual user's computer connected to a public network
A powerful computer to which other computers connect
network program that does not conduct a dialogue between one user and another
network program that conducts a dialogue between one user and another
Which expression calculates the average of the highlighted range (R18:R20)
=MIN(R18:R20)
=MAX(R18:R20)
=AVR(R18:R20)
=AUTOSUM(R18:R20)
How many pages does The Ribbon contain in MS Excel
5
3
10
8
The binary number system consists of the following symbols
0...1
0...7
0...9
0...5
Which expression calculates the SUM of the highlighted range (R1:R17)
=MAX(R3:R17)
=SIN(R3:R17)
=SUM(R3:R17)
=AVR(R3:R17)
Which PowerPoint feature allows the user to create a simple presentation without having to spend too much time on it
Animation
Color Schemes
Chart Wizard
AutoContent Wizard
Slide sorter of PowerPoint is available on menu
File
Layout
Edit
View
This is an application layer protocol which moves files between a client and server on a computer network
TCP/IP
SMPT
HTTP
FTP
List of the main objects of the Access database
In the Access database, the main objects are tables, reports, macros, and modules
In the Access database, the main objects are tables, macros, and forms
In the Access database, the main objects are tables, queries, forms, reports
In the Access database, the main objects are tables, queries, forms, reports, macros, and modules
The main functions of the operating system include
Dialog with the user, control the resources of the computer, start the program
Print information by the printer
Dialogue with the user, creating a computer program
Management of computer resources, execution of computer programs
Nonresident viruses are activated
Through a replication of malicious code
Through email account
Through the storage device
When user performs specific activity such as accessing floppy/removable media
Network topology's category is
Peer-to-peer (workgroup)
Tree of Hierarchical topology
Ethernet
Client-server networking
If the =SUM(C1:C10) function is nested within an =IF() function and value is equal to 10, which expression displays value “Excellent”?
=IF(SUM(C1:C10)=9;”Excellent”;”Bad”)
=IF(SUM(C1:C10)=10;”Excellent”;”Bad")
=IF(C1:C10)=10;”Excellent”;”Bad”)
=SUM(IF(C1:C10)=10;”Excellent”;”Bad”)
Utilities are
resident programs
collection of tools
system programs for service purposes
application programs
which of the following is the appropriate definition of a computer
Computer is an electronic device that can store, retrieve and process both qualitative and quantitative data quickly and accurately
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
Computer is a machine that can process information
single-user single-task OS allows
each user logged on to the system, their workspace and so on
many applications running at the same time
work out the most efficient use of computer processing cycles
only one person running only one application at a time
ICT stands for
Internet and Communication Technology
International Communication Technology
Information and Communication Technology
Inter Connected Terminals
Which command is used to check logical expression in MS Excel
Sum
Min
Max
If
What of the given network topologies represents the closed chain
Star
Bus
Ring
Tree
What is a presentation
Something that comes on TV
A function and collection of data and files
A special program of data and information used to make a point
A collection of data and information that is delivered to a specific audience
Any hardware component that allows you to enter data, programs, commands, and user responses into a computer is known as
Processing
An Output Device
BIOS
An Input Device
FTP is commonly used to
Transfer Web page files from their creator to the computer
Download programs
Make connection
Install application
WWW stands for
weird wide web
word wide web
world wide web
wind wild web
What does allow web developers to alter the layout and appearance of their web pages
The Internet Archive
Domain Name System (DNS)
Internet Engineering Task Force (IETF)
Cascading Style Sheet, CSS
MS Excel. The MIN function is
automatically counts an amount of numbers
automatically finds a minimum value of numbers
automatically finds a maximum value of numbers
automatically finds an average value of numbers
MS Access. Specify the type of the field if the name of the field "number of medicines"
numerical
textual
logical
monetary
In HCI on the human side, there are not considered concepts such as
social sciences
cognitive psychology
communication theory
computer graphics
Computer networks can be classified by considering which of the following aspect
Local and wide area networks
The functional relationship (Network Architectures)
Data Link Control (DLC) address
Media Access Control (MAC) address
Windows registry is an example of the following database
Relational
Hierarchical
Related
Network
Most of the computer viruses are designed to
Not self-replicate
Update installed programs
Exploit some kind of an error (security hole)
Help uploading applications
The hexadecimal number system consists of the symbol
0...7
0...9
0...5; A...F
0...9; A...F
The geometrical scheme of computer association is called
Network topology
Local topology
Tire topology
Ring topology
What is an electronic spreadsheet that runs on a personal computer
Microsoft Access
Microsoft Excel
Microsoft Word
Microsoft PowerPoint
HTML stands for
Hyper Text Managing Links
Hyper Text Manipulation Language
Hyper Text Management Language
Hyper Text Markup Language
Flash drives are devices that provide
output of alphanumeric and graphic information
input of alphanumeric and graphic information
input of graphic information
data storage with random access
Hardware is
A hard disk inside the system unit
one of the components of information technology - software
CD
one of the components of information technology - hardware
Which programs make it possible to automate series of operations so that they are performed as a single actions
Adobe Flash
DevOps
Cleaners
MACROS
The configuration (topology) of a local computer network in which all workstations are consistently connected with each other is called
Star
Ring
Mesh
Bus
The software of the PC includes
applied, problematic and instrumental software
system, applied, instrumental software
none
system and tool software
Which one is a category of connection method basis
Wireless LAN
Laptops
Broadcast
DLC
Define the application software
This is part of the operating system program
This is a collection of utilities
This is part of the software needed to develop application programs
This is part of the software for solving application problems
The file system on the disk has
dynamic structure
network structure
linear structure
tree structure
A hardware device that connects multiple devices on a computer network
hub
cable
router
switch
The computer hardware is typically divided into four main parts which are
Processing Devices, Memory Devices, Input/Output Devices
Control Unit (CU) and the Arithmetic and Logic Unit (ALU)
Printer, plotter, modem, headphones
Printers, Xerox, input and output devices
The software tools are designed for
creation of application programs
creating utilities
programming languages
creation of system and application programs
Function performed by peripheral devices
data storage
input and output of information
information processing
computer control of a given program
The average of the contents of the cells from A1 to A10 is calculated by the formula in Excel
=SIN(R3: R17)
=AUTOSUM(R3: R17)
=AVERAGE(A1: A10)
=AVR(R3: R17)
The first computers appeared in …
1946
1957
1948
1956
What is blog?
Online music
A personal or corporate website in the form of an online journal
Data storage
Personal or corporate Google search
The device needed to connect computers to the local network
Plume
Video card
Network card
TV tuner
Which virus runs on computers memory
Worms
Multipartite virus
Direct Action virus
Resident virus
The basis of Active-Networking category is
Network topology
Functional Relationship (Architecture)
Scale
Home PNA
The octal number system consists of the following symbols
0...1
0...9
0...7
0...5
An Internet Protocol (IP) address is a
Numerical identification (logical address) that is assigned to provide network
Set of devices which perform typical tasks for appropriate function of hard disk
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
The basis of Metropolitan Area Network (MAN) category is a
Scale
Entity
Area
Node
Which is the largest unit of storage among the following
Megabyte
Terabyte
Gigabyte
Kilobyte
Which PowerPoint feature adds special effects to modify the appearance of the slides and the timing between each slide
Color Schemes
Handouts
Animation
Transition Settings
Which one defines the physical equipment that is involved in the computer functioning
Hardware
Software
Hard disc
Firmware
Specify a symbol that combines the name and file type
Colon
Dot
Comma
Question mark
Catalog (or directory)
This is the hard drive where user files are stored
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 special place for storing the parameters of the operating system
A graphic that allows you to compare and contrast data in a visual format
Legend
Figures
Plot
Chart
HTML is basically used to design
Web-page
Graphics
Web-site
Tables and frames
Any information (text, graphic, sound, etc.) is written to disk in the form
mathematical expressions
digits
file
extensions
This is the practice of protecting systems, networks, and programs from digital attacks. These are usually aimed at accessing, changing, or destroying sensitive information; extorting money from users, or interrupting normal business processes
encryption
decoding
cybersecurity
coding
DNS in internet technology stands for
Digited Name System
Dynamic Name System
Distributed Name System
Domain Name System
Which one of the following is an example of Operating System
Microsoft Excel
Microsoft Access
Microsoft Word
Microsoft Windows
Types of addressing in Excel spreadsheet
Absolute, relative, mixed
Relative, absolute, simple
Absolute, simple, mixed
Absolute, mixed, simple
Rules of an exchange of information between computers through a network
Standard programs
Protocol
Spreadsheet
Text editor
A hard disk is a device, which provides
to connect computers to the global network
input of graphic information
data storage with random access
output of alphanumeric and graphic information
What is the HUB
Name of the Browser
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
This protocol specifies how data is exchanged over the internet by providing end-to-end communications that identify how it should be broken into packets, addressed, transmitted, routed and received at the destination
SMPT
HTTP
FTP
TCP/IP
This function is used to add numbers
the SUM
the MIN
the MAX
the AVR
A series of instructions that tells a computer how to perform the tasks is called
Text
A program
Device
Number
Where does Microsoft Excel display the name of the workbook you are currently using
On the Ribbon
On the Formula bar
On the Title bar
On the Status bar
MS Excel. The MAX function is
automatically counts an amount of numbers
automatically finds an average value of numbers
automatically finds a minimum value of numbers
automatically finds a maximum value of numbers
A computer which is capable of receiving the information from the server in the Internet is called a
Domain
Service
Server
Client
What is a browser
A computer software which can be used to view documents on the Internet
Largest service acquired amongst the services provided by the Internet
Set of rules and guidelines for communicating data
Transmission of information from one place to the other
Access. The data representation model is
system of making managerial decisions involving computer
logical structure stored in the database
software system for storing, adding, deleting and editing data in a database
a set of programs for data exchange
Which expression finds the maximum of the highlighted range (R18:R20)
=SIN(R18:R20)
=AVR(R18:R20)
=MAX(R18:R20)
=MIN(R18:R20)
Most common type of computers in the society are
Double computers
Super computers
Minicomputers
Personal computers
A hardware device that divides the network connection among multiple devices
router
hub
switch
cable
Device used for transmitting information over telephone lines
Modem
Printer
Microphone
Scanner
Which one is used to connect tables in MS Access
Macros
Forms
Record
Data scheme
Define the operating system
This is a system program for controlling external devices
This is a tool for developing user programs
This is a system program that manages all operations in the PC
It is an application program that allows the user to communicate with a PC
Which expression finds the minimum of the highlighted range (R18:R20)
=AUTOSUM(R3:R17)
=AVR(R3:R17)
=MIN(R3:R17)
=MIN(R18:R20)
The first technical characteristics of a CPU is a
The accuracy
Speed
Diligence
Reliability
Query in MS Access
Represents the macro sequence of the built-in Access language
Displays all the fields of a single entry, it is convenient for entering and editing data
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
Which of the following performs modulation and demodulation
router
modem
cable
hub
The file extension of MS-PowerPoint document is
.xlsx
.txt
.pptC...
.html
The functions of e-mail servers
Store, relocate
Provides a way to locate a resource on the web
Archive, transmit
To accept, forward, deliver, and store messages
What does Human-computer interaction study in communication
Computer and software
A computer and applications
A computer and Computer systems
A human and a machine
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
What is a router
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
Basic topology of a computer network in which all computers of network are attached to central node (usually the switch), forming physical network segment.
Bus
Cell
Star
Ring
During execution, the application program is stored
on the hard disk
in the processor
in ROM
in the operative memory
Define the system software
This is the set of programs of the operating system
These are standard programs
This is part of the software used to provide work of PC hardware and work with application programs
This is part of the software that serves to solve user tasks
The function of the operating system does not include
launching programs for execution
transfer of information to a remote user
allocation of resources (RAM, cache, processor, etc.)
input-output and data management
Which option below researches the design and use of computer technology, focused on the interfaces between users and computers
Human-computer interaction
Task bar
System software
Computer hardware
Unique address of the Web page
IP
FTP
URL
URN
The protocol, domain, directories, and files are all separated by
Commas (,)
Periods (.)
Asterisks (*)
Forward slashes( / )
File is
RAM
Named area for storing documents
Scanner
Place on the disk in which the file names are stored
What are the systems of interconnected computers that share a central storage system and various peripheral devices
Computer systems
Networking
Hardware
Firmware
Which one of the following is not a network device
bridge
Hub
Switch
CPU
Computer programs installed in the computer are called
Software
Firmware
Hardware
Hard disc
The biggest and complex integral microcircuit of the computer
Motherboard
Sound card
Network Card
CPU
A network that interconnects users with computer res<question> What are the systems of interconnected computers that share a central storage system and various peripheral devices sources 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
Firewall
Home PNA
The Internet
Metropolitan Area Network (MAN)
What is an email client
It is a server of the recipient's email service
It is the location you type your main message
It is a computer program used to access and manage a user's email
It's an online email service
What does test! mean in the following expression
The coordinate of the cell
The reference to the worksheet test!
The name of the workbook
The address of the worksheet
A computer network covering a small geographic area, like a home, office, or group of buildings is
A local area network (LAN)
Firewalls
Mobile handheld devices
Wide Area Network (WAN)
