Free Printable ИКТ1010

1.

What is the Computer science

a)

the science of e-mail

b)

way of learning about the world by means of signals and symbols, a man perceived by the senses

c)

science of collecting, storing, processing and transmission of information through computers

d)

is the study of general and fundamental problems concerning matters such as existence, knowledge, values, reason, mind, and language

e)

unit recording information on a floppy disk

2.

… - a set of physical processes signals perceived by the subject through his sense organs

a)

Information processes

b)

Computer

c)

Protocol

d)

Data

e)

Information

3.

Data obtained by measuring, monitoring, logical or arithmetic operations presented in a form suitable for storage, transmission and processing

a)

Information processes

b)

Data

c)

Protocol

d)

Information

e)

Computer

4.

Under ….. is offered to understand the complex objects, actions, and rules relating to the preparation, processing and delivery of information at the personal, mass communication and production, as well as all technologies and sectors, providing integrated these processes.

a)

Computer Science

b)

the information and communication technologies

c)

Information

d)

Information processes

e)

Data

5.

Ergonomika- it

a)

science that studies the application scope of our mental characteristics.

b)

the science of the economically correct solutions.

c)

the science of the psychological impact of computers on the person.

d)

the science of designing the user interface.

e)

science on the development of products that interact with us physically.

6.

… is an extended term for information technology which stresses the role of unified communications and the integration of telecommunications (telephone lines and wireless signals), computers as well as necessary enterprise software, middleware, storage, and audio-visual systems, which enable users to access, store, transmit, and manipulate information.

a)

Digital technology

b)

Cloud technology

c)

Multimedia technology

d)

Information and communications technology

e)

Network technology

7.

The term is … used to refer to the convergenceof audio-visual and telephone networks with computer networks\ through a single cabling or link system.

a)

LAN

b)

ICT

c)

Cloud

d)

Multimedia

e)

WAN

8.

What is multimedia?

a)

Images and audio

b)

Integration of still and moving images, text, and sounds by means of computer technology

c)

Moving images and text

d)

Programs that combine text and images on a television screen

e)

A video game

9.

.............used for the formation of an ideology in the field of information and modern information culture, i.e. the ability to interact with information, professional use for receiving, processing, transmitting and storing it.

a)

Mission of “ICT”

b)

Purpose of “ICT”

c)

Discipline “ICT”

d)

Idea of “ICT”

e)

Ideology of “ICT”

10.

Choose right variant. The practical purpose of the ICT course

a)

improve their general culture, education, and justice

b)

ICT in entertainment

c)

provides academic and educational purposes

d)

helping to expand the horizons of students

e)

All answers are correct

11.

................offer services pertaining to processing transactions, documentation, presentations, inventory management and gathering product information

a)

Е- Subject

b)

e-commerce

c)

e-business

d)

e-document

e)

e-service

12.

Communication

a)

Technology is the use of scientific knowledge, experience and resources to create processes products that fulfill human needs.

b)

Communication is an act of transmitting messages. It is a process whereby information is exchanged between individuals using symbols, signs or verbal interactions. Communication is important in order to gain knowledge.

c)

ICT standardisation is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.

d)

Information refers to the knowledge obtained from reading, investigation, study or research. The tools to transmit information are the telephone, television and radio. Information is knowledge and helps us to fulfill our daily tasks.

e)

Standards are critical to the interoperability of ICTs and whether we exchange voice, video or data messages, standards enable global communications by ensuring that countries’ ICT networks and devices are speaking the same language.

13.

Technology

a)

Communication is an act of transmitting messages. It is a process whereby information is exchanged between individuals using symbols, signs or verbal interactions. Communication is important in order to gain knowledge.

b)

Information refers to the knowledge obtained from reading, investigation, study or research. The tools to transmit information are the telephone, television and radio. Information is knowledge and helps us to fulfill our daily tasks.

c)

ICT standardisation is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.

d)

Technology is the use of scientific knowledge, experience and resources to create processes products that fulfill human needs.

e)

Standards are critical to the interoperability of ICTs and whether we exchange voice, video or data messages, standards enable global communications by ensuring that countries’ ICT networks and devices are speaking the same language.

14.

Information

a)

Standards are critical to the interoperability of ICTs and whether we exchange voice, video or data messages, standards enable global communications by ensuring that countries’ ICT networks and devices are speaking the same language.

b)

Technology is the use of scientific knowledge, experience and resources to create processes products that fulfill human needs.

c)

ICT standardisation is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.

d)

Communication is an act of transmitting messages. It is a process whereby information is exchanged between individuals using symbols, signs or verbal interactions. Communication is important in order to gain knowledge.

e)

Information refers to the knowledge obtained from reading, investigation, study or research. The tools to transmit information are the telephone, television and radio. Information is knowledge and helps us to fulfill our daily tasks.

15.

Тhe European standardizationorganizations: ETSI-

a)

the European Telecommunications Standards Institute

b)

the European Committee for Standardization

c)

the science of designing the user interface

d)

the European Committee for Electrotechnical Standardization

e)

the science of the psychological impact of computers on the person

16.

Тhe European standardizationorganizations:CEN –

a)

Sustainable Development Goals

b)

the science of the psychological impact of computers on the person

c)

the European Telecommunications Standards Institute

d)

the European Committee for Standardization

e)

the European Committee for Electrotechnical Standardization

17.

Тhe European standardizationorganizations:Standardization-

a)

Sustainable Development Goals

b)

the science of the psychological impact of computers on the person

c)

the European Committee for Standardization

d)

the European Telecommunications Standards Institute

e)

the European Committee for Electrotechnical Standardization

18.

ICT development

a)

ICT standardization is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.

b)

includes many types of infrastructure and services, ranging from telecommunications, such as voice, data, and media services, to specific applications, such as banking, education, or health, to the implementation of electronic government (e-government).

c)

Technology is the use of scientific knowledge, experience and resources to create processes products that fulfill human needs.

d)

Information refers to the knowledge obtained from reading, investigation, study or research. The tools to transmit information are the telephone, television and radio. Information is knowledge and helps us to fulfill our daily tasks.

e)

is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.

19.

ICT standardization

a)

Technology is the use of scientific knowledge, experience and resources to create processes products that fulfill human needs.

b)

is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.

c)

ICT standardization is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure

d)

includes many types of infrastructure and services, ranging from telecommunications, such as voice, data, and media services, to specific applications, such as banking, education, or health, to the implementation of electronic government (e-government).

e)

Information refers to the knowledge obtained from reading, investigation, study or research. The tools to transmit information are the telephone, television and radio. Information is knowledge and helps us to fulfill our daily tasks.

20.

What did Ch. Babbage invent in 1812

a)

Windows

b)

the first calculating machine

c)

the driver

d)

Xerox

21.

Father of the computer

a)

Mohammad Usman Khan

b)

Charles Babbage

c)

Frederick P. Brooks

d)

Ada Lovelace

e)

KonradZuse

22.

ALU-

a)

arithmetic unit

b)

arithmetic low unit

c)

algebra logic unit

d)

arithmetic logic unprocess

e)

arithmetic logic unit

23.

Static RAM is used as:

a)

arithmetic unit

b)

Memory in hard drives

c)

Video Memory

d)

Cache

e)

Flash memory

24.

… is a computer program that you use for writing letters, reports, documents, or the software that is used for this purpose

a)

A word processor

b)

Databases

c)

Graphics

d)

e-mail

e)

laptop

25.

It is a portable computer weighing about 2-4 kg.

a)

PC

b)

laptop

c)

supercomputer

d)

mainframe

e)

mobile

26.

Computer architecture is:

a)

a description of the devices for input and output of information;

b)

a description of the device and the principles of operation of the computer, sufficient to understand the user.

c)

technical description of the details of the devices;

d)

technical description of the details of the computer devices;

e)

A description of the computer's software;

27.

A computer is:

a)

a universal device for transmitting and receiving information.

b)

a universal, electronic device for storing, processing and transmitting information;

c)

An electronic device for processing information;

d)

a universal device for recording and reading information;

e)

a universal device for recording

28.

Hardware is:

a)

a system for the creation of new programmes

b)

a universal device for transmitting and receiving information.

c)

a universal device for recording

d)

computer hardware

e)

the most popular system for IBM PC computers

29.

Software is:

a)

computer software

b)

support program

c)

a system for the creation of new programmes

d)

the most popular system for IBM PC computers

e)

only programs to connect new devices to the computer

30.

The speed of information processing in the computer depends on:

a)

RAD

b)

clock speed

c)

RAM

d)

clock speeds

e)

hard drive

31.

Specify the unit of measurement of memory capacity:

a)

test

b)

beat

c)

tact

d)

GHz

e)

KB

32.

Peripherals are designed for:

a)

design improvementss

b)

exchange of information between the computer and the user

c)

computer design improvements

d)

information between the computer and the user

e)

performing arithmetic-logical operations

33.

What is the frequency of regeneration of the monitor measured:

a)

Hertzakh

b)

design

c)

volts

d)

seconds

e)

operations

34.

The resolution of the monitor is:

a)

computer design improvements

b)

exchange of information between the computer and the user

c)

information between the computer and the user

d)

number of pixels vertically and horizontally

e)

number of pixels horizontally

35.

What function do peripherals perform:

a)

number of pixels horizontally

b)

information between the computer and the user

c)

input-output of information

d)

information processing

e)

storage of information

36.

The chipset on the motherboard is:

a)

Combination of system bus and RAM

b)

The totality of all ports and connectors on the motherboard

c)

The totality of al connectors on the motherboard

d)

A set of chips of the north and south bridge

e)

The totality of all devices located on the motherboard

37.

What is not a characteristic of RAM?

a)

Memory type

b)

typr

c)

Timings

d)

Throughput

e)

Cost

38.

The North Bridge on the motherboard supports:

a)

Hard drives and optical drives

b)

System bus, RAM, video card

c)

printers, scanners

d)

Keyboards, mice, printers, scanners

e)

Sound card and modem

39.

What is the name of the CPU socket?

a)

interface

b)

Socket

c)

Port

d)

Chipset

e)

Tire

40.

A graphical user interface operating system front-end to MSDOS developed by the Microsoft Corporation

a)

Paint

b)

Word

c)

Mac OS X

d)

Windows

e)

Lunix

41.

A clone of the Unix operating system created by Linus Torvalds for use on personal computers -

a)

Windows

b)

Linux

c)

Memory

d)

Macromedi

e)

Mac OS X

42.

Interface -…

a)

the hardware or software that connects two systems and allows them to communicate with each other

b)

a method for storing and organizing computer files and the data they contain to make it easy to find and access them.

c)

a method for storing and organizing computer files and the data they contain to make it easy to find and access them.

d)

network internal to an organization that uses Internet protocols

e)

the physical components of a computer system

43.

File system-…

a)

network internal to an organization that uses Internet protocols

b)

the hardware or software that connects two systems and allows them to communicate with each other

c)

a method for storing and organizing computer files and the data they contain to make it easy to find and access them.

d)

the physical components of a computer system

e)

a type of user interface which allows people to interact with a computer and computer-controlled devices which employ graphical icons, visual indicators or special graphical elements called "widgets", along with text, labels or text navigation to represent the information and actions available to a user.

44.

A systems program that controls a peripheral device

a)

Embedded software

b)

Expert system

c)

Duplex

d)

Eiffel

e)

Driver

45.

Pick out the right definition: Operating system

a)

a complex of the system and control programs intended for the most effective using of all resources of the computing system and convenience of work with it.

b)

a piece of hardware

c)

is a disk copy command

d)

a disk drive

e)

a table of contents for the disk

46.

Pick out the right definition: Programme

a)

device name

b)

error message

c)

devices to perform commands

d)

instructions written in computer language

e)

a place where information is stored

47.

Android is a mobile operating system developed by …

a)

Nokia

b)

Microsoft

c)

Windows

d)

Apple

e)

Google

48.

Simbian is a mobile operating system developed by …

a)

Nokia

b)

Windows

c)

Apple

d)

Microsoft

e)

Google

49.

iOs (originally iPhone OS) is a mobile operating system created and developed by …

a)

Nokia

b)

Microsoft

c)

Windows

d)

Apple Inc.

e)

Google

50.

Android is a mobile operating system developed by Google, based on the …(?) kernel and designed primarily for touch screen mobile devices such as smartphones and tablets.

a)

Yandex

b)

Linux

c)

Windows

d)

iOS

e)

Microsoft

51.

An …(?).. is system software that control computer hardware and software resources and provides common services for computer programs.

a)

Yandex

b)

operating system (OS)

c)

Microsoft

d)

Windows hardware

e)

Internet Explorer

52.

A single-tasking operating system can only run (?) program at a time

a)

Many

b)

4

c)

One

d)

Two

e)

3

53.

OS (abbreviation)

a)

un system

b)

operating system

c)

old system

d)

open system

e)

offen system

54.

If you or your computer makes a mistake when using a device or MS-DOS command, MS-DOS displays an appropriate….

a)

Device names

b)

error message

c)

diskcopy.exe

d)

device errors

e)

Result

55.

Microsoft Windows (or simply Windows) is a system software that makes your ….(or compatible) easy to use

a)

PC

b)

device errors

c)

Result

d)

diskcopy.exe

e)

Device names

56.

What is the file?

a)

segment of the program, which stores some value

b)

hard disk

c)

Several programs

d)

a named collection of data on disk

e)

fragment of a text document

57.

In OS Windows «clipboard» is ...

a)

Writes the selected piece in a file

b)

The special area of memory for temporary storage of information when moving objects

c)

Land of memory on your hard drive

d)

Part of the memory where the operating system

e)

Windows applications Word

58.

The types of operating systems:

a)

Real time

b)

Graphical

c)

Time sharing

d)

Natural Language

e)

Data creating

59.

An open source operating system is used primarily for handheld devices:

a)

Mac OS

b)

Windows 7

c)

IOS

d)

Windows 10

e)

Android

60.

Operating system

a)

None of the above

b)

provides a layered, user-friendly interface

c)

enables the programmer to draw a flowchart

d)

all of the above

e)

links a program with the subroutines it references

61.

Human Computer Interaction is a multidisciplinary field of study focusing on the design of computer technology and in particular, the interaction between humans (the users) and _________________________________.

a)

Application

b)

Engine

c)

ICT

d)

Computer

e)

Machine

62.

Interaction between ______________________________ occurs at the user interface which includes both software and hardware.

a)

usable and safe systems

b)

user and computers

c)

robot

d)

easy to remember how to use

e)

people and machine

63.

The goals of HCI is to produce ______________________________, as well as functional systems.

a)

usable and safety systems

b)

put people first

c)

easy to remember how to use

d)

usable and safe systems

e)

enjoyable to use

64.

HCI should always consider about what ____________________________, what physical abilities and limitations they may have, how their perceptual systems work, and what they find attractive and enjoyable when they use computers.

a)

users aspect and needs

b)

user interaction

c)

put people first

d)

achieve efficient and safe interaction

e)

usable and safe systems

65.

"During this time, HCI was mainly focused on creating systems that were easy-to-learn and easy-to-use. There were endless possibilities for personal computing, but desktop computers were not very usable tools at first."The description above best described the waves from _____________________.

a)

Wave 3: Self-expression, social change (mid 2000s — 2010s)

b)

Wave 1 : Desktops and mental models (1980s - 1990s)

c)

Wave 2: Collaboration (1995s — early 2000s)

d)

Wave 2: Collaboration & communication (1990s — early 1995s)

e)

Wave 4: Millennium era (end of 2010s — 2050s)

66.

Human-computer interaction (HCI) is a relatively new science that includes study, planning and development of interaction between:

a)

humanoids and robots

b)

people and robots

c)

robots and computers

d)

people and animals

e)

people and computers

67.

The main objective of the human-computer interaction (HCI) is:

a)

to study the anatomy of animals

b)

to conduct contact with aliens

c)

to communicate with other people

d)

to understand the user, his motivation and the problem he is solving

e)

to create super-intelligent robots

68.

A user interface in which a person interacts with digital information through the physical environment-

a)

Command Line Interface (CLI)

b)

Tangible user interface (TUI)

c)

Voice User Interface (VUI)

d)

Natural User Interface (NUI)

e)

Brain Computer Interface (BCI)

69.

Two basic categories of network topologies exist, physical topologies and

a)

mesh topology

b)

logical topologies

c)

a physical star

d)

logical ring topology

e)

network topology

70.

A computer is a

a)

technical device for storing information a

b)

output device

c)

technical device for transmitting information a

d)

universal technical device for working with information a

e)

input device

71.

What is a command-line interface?

a)

Is a means of interacting with a computer program where the user issues commands to the program in the form of successive lines of text.

b)

is a user interface that is effectively invisible, and remains invisible as the user continuously learns increasingly complex interactions.

c)

is a perception driven user interface that is currently still being explored.

d)

should be able to combine the concepts of both the GUI

e)

typically text to speech to play a reply

72.

Principles of user interface development

a)

server

b)

objects

c)

Testing for usability of container

d)

software product design

e)

reducing user memory usage;

73.

A type of user interface that features on-screen objects, such as menus and icons, manipulated by a mouse

a)

Menu Driven Interface (MDI)

b)

Graphical User Interface (GUI)

c)

Command Line Interface (CLI)

d)

Natural Language Interface (NLI)

e)

Basic Input Output System (BIOS)

74.

A key aspect for using the interface

a)

Abailability

b)

Compatibility

c)

Availability

d)

Efficiency

e)

Profitability

75.

Type of attacks which begins with mailing the e-mails containing reference to the known resource (or imitating such link)

a)

Social engineering

b)

Scam

c)

Phishing

d)

Spyware

e)

SQL-Injection

76.

The file is

a)

An application program that allows you to work with text

b)

Named data recorded on a data carrier

c)

a software package for a specific task

d)

Recording information in computer memory

e)

A necessary piece of software, without which a computer cannot work

77.

_______ factual information(as measurements or statistics) used as a basis for reasoning, discussion, or calculation.

a)

Data management

b)

Data mining

c)

Bit

d)

Data visualization

e)

Information

78.

The main function of the computer:

a)

Human and machine communication

b)

Program Application

c)

Task development

d)

HCI

e)

Principle of program management

79.

The main element that organize data is:

a)

server

b)

mining

c)

system

d)

objects

e)

administrator

80.

Where and when the first LTE standard network was put into commercial operation?

a)

Sweden, 2009

b)

Japan, 2012

c)

USA, 2008

d)

France, 2009

e)

Denmark, 2012

81.

A relational database consists of a collection of

a)

Road

b)

Tables

c)

column

d)

values

e)

Row

82.

A……is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes ,and primary keys and foreign keys

a)

Relational database

b)

schema diagram

c)

Relational algebra

d)

Shema flow

e)

Database diagram

83.

A……is a property of the entire relation,rather than of the individual tuples in which each tuple is unique

a)

attribute

b)

fields

c)

rows

d)

key

e)

Key

84.

Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

a)

NAME,CITY

b)

NAME

c)

CITY

d)

ID

e)

CITY,ID

85.

Database which Is the logical design of the database, and the database-which is a snapshot of the data in the database at a given instant in time:

a)

Records

b)

Keys

c)

Tables

d)

Shema, Instance

e)

fields

86.

What is a collection of data or information called, that is stored in a logical and structured way?

a)

Field

b)

Database

c)

Spreadsheet

d)

Story

e)

Column

87.

One piece of information stored about a thing or person is called a

a)

Spreadsheet

b)

Column

c)

Field

d)

Database

e)

Story

88.

In a Database, what is Data or Information stored in?

a)

Filing cabinet

b)

Table

c)

Garage

d)

Online Server

e)

Storeroom

89.

In a Database, a RECORD is...?

a)

..is the name of the vinyl disk to store music recordings.

b)

..is the single piece of information about a person or item

c)

..is the single identification label given to a person or item.

d)

..is all of the data about one person or item.

e)

..is the diagonal line of data made up from a number of random fields.

90.

Tables can contain many records. Records run in: parallel/ time/ rows?

a)

Filing cabinet

b)

rows

c)

Storeroom

d)

Garage

e)

Online Server

91.

A persons' First name, Last name, Date of Birth (DOB), Height, Eye colour and Address are all types of what?

a)

Tags

b)

Records

c)

Files

d)

Tables

e)

Fields

92.

What should a database always contain?

a)

Tags

b)

A database should always contain a key field.

c)

Tables

d)

Records

e)

Files

93.

Where is data stored?

a)

Fields

b)

Tags

c)

Data is stored in a table.

d)

Files

e)

Records

94.

What is a database in which ALL the data is stored in a single table known as?

a)

Functional

b)

Hierarchical database

c)

Records

d)

Relational database

e)

Network

95.

What is a database accessible by many users on different computers known as?

a)

object-oriented database management system (OODBMS)

b)

relational database management system (RDBMS)

c)

in-memory database (IMDB)

d)

end-user database

e)

a multi-access database.

96.

What is a data capture form specifically designed to collect?

a)

Tags

b)

data.

c)

Tables

d)

Records

e)

Files

97.

A type of software program used to create, maintain, and access databases.

a)

object-oriented database management system (OODBMS

b)

database management system (DBMS)

c)

relational database management system (RDBMS)

d)

in-memory database (IMDB)

e)

a multi-access database.

98.

In a database, a field.

a)

Tags

b)

column

c)

Tables

d)

Records

e)

Files

99.

A single category of data to be stored in a database, such as customer names or employee telephone numbers. Also called a column

a)

Tags

b)

field

c)

Records

d)

data.

e)

Tables

100.

In a database, a record.

a)

Tables

b)

Records

c)

field

d)

data.

e)

row

101.

Data mining is an interdisciplinary subfield of …

a)

statistical graphics

b)

mathematic

c)

infographics

d)

computer science

e)

data visualization

102.

Is a graph that uses a branching method to illustrate every possible outcome of a decision

a)

Data analytics

b)

user interface

c)

decision tree

d)

data mining

e)

black box

103.

Data mining methods establishing relationships among items that occur together:

a)

Forecasting

b)

Association

c)

Visualization

d)

Classificatio

e)

Clustering

104.

Data Visualization is connected with the visualization of …

a)

PC

b)

information, infographics, scientific visualization, exploratory data analysis and statistical graphics.

c)

users

d)

mathematical and scientific research

e)

tablets

105.

Data mining is an interdisciplinary subfield of …

a)

statistical graphics

b)

data visualization

c)

infographics

d)

computer science

e)

mathematic

106.

Data mining is an interdisciplinary subfield of …

a)

statistical graphics

b)

data visualization

c)

infographics

d)

computer science

e)

mathematic

107.

Analyzing data to discover patterns and relationships that are important to decision making

a)

Data mining

b)

BitTorrent

c)

Invest manager

d)

Operating system

e)

Database

108.

A numerical representation of a realistic situation, such as a cash flow model of a business, a question or set of instructions that describes the data

a)

Operating system

b)

Database

c)

Data mining

d)

Decision model

e)

Data analyses

109.

Big data technology has some advantage than relational data base systems

a)

Operates just with structured data

b)

Operates with binary digits

c)

Operates with in structured data

d)

Operates just with unstructured data

e)

Operates with structured data

110.

Methods and analysis techniques applicable to big data, allocated at McKinsey report

a)

Procedure class

b)

Logical class

c)

Binary class

d)

Class Methods Data Mining

e)

Operating system

111.

Data mining technology has some methods.

a)

Business to business approach

b)

Microeconomic view

c)

Atanasov profit model

d)

Regression trees, factor analysis

e)

Middle term equation

112.

Theoretical foundations for Data mining need to know basic concepts of some subjects.

a)

Middle term equation

b)

Business to business approach

c)

Middle term equation

d)

Microeconomic view

e)

Atanasov profit model

113.

Data Mining models that allows you to predict data values by using known results from a different data sample:

a)

descriptive models

b)

physical models

c)

predictive models

d)

statistical models

e)

intelligent models

114.

Data mining is:

a)

a process of analyzing numerical data about economic systems

b)

a process of automatic extraction of textual information from large data banks

c)

a process of automatically converting weakly structured data and obtaining an array of data of optimal structure

d)

a process of automatic extraction of numerical information from large data banks

e)

a process of performing automated extraction and generating predictive information from large data banks

115.

Correct record of the cells' unit in MS Excel:

a)

H5xA13

b)

A1:C5

c)

A3:CE

d)

LN1-AE5

e)

ll:8L

116.

How cell coordinates in MS Excel are called?

a)

Letter

b)

Digit

c)

Number

d)

Cell

e)

Address

117.

MS Excel. The cell which located on intersection 3 lines and 1 column is designated:

a)

3A

b)

A3

c)

B1

d)

AA

e)

C1

118.

What is a workbook?

a)

file in MS Access

b)

file in MS PowerPoint

c)

file in MS Excel

d)

file in MS Outlook

e)

file in MS Word

119.

What is the expansion in the file name for MS Excel?

a)

*. com

b)

*. exe

c)

object for automation of frequently performed

d)

*. xls

e)

*. bmp

120.

What are the shortcut keys for AutoSum?

a)

ALT + +

b)

CTRL + S

c)

ALT + =

d)

ALT + S

e)

CTRL + =

121.

In order to get a registration certificate you need to install some software.

a)

NCALayer program

b)

NSLayer program

c)

ESLayer program

d)

EDSLayer program

e)

HardDiscDriveLayer program

122.

An e-mail address consists these components

a)

User home address followed by an any symbol

b)

The name of a computer that handles e-mail accounts

c)

The numbers of a cell phone that handles e-mail accounts

d)

The name of a region that handles e-mail accounts

e)

User Auto increment followed by an @ symbol

123.

A collection of computers and related devices connected in a way that allows them to share data, hardware, and software:

a)

Touch Screen network

b)

NVidia network

c)

Computer network

d)

Students network

e)

System board network

124.

A set of rules that ensures the orderly and accurate transmission and reception of data

a)

Control of transmission

b)

System board network

c)

Communications protocol

d)

Transmission of information

e)

Accurate transmission

125.

Unique identifying numbers assigned to each computer connected to the Internet.

a)

DNS address

b)

FDDI address

c)

IP address

d)

FTP address

e)

DNS address

126.

A computer that stores and distributes files to remote client computers

a)

ATM server

b)

FTP server

c)

FDDI server

d)

PCI server

e)

IP server

127.

The Internet provider is:

a)

an organization engaged in the creation of web-sites

b)

set of rules which helps to get information from another address

c)

a local administration

d)

a peripheral device that is used to communicate with another computer

e)

the organization provider of Internet services

128.

E-mail messages have a standard format that consists of

a)

message header

b)

e-mail account

c)

e-mail message

d)

e-mail server

e)

e-mail system

129.

A term sometimes used to refer to the interconnection of personal digital devices or consumer electronics within a range of about 30 feet (10 meters) and without the use of wires or cables:

a)

LAN (local area network)

b)

SAN (small area network)

c)

PAN (personal area network)

d)

MAN (middle area network)

e)

GAN (great area network)

130.

A data communications network that connects personal computers within a very limited geographical area—usually a single building. Its use a variety of wired and wireless technologies:

a)

GAN (great area network)

b)

PAN (personal area network)

c)

LAN (local area network)

d)

MAN (middle area network)

e)

SAN (small area network)

131.

Public high-speed network capable of voice and data transmission within a range of about 50 miles (80 km). For example local Internet service providers, small cable television companies, and local telephone companies:

a)

LAN (local area network)

b)

MAN (metropolitan area network)

c)

PAN (personal area network)

d)

MAN (middle area network)

e)

SAN (small area network)

132.

Type of networks covers a large geographical area and usually consists of several smaller networks, which might use different computer platforms and network technologies:

a)

MAN (metropolitan area network)

b)

MAN (middle area network)

c)

WAN (wide area network)

d)

PAN (personal area network)

e)

LAN (local area network)

133.

The number of bits made up the IP address:

a)

24

b)

20

c)

16

d)

32

e)

10

134.

Internet was originally developed as a(n):

a)

Transportation project

b)

Healthcare project

c)

Educational project

d)

Scientific project

e)

Military project

135.

Type of computing provides access to information, applications, communications, and storage over the internet:

a)

Digita

b)

Network

c)

Cloud

d)

Web

e)

Internet

136.

A dorm-room network covers a limited area and is an example of network.

a)

limited

b)

wide

c)

narrow

d)

personal

e)

local

137.

Each connection point on a network is referred to as a network

a)

group

b)

node

c)

virus

d)

computer

e)

protocol

138.

Set standards for encoding and decoding data, guiding data to its destination, and mitigating the effects of noise are communications:

a)

laws

b)

computers

c)

regulations

d)

nodes

e)

protocols

139.

A way to transfer files from one computer to another over any TCP/IP network, such as a LAN or the Internet provides:

a)

Cloud computing

b)

VoIP

c)

FTP (File Transfer Protocol)

d)

Real-time messaging

e)

Grid computing

140.

Is a modem a device?

a)

for storing information and for printing information

b)

to transfer information via telephone communication channels

c)

for printing information

d)

to store information

e)

to process information at a given time

141.

Formalized rules governing the sequence and format of messages exchanged between network components, OSI models lying at the same level, but in different nodes, are called:

a)

Standard.

b)

Protocol stack.

c)

By route.

d)

Protocol.

e)

Interface.

142.

Global computer network means:

a)

LAN, MAN

b)

CAN

c)

MAN

d)

WAN

e)

LAN

143.

The server that controls client file access is called:

a)

Provider

b)

Server

c)

Post

d)

Proxy

e)

File server

144.

The main types of computer networks are networks:

a)

Regional

b)

Social, entertainment, business oriented

c)

Local, global, regional

d)

Local, global

e)

Client, corporate, international

145.

What components of a computer network are required to organize a peer-to-peer local area network?

a)

Server computer, workstations

b)

Workstations

c)

Modem, server computer

d)

Communication lines, network card, network software

e)

Network card, network software

146.

Choose the devices, which purpose is to expand the size of the network in the current environment:

a)

Protocol

b)

TCP/IP Model

c)

Internet Protocol

d)

Modem

e)

Bridge

147.

The purpose of digital signatures,which respect to security on the Internet:

a)

To encrypt messages

b)

To post anonymous messages to bulletin boards

c)

To verify the identity of a messages sender

d)

To encrypt mail messages

e)

To request receipts for all sent messages

148.

Basic topologies network:

a)

Ring, Tree

b)

Tree, Ring

c)

Mesh, Star

d)

Star, Bus

e)

Bus, Ring, Star, Mesh, Mixed topology

149.

Which is the best description of WANs?

a)

Local area networks located within a large building.

b)

Connects local area networks located within a large building.

c)

Combine workstations, terminals and other

devices located within the building.

d)

Used to connect LANs separated by significant geographic distances.

e)

Combine workstations, terminals and other devices

located within the city.

150.

A popular network technology in which network nodes are connected by coaxial cable or twisted-pair wire.

a)

Token Ring

b)

Star-ring

c)

Domain

d)

Ethernet

e)

Ring

ИКТ1010

Total questions: 150

Worksheet time: 1hrs 15mins

Similar Resources on Wayground