NEW
Font size
Worksheetsикт 1-52
Total questions: 77
Worksheet time: 39mins
Computer networks can be classified by considering which of the following aspect
Local and wide area networks
The functional relationship (Network Architectures)
fault-tolerant features
Media Access Control (MAC) address
Which one is a category of Connection method basis
VoIP phones
DLC
Broadcasts
Wireless LAN
The basis of Metropolitan Area Network (MAN) category is a
Scale
Network Topology
Area
Entity
A personal area network (PAN) a computer network that will be useful in communicating computerizes devices such as
HUB and client
Firewalls and routers
Telephones and PDAs
Servers and clients
A computer network covering a small geographic area, like a home, office, or group of buildings is
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
LAN
Broadcast area
The Web Site connection
Wide Area Network (WAN)
The largest WAN in existence is
The Internet
Home PAN
Ethernet
Optical fiber
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
Home PNA
Metropolitan Area Network (MAN)
Wireless LAN
Firewall
Network topology`s category is
Peer-to-peer (workgroup)
Client-server networking
Personal Area Network (PAN)
Tree or Hierarchical topology
The basis of Active-Networking category is
Client-server networking
Functional Relationship (Architecture)
Home PNA
Scale
Most of the computer viruses are designed to
Improve systems` work
Not self-replicate
Update installed programs
Exploit some kind of an error (security hole)
Which virus runs on computers memory
Multipartite virus
Resident virus
Worms
Boots
Nonresident viruses are activated
When user performs specific activity such as accessing floppy/removable media
Through email account
By executable code found in specific system areas on a disk
Through the replication of malicious code
Which programs make it possible to automate series of operations so that they are performed as a single action
Cleaners
DevOps
Cleaners
MACROS
The functions of e-mail servers
Restore , zip
Provides a way to locate a resource on the web
To accept, forward, deliver, and store messages
Store,relocate
An e-mail must have a
ID
Username followed by an @ (at sign) which is followed by the domain name with a domain suffix
Address
Recipient
What is an email client
It is a computer program used to access and manage a user's email
It`s an online e-mail service
It's a new message
It is the location you type your main message
Each domain name represents a unique Web address which is called
Signature
The SMTP Server
Internet protocol (IP) address
Carbon Copy
… is an electronic spreadsheet that runs on a personal computer
Microsoft Word
Microsoft Publisher
Microsoft Excel
Microsoft Word
Which bar does give the user information about: the current worksheet, data the worksheet contains and etc.
The Quick Access toolbar
Status bar
The Title bar
The Ribbon
Which command is used to check logical expression in MS Excel
Sum
Min
Max
If statement
Microsoft Excel consists of
Rows
Worksheets
Toolbars
Tabs
This function is used to add numbers
the MAX
the SUM
the AVR
the MIN
In the MS Excel, a formula begins with … sign.
“=”
“&”
“*”
“@”
MS Excel. The MAX function is
automatically finds a minimum value of numbers
automatically finds an average value of numbers
automatically finds a maximum value of numbers
automatically counts an amount of numbers
MS Excel. The MIN function is
automatically finds a minimum value of numbers
automatically finds a maximum value of numbers
automatically finds an average value of numbers
automatically adds a column of numbers
MS Excel. The Count function is
automatically finds a maximum value of numbers
automatically finds an average value of numbers
automatically counts of the number of items in a list
automatically finds a minimum value of numbers
MS Excel. What happens by pressing Esc key and clicking anywhere on the worksheet
removes the highlighting
adds the highlighted diapason
finds an average value of numbers
appears a new column
How many pages does The ribbon contain in MS Excel
10
5
8
11
Where does Microsoft Excel display the name of the workbook you are currently using.
On the Quick Access tool bar
On the ribbon
On the Title bar
On the Status 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(C10:C1)=10;”Bad’;”Excellent”;”Bad”)
=IF(C1:C10)=10;”Excellent”;”Bad”)
=IF(SUM(C1:C10)=10;”Excellent”;”Bad”)
How is the combination of a column coordinate and a row coordinate called?
A formula bar
A worksheet name
A title bar
A cell address
What does “test!” mean in the following expression:
The address of the worksheet
The coordinate of the cell
The reference to the worksheet ”test”
=IF(test!D11=1;1;0).
Which expression calculates the SUM of the highlighted range (R1:R17) ?
=AVR(R3:R17)
=SIN(R3:R17)
=MAX(R3:R17)
=SUM(R3:R17)
Which expression calculates the average of the highlighted range (R18:R20) ?
=AVR(R18:R20)
=AVR(R3:R17)
=SIN(R3:R17)
=MAX(R3:R17)
Which expression finds the minimum of the highlighted range (R18:R20) ?
=MIN(R18:R20)
=SIN(R3:R17)
=MIN(R3:R17)
=AVR(R3:R17)
Which expression finds the maximum of the highlighted range (R18:R20) ?
=SIN(R3:R17)
=MAX(R3:R17)
=MAX(R18:R20)
=AVR(R3:R17)
Each worksheet contains
Numbers
data types
columns and rows
Symbols
During execution, the application program is stored:
in video memory;
in the operative memory;
in the processor;
on the hard disk;
on the hard disk;
data storage
input and output of information
information processing
program input control
The server is
an individual user's computer connected to a public network
network program that conducts a dialogue between one user and another
standard defining the form of presentation and the method for forwarding the message
A powerful computer to which other computers connect
A hard disk is a device, which provides
output of alphanumeric and graphic information;
storage of data on laser disks;
to connect computers to the global network.
data storage with random access;
The biggest and complex integral microcircuit of the computer
CPU
Network Card
Sound card
Video card
Device used for transmitting information over telephone lines:
Modem
network card
Printer
Scanner
While the operating system is loading there is a
copying the contents of RAM to the hard disk;
copying files to the hard disk.
copying operating system files from CD-ROM to hard disk;
sequential downloading of files from the operating system to the random access memory;
The function of the operating system does not include:
input-output and data management
transfer of information to a remote user
allocation of resources (RAM, cache, processor, etc.)
dialogue with the user
Translate the number 32 from decimal to binary.
100000
100001
111111
010010
Hardware is
reboot program
CD
a hard disk inside the system unit
one of the components of information technology - hardware
Software is
one of the components of information technology - hardware
reboot program
All programs that installed on a computer
a hard disk inside the system unit
Define the system software
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.
These are standard programs
It is a means of creating application programs.
Which one defines the physical equipment that is involved in the computer functioning
Software
Hardware
Firmware
Nextware
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
A series of instructions that tells a computer how to perform the tasks is called
device
Number
A program
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
BIOS
Which device is not classified as an input device
Keyboard
Trackball
Printer
Mouse
How do we call the digital representations of non-text information such as drawings, charts, pictures and photographs
sound
Graphics
number
video
Music, speech, or any other sound is called
Audio
Video
Text
Graphics
The number system whose base is 8 is known as
the decimal number system
the Hexadecimal number system
the octal number system
the binary 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
ALU
Control unit
the motherboard
Type of Operating Systems
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
Each user logged on to the system, their workspace and so on
only one person running only one application at a time
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
Shortcut Icons
Computer Hardware
Human–computer interaction
What does Human–computer interaction study in communication
Computer and software
A computer and Computer systems
A human and a machine
User and users
In HCI on the human side, there are not considered concepts such as
cognitive psychology
communication theory
social sciences
computer graphics
The main problem of human-computer interaction is how to improve
the usability of computer interfaces
the speed of CPU
the reliability of CPU
The accuracy 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 Graphic userInterface
A Command Line interface
A Text interface with menus
A Desktop Interface
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 Command Line Interface
A Graphic interface
A Voice user interfaces
What type of chart is useful for comparing values over categories?
Column Chart
Pie Chart
Line Chart
Dot Graph
Which function in Excel tells how many numeric entries are there?
ADDRESS
CHKNUM
SUM
NUM
V1 Choose the suitable variant for Public Cloud
Drives efficiency, standardization and best practices while retaining greater customization and control.
Client owned and managed.
Access limited to client and its partner network.
Service provider owned and managed.
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.
Cloud computing needs connecting to the Internet
Changes to computers, applications and documents follow you through the cloud.
Web-based applications require a lot of bandwidth to download, as do large documents.
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
Query
DDL(Data Definition Langauge)
Relational Schema
DML(Data Manipulation Langauge)
A relational database consists of a collection of
Tables
Records
Keys
Fields
How will you graphically represent expenditure in different departments?
Line Chart
Pie Chart
Column 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
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
2,3
1,2,3
1,3
1,2
What is a sign of copyright protection?
$
#
^
&
