wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ICT.

Total questions: 150

Worksheet time: 3hrs 30mins

Name
Class
Date
1.

What is the Computer science

a)

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

b)

the science of e-mail

c)

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

d)

unit recording information on a floppy disk

e)

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

2.

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

a)

Information

b)

Protocol

c)

Computer

d)

Data

e)

Information processes

3.

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

a)

Data

b)

Information

c)

Protocol

d)

Computer

e)

Information processes

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)

the information and communication technologies

b)

Information processes

c)

Data

d)

Information

e)

Computer Science

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)

Information and communications technology

b)

Multimedia technology

c)

Cloud technology

d)

Digital 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)

ICT

b)

Multimedia

c)

Cloud

d)

WAN

e)

LAN

8.

What is multimedia?

a)

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

b)

Moving images and text

c)

Images and audio

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)

Discipline “ICT”

b)

Idea of “ICT”

c)

Purpose of “ICT”

d)

Mission of “ICT”

e)

Ideology of “ICT”

10.

Choose right variant. The practical purpose of the ICT course

a)

All answers are correct

b)

helping to expand the horizons of students

c)

improve their general culture, education, and justice

d)

provides academic and educational purposes

e)

ICT in entertainment

11.

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

a)

e-commerce

b)

e-document

c)

e-business

d)

e-service

e)

Е- Subject

12.

Communication

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)

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

d)

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

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)

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

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)

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.

d)

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

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)

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.

b)

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

c)

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

d)

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

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.

15.

Тhe European standardization organizations: ETSI-

a)

the European Telecommunications Standards Institute

b)

the European Committee for Electrotechnical Standardization

c)

the European Committee for Standardization

d)

the science of the psychological impact of computers on the person

e)

the science of designing the user interface

16.

Тhe European standardization organizations: CEN –

a)

the European Committee for Standardization

b)

the European Telecommunications Standards Institute

c)

the European Committee for Electrotechnical Standardization

d)

Sustainable Development Goals

e)

the science of the psychological impact of computers on the person

17.

Тhe European standardization organizations: Standardization-

a)

the European Committee for Electrotechnical Standardization

b)

the European Committee for Standardization

c)

the European Telecommunications Standards Institute

d)

Sustainable Development Goals

e)

the science of the psychological impact of computers on the person

18.

ICT development

a)

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).

b)

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

c)

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.

d)

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

e)

ICT standardization 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)

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)

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.

d)

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

e)

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

20.

Interface -…

a)

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

b)

the physical components of a computer system

c)

network internal to an organization that uses Internet protocols

d)

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

e)

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

21.

What did Ch. Babbage invent in 1812

a)

the first calculating machine

b)

Xerox

c)

the driver

d)

IBM PC

e)

Windows

22.

Father of the computer

a)

Charles Babbage

b)

Ada Lovelace

c)

Konrad Zuse

d)

Frederick P. Brooks

e)

Mohammad Usman Khan

23.

ALU-

a)

arithmetic logic unit

b)

arithmetic logic unprocess

c)

arithmetic low unit

d)

algebra logic unit

e)

arithmetic unit

24.

Static RAM is used as:

a)

Cache

b)

Memory in hard drives

c)

Video Memory

d)

Flash memory

e)

arithmetic unit

25.

… 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

26.

It is a portable computer weighing about 2-4 kg

a)

laptop

b)

mainframe

c)

supercomputer

d)

mobile

e)

PC

27.

Computer architecture is:

a)

technical description of the details of the computer devices;

b)

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

c)

A description of the computer's software;

d)

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

e)

technical description of the details of the devices;

28.

A computer is:

a)

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

b)

a universal device for recording and reading information;

c)

An electronic device for processing information

d)

a universal device for transmitting and receiving information

e)

a universal device for recording

29.

Hardware is:

a)

computer hardware

b)

a system for the creation of new programmes

c)

the most popular system for IBM PC computers

d)

a universal device for transmitting and receiving information.

e)

a universal device for recording

30.

Software is:

a)

computer software

b)

only programs to connect new devices to the computer

c)

support program

d)

a system for the creation of new programmes

e)

the most popular system for IBM PC computers

31.

The speed of information processing in the computer depends on:

a)

RAM

b)

hard drive

c)

clock speed

d)

clock speeds

e)

RAD

32.

Specify the unit of measurement of memory capacity:

a)

KB

b)

beat

c)

GHz

d)

tact

e)

test

33.

Peripherals are designed for:

a)

exchange of information between the computer and the user

b)

performing arithmetic-logical operations

c)

information between the computer and the user

d)

computer design improvements

e)

design improvementss

34.

What is the frequency of regeneration of the monitor measured:

a)

Hertzakh

b)

design

c)

volts

d)

seconds

e)

operations

35.

The resolution of the monitor is:

a)

number of pixels vertically and horizontally

b)

information between the computer and the user

c)

computer design improvements

d)

number of pixels horizontally

e)

exchange of information between the computer and the user

36.

What function do peripherals perform:

a)

input-output of information

b)

information processing

c)

number of pixels horizontally

d)

storage of information

e)

information between the computer and the user

37.

The chipset on the motherboard is:

a)

A set of chips of the north and south bridge

b)

The totality of all devices located on the motherboard

c)

The totality of all ports and connectors on the motherboard

d)

Combination of system bus and RAM

e)

The totality of al connectors on the motherboard

38.

What is not a characteristic of RAM?

a)

Cost

b)

Timings

c)

Throughput

d)

Memory type

e)

typr

39.

The North Bridge on the motherboard supports:

a)

System bus, RAM, video card

b)

Keyboards, mice, printers, scanners

c)

Sound card and modem

d)

Hard drives and optical drives

e)

printers, scanners

40.

What is the name of the CPU socket?

a)

Socket

b)

Chipset

c)

Port

d)

Tire

e)

interface

41.

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

a)

Windows

b)

Lunix

c)

Mac OS X

d)

Word

e)

Paint

42.

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

a)

Linux

b)

Mac OS X

c)

Macromedia

d)

Memory

e)

Windows

43.

File system-…

a)

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

b)

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.

c)

the physical components of a computer system

d)

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

e)

network internal to an organization that uses Internet protocols

44.

A systems program that controls a peripheral device

a)

Driver

b)

Duplex

c)

Eiffel

d)

Embedded software

e)

Expert system

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 table of contents for the disk

c)

is a disk copy command

d)

a disk drive

e)

a piece of hardware

46.

Pick out the right definition: Programme

a)

instructions written in computer language

b)

a place where information is stored

c)

devices to perform commands

d)

error message

e)

device name

47.

Android is a mobile operating system developed by …

a)

Google

b)

Windows

c)

Apple

d)

Microsoft

e)

Nokia

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)

Apple Inc.

b)

Google

c)

Windows

d)

Microsoft

e)

Nokia

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)

Linux

b)

iOS

c)

Windows

d)

Microsoft

e)

Yandex

51.

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

a)

operating system (OS)

b)

Internet Explorer

c)

Windows hardware

d)

Microsoft

e)

Yandex

52.

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

a)

One

b)

Two

c)

Three

d)

Four

e)

Many

53.

OS (abbreviation)

a)

operating system

b)

open system

c)

offen system

d)

old system

e)

un system

54.

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

a)

error message

b)

device errors

c)

Result

d)

diskcopy.exe

e)

Device names

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)

a named collection of data on disk

b)

Several programs

c)

fragment of a text document

d)

segment of the program, which stores some value

e)

hard disk

57.

In OS Windows «clipboard» is ...

a)

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

b)

Windows applications Word

c)

Part of the memory where the operating system

d)

Land of memory on your hard drive

e)

Writes the selected piece in a file

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)

Android

b)

Windows 10

c)

IOS

d)

Windows 7

e)

Mac OS

60.

Operating system

a)

enables the programmer to draw a flowchart

b)

links a program with the subroutines it references

c)

provides a layered, user-friendly interface

d)

all of the above

e)

None of the above

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)

Computer

b)

Machine

c)

Engine

d)

Application

e)

ICT

62.

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

a)

user and computers

b)

people and machine

c)

easy to remember how to use

d)

robot

e)

usable and safe systems

63.

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

a)

usable and safety systems

b)

enjoyable to use

c)

easy to remember how to use

d)

put people first

e)

usable and safe systems

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 1 : Desktops and mental models (1980s - 1990s)

b)

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

c)

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

d)

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

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)

people and robots

b)

people and animals

c)

robots and computers

d)

humanoids and robots

e)

people and computers

67.

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

a)

to study the anatomy of animals

b)

to create super-intelligent robots

c)

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

d)

to communicate with other people

e)

to conduct contact with aliens

68.

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

a)

Tangible user interface (TUI)

b)

Brain Computer Interface (BCI)

c)

Voice User Interface (VUI)

d)

Natural User Interface (NUI)

e)

Command Line Interface (CLI)

69.

Two basic categories of network topologies exist, physical topologies and

a)

logical topologies

b)

logical ring topology

c)

a physical star

d)

network topology

e)

mesh topology

70.

A computer is a

a)

universal technical device for working with information a

b)

technical device for transmitting information a

c)

technical device for storing information a

d)

input device

e)

output 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)

reducing user memory usage;

b)

software product design

c)

Testing for usability of container

d)

objects

e)

server

73.

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

a)

Command Line Interface (CLI)

b)

Natural Language Interface (NLI)

c)

Graphical User Interface (GUI)

d)

Menu Driven Interface (MDI)

e)

Basic Input Output System (BIOS)

74.

A key aspect for using the interface

a)

Compatibility

b)

Availability

c)

Efficiency

d)

Profitability

e)

Abailability

75.

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

a)

Phishing

b)

SQL-Injection

c)

Spyware

d)

Social engineering

e)

Scam

76.

The file is

a)

Named data recorded on a data carrier

b)

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

c)

An application program that allows you to work with text

d)

Recording information in computer memory

e)

a software package for a specific task

77.

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

a)

Bit

b)

Data visualization

c)

Data management

d)

Information

e)

Data mining

78.

The main function of the computer:

a)

Principle of program management

b)

Program Application

c)

Human and machine communication

d)

Task development

e)

HCI

79.

The main element that organize data is:

a)

objects

b)

administrator

c)

system

d)

mining

e)

server

80.

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

a)

Sweden, 2009

b)

Denmark, 2012

c)

USA, 2008

d)

Japan, 2012

e)

France, 2009

81.

A relational database consists of a collection of

a)

Tables

b)

Row

c)

column

d)

values

e)

Road

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)

schema diagram

b)

Shema flow

c)

Relational algebra

d)

Database diagram

e)

Relational database

83.

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

a)

Key

b)

rows

c)

key

d)

attribute

e)

fields

84.

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

a)

ID

b)

NAME

c)

CITY

d)

CITY,ID

e)

NAME,CITY

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)

Shema, Instance

b)

Tables

c)

fields

d)

Records

e)

Keys

86.

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

a)

Database

b)

Field

c)

Story

d)

Column

e)

Spreadsheet

87.

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

a)

Field

b)

Database

c)

Story

d)

Column

e)

Spreadsheet

88.

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

a)

Table

b)

Garage

c)

Storeroom

d)

Online Server

e)

Filing cabinet

89.

In a Database, a RECORD is...?

a)

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

b)

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

c)

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

d)

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

e)

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

90.

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

a)

rows

b)

Garage

c)

Storeroom

d)

Online Server

e)

Filing cabinet

91.

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

a)

Fields

b)

Records

c)

Tables

d)

Files

e)

Tags

92.

What should a database always contain?

a)

A database should always contain a key field.

b)

Records

c)

Tables

d)

Files

e)

Tags

93.

Where is data stored?

a)

Data is stored in a table.

b)

Records

c)

Files

d)

Tags

e)

Fields

94.

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

a)

Relational database

b)

Hierarchical database

c)

Network

d)

Functional

e)

Records

95.

What is a data capture form specifically designed to collect?

a)

data.

b)

Records

c)

Tables

d)

Files

e)

Tags

96.

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

a)

a multi-access database.

b)

end-user database

c)

in-memory database (IMDB

d)

object-oriented database management system (OODBMS)

e)

relational database management system (RDBMS)

97.

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

a)

database management system (DBMS)

b)

a multi-access database.

c)

in-memory database (IMDB)

d)

relational database management system (RDBMS)

e)

object-oriented database management system (OODBMS

98.

In a database, a field.

a)

column

b)

Records

c)

Tables

d)

Files

e)

Tags

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)

field

b)

data

c)

Records

d)

Tables

e)

Tags

100.

In a database, a record.

a)

row

b)

field

c)

data.

d)

Records

e)

Tables

101.

Data mining is an interdisciplinary subfield of …

a)

data visualization

b)

mathematic

c)

computer science

d)

infographics

e)

statistical graphics

102.

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

a)

decision tree

b)

black box

c)

data mining

d)

Data analytics

e)

user interface

103.

Data mining methods establishing relationships among items that occur together:

a)

Association

b)

Classification

c)

Clustering

d)

Forecasting

e)

Visualization

104.

Data Visualization is connected with the visualization of …

a)

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

b)

mathematical and scientific research

c)

users

d)

tablets

e)

PC

105.

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

a)

BitTorrent

b)

Database

c)

Data mining

d)

Operating system

e)

Invest manager

106.

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)

Data mining

b)

Data analyses

c)

Decision model

d)

Operating system

e)

Database

107.

Big data technology has some advantage than relational data base systems

a)

Operates with structured data

b)

Operates just with structured data

c)

Operates just with unstructured data

d)

Operates with in structured data

e)

Operates with binary digits

108.

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

a)

Class Methods Data Mining

b)

Operating system

c)

Procedure class

d)

Binary class

e)

Logical class

109.

Data mining technology has some methods.

a)

Regression trees, factor analysis

b)

Microeconomic view

c)

Middle term equation

d)

Atanasov profit model

e)

Business to business approach

110.

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

a)

Middle term equation

b)

Microeconomic view

c)

Middle term equation

d)

Atanasov profit model

e)

Business to business approach

111.

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

a)

physical models

b)

statistical models

c)

predictive models

d)

intelligent models

e)

descriptive models

112.

Data mining is:

a)

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

b)

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

c)

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

d)

a process of analyzing numerical data about economic systems

e)

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

113.

Correct record of the cells' unit in MS Excel:

a)

A1:C5

b)

ll:8L

c)

LN1-AE5

d)

H5xA13

e)

A3:CE

114.

How cell coordinates in MS Excel are called?

a)

Address

b)

Digit

c)

Cell

d)

Letter

e)

Number

115.

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

a)

A3

b)

C1

c)

AA

d)

3A

e)

B1

116.

What is a workbook?

a)

file in MS Excel

b)

file in MS Word

c)

file in MS Access

d)

file in MS PowerPoint

e)

file in MS Outlook

117.

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

a)

*. xls

b)

*. exe

c)

*. bmp

d)

*. com

e)

object for automation of frequently performed

118.

What are the shortcut keys for AutoSum?

a)

ALT + S

b)

CTRL + S

c)

ALT + =

d)

CTRL + =

e)

ALT + +

119.

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

a)

NCALayer program

b)

EDSLayer program

c)

HardDiscDriveLayer program

d)

NSLayer program

e)

ESLayer program

120.

An e-mail address consists these components

a)

The name of a computer that handles e-mail accounts

b)

User Auto increment followed by an @ symbol

c)

User home address followed by an any symbol

d)

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

e)

The name of a region that handles e-mail accounts

121.

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

a)

Computer network

b)

System board network

c)

NVidia network

d)

Touch Screen network

e)

Students network

122.

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

a)

Communications protocol

b)

System board network

c)

Accurate transmission

d)

Transmission of information

e)

Control of transmission

123.

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

a)

Ethernet

b)

Ring

c)

Token Ring

d)

Domain

e)

Star-ring

124.

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

a)

IP address

b)

DNS address

c)

FTP address

d)

DNS address

e)

FDDI address

125.

A computer that stores and distributes files to remote client computers

a)

FTP server

b)

IP server

c)

PCI server

d)

FDDI server

e)

ATM server

126.

The Internet provider is:

a)

a local administration

b)

the organization provider of Internet services

c)

an organization engaged in the creation of web-sites

d)

a peripheral device that is used to communicate with another computer

e)

set of rules which helps to get information from another address

127.

E-mail messages have a standard format that consists of

a)

e-mail message

b)

e-mail system

c)

e-mail server

d)

message header

e)

e-mail account

128.

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)

SAN (small area network)

b)

GAN (great area network)

c)

MAN (middle area network

d)

PAN (personal area network

e)

LAN (local area network)

129.

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)

SAN (small area network)

b)

GAN (great area network)

c)

MAN (middle area network)

d)

PAN (personal area network)

e)

LAN (local area network)

130.

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)

SAN (small area network)

b)

MAN (middle area network)

c)

PAN (personal area network)

d)

LAN (local area network)

e)

MAN (metropolitan area network

131.

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 (middle area network)

b)

PAN (personal area network)

c)

LAN (local area network)

d)

MAN (metropolitan area network

e)

WAN (wide area network)

132.

The number of bits made up the IP address:

a)

32

b)

10

c)

20

d)

16

e)

24

133.

Internet was originally developed as a(n):

a)

Healthcare project

b)

Military project

c)

Educational project

d)

Scientific project

e)

Transportation project

134.

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

a)

Internet

b)

Network

c)

Web

d)

Cloud

e)

Digital

135.

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

a)

local

b)

wide

c)

narrow

d)

personal

e)

limited

136.

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

a)

protocol

b)

node

c)

computer

d)

virus

e)

group

137.

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

a)

nodes

b)

computers

c)

protocols

d)

laws

e)

regulations

138.

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

a)

VoIP

b)

Grid computing

c)

Real-time messaging

d)

Cloud computing

e)

FTP (File Transfer Protocol)

139.

Is a modem a device?

a)

to transfer information via telephone communication channels

b)

to process information at a given time

c)

to store information

d)

for printing information

e)

for storing information and for printing information

140.

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)

Protocol.

b)

Interface.

c)

Protocol stack.

d)

Standard.

e)

By route.

141.

Global computer network means:

a)

WAN

b)

LAN

c)

MAN

d)

CAN

e)

LAN, MAN

142.

The server that controls client file access is called:

a)

File server

b)

Post

c)

Proxy

d)

Server

e)

Provider

143.

The main types of computer networks are networks:

a)

Local, global, regional

b)

Client, corporate, international

c)

Social, entertainment, business oriented

d)

Local, global

e)

Regional

144.

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

a)

Modem, server computer

b)

Network card, network software

c)

Server computer, workstations

d)

Communication lines, network card, network software

e)

Workstations

145.

Which is the best description of WANs?

a)

Used to connect LANs separated by significant geographic distances.

b)

Combine workstations, terminals and other devices

located within the city.

c)

Connects local area networks located within a large building.

d)

Combine workstations, terminals and other

devices located within the building.

e)

Local area networks located within a large building.

146.

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

a)

Bridge

b)

TCP/IP Model

c)

Modem

d)

Internet Protocol

e)

Protocol

147.

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

a)

To verify the identity of a messages sender

b)

To request receipts for all sent messages

c)

To encrypt messages

d)

To encrypt mail messages

e)

To post anonymous messages to bulletin boards

148.

Basic topologies network:

a)

Bus, Ring, Star, Mesh, Mixed topology

b)

Tree, Ring

c)

Star, Bus

d)

Mesh, Star

e)

Ring, Tree

149.

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

a)

BitTorrent

b)

Database

c)

Data mining

d)

Operating system

e)

Invest manager

150.

What is the Computer science

a)

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

b)

the science of e-mail

c)

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

d)

unit recording information on a floppy disk

e)

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