Free Printable ИКТ тест1

1.

Computer networks can be classified by considering which of the following aspect

a)

Local and wide area networks

b)

The functional relationship (Network Architectures)

c)

fault-tolerant features

d)

Media Access Control (MAC) address

e)

Data Link Control (DLC) address

2.

Which one is a category of Connection method basis

a)

DLC

b)

Wireless LAN

c)

Broadcasts

d)

VoIP phones

e)

Laptops

3.

The basis of Metropolitan Area Network (MAN) category is a

a)

Node

b)

Scale

c)

Network Topology

d)

Area

e)

Entity

4.

A personal area network (PAN) a computer network that will be useful in communicating computerizes devices such as

a)

Node and server

b)

HUB and client

c)

Telephones and PDAs

d)

Firewalls and routers

e)

Servers and clients

5.

A computer network covering a small geographic area, like a home, office, or group of buildings is

a)

Wide Area Network (WAN)

b)

Security area Network

c)

Mobile handheld devices

d)

A local area network (LAN)

e)

Firewalls

6.

A group of computers and network devices connected across large physical areas such as states or countries is called

a)

The Web Site connection

b)

Wide Area Network (WAN)

c)

Router Area

d)

LAN

e)

Broadcast area

7.

The largest WAN in existence is

a)

Mozilla

b)

The Internet

c)

Ethernet

d)

Optical fiber

e)

Home PAN

8.

Network topology`s category is

a)

Client-server networking

b)

Tree or Hierarchical topology

c)

Peer-to-peer (workgroup)

d)

Ethernet

e)

Personal Area Network (PAN)

9.

The basis of Active-Networking category is

a)

Scale

b)

Functional Relationship (Architecture)

c)

Network topology

d)

Home PNA

e)

Client-server networking

10.

Most of the computer viruses are designed to

a)

Help uploading applications

b)

Exploit some kind of an error (security hole)

c)

Not self-replicate

d)

Update installed programs

e)

Improve systems` work

11.

Which virus runs on computers memory

a)

Multipartite virus

b)

Resident virus

c)

Direct Action Virus

d)

Boots

e)

Worms

12.

Nonresident viruses are activated

a)

Through the replication of malicious code

b)

When user performs specific activity such as accessing floppy/removable media

c)

Through the storage devices

d)

By executable code found in specific system areas on a disk

e)

Through email account

13.

Which programs make it possible to automate series of operations so that they are performed as a single action

a)

Anti-virus programs

b)

MACROS

c)

Cleaners

d)

DevOps

e)

Adobe Flash

14.

The functions of e-mail servers

a)

Provides a way to locate a resource on the web

b)

To accept, forward, deliver, and store messages

c)

Store,relocate

d)

Archive,transmit

e)

Restore , zip

15.

An e-mail must have a

a)

Address

b)

Username followed by an @ (at sign) which is followed by the domain name with a domain suffix

c)

Server

d)

Recipient

e)

ID

16.

What is an email client

a)

It is a server of the recipient`s email service

b)

It is a computer program used to access and manage a user's email

c)

It is the location you type your main message

d)

It's a new message

e)

It`s an online e-mail service

17.

Each domain name represents a unique Web address which is called

a)

An e-mail client

b)

Internet protocol (IP) address

c)

Carbon Copy

d)

Signature

e)

The SMTP Server

18.

… is an electronic spreadsheet that runs on a personal computer

a)

Microsoft Power point

b)

Microsoft Excel

c)

Microsoft Word

d)

Microsoft Access

e)

Microsoft Publisher

19.

Which bar does give the user information about: the current worksheet, data the worksheet contains and etc.

a)

The Formula bar

b)

Status bar

c)

The Quick Access toolbar

d)

The Ribbon

e)

The Title bar

20.

Which command is used to check logical expression in MS Excel

a)

Sum

b)

If statement

c)

Max

d)

Min

e)

Avr

21.

Microsoft Excel consists of

a)

Rows

b)

Worksheets

c)

Columns

d)

Toolbars

e)

Tabs

22.

This function is used to add numbers

a)

the MAX

b)

the SUM

c)

the AVR

d)

the MIN

e)

the SIN

23.

In the MS Excel, a formula begins with … sign.

a)

“/”

b)

“=”

c)

“@“

d)

“*”

e)

“&”

24.

MS Excel. The MAX function is

a)

automatically finds a minimum value of numbers

b)

automatically finds a maximum value of numbers

c)

automatically finds an average value of numbers

d)

automatically adds a column of numbers

e)

automatically counts an amount of numbers

25.

MS Excel. The MIN function is

a)

automatically finds a minimum value of numbers

b)

automatically finds a maximum value of numbers

c)

automatically finds an average value of numbers

d)

automatically adds a column of numbers

e)

automatically counts an amount of numbers

26.

MS Excel. The Count function is

a)

automatically finds a maximum value of numbers

b)

automatically counts of the number of items in a list

c)

automatically finds an average value of numbers

d)

automatically adds a column of numbers

e)

automatically finds a minimum value of numbers

27.

MS Excel. What happens by pressing Esc key and clicking anywhere on the worksheet

a)

adds the highlighted diapason

b)

removes the highlighting

c)

appears a new column

d)

appears a new row

e)

finds an average value of numbers

28.

How many pages does The ribbon contain in MS Excel

a)

5

b)

8

c)

10

d)

9

e)

3

29.

Where does Microsoft Excel display the name of the workbook you are currently using.

a)

On the Status bar

b)

On the Title bar

c)

On the ribbon

d)

On the Formula bar

e)

On the Quick Access tool bar

30.

If the =SUM(C1:C10) function is nested within an =IF() function and value is equal to 10, which expression displays value “Excellent”?

a)

=SUM(IF(C1:C10)=10;”Excellent”;”Bad”)

b)

=IF(SUM(C1:C10)=10;”Excellent”;”Bad”)

c)

=IF(SUM(C10:C1)=10;”Bad’;”Excellent”;”Bad”)

d)

=IF(C1:C10)=10;”Excellent”;”Bad”)

e)

=IF(SUM(C1:C10)=9;”Excellent”;”Bad”)

31.

How is the combination of a column coordinate and a row coordinate called?

a)

A formula bar

b)

A cell address

c)

A title bar

d)

A worksheet name

e)

Acolumncoordinate

32.

What does “test!” mean in the following expression:

a)

=IF(test!D11=1;1;0).

b)

The reference to the worksheet ”test”

c)

The name of the workbook

d)

The address of the worksheet

e)

The coordinate of the cell

33.

Which expression calculates the SUM of the highlighted range (R1:R17) ?

a)

=AVR(R3:R17)

b)

=SUM(R3:R17)

c)

=MAX(R3:R17)

d)

=AUTOSUM(R3:R17)

e)

=SIN(R3:R17)

34.

Which expression calculates the average of the highlighted range (R18:R20) ?

a)

=AVR(R3:R17)

b)

=AVR(R18:R20)

c)

=AUTOSUM(R3:R17)

d)

=SIN(R3:R17)

e)

=MAX(R3:R17)

35.

Which expression finds the maximum of the highlighted range (R18:R20) ?

a)

=AVR(R3:R17)

b)

=MAX(R18:R20)

c)

=AUTOSUM(R3:R17)

d)

=SIN(R3:R17)

e)

=MAX(R3:R17)

36.

Which expression finds the minimum of the highlighted range (R18:R20) ?

a)

=AVR(R3:R17)

b)

=MIN(R18:R20)

c)

=AUTOSUM(R3:R17)

d)

=SIN(R3:R17)

e)

=MIN(R3:R17)

37.

Each worksheet contains

a)

Records

b)

columns and rows

c)

Numbers

d)

data types

e)

Symbols

38.

During execution, the application program is stored:

a)

in video memory;

b)

in the operative memory;

c)

in the processor;

d)

on the hard disk;

e)

in ROM.

39.

Function performed by peripheral devices ...

a)

data storage

b)

input and output of information

c)

information processing

d)

computer control of a given program

e)

program input control

40.

The server is

a)

network program that conducts a dialogue between one user and another

b)

A powerful computer to which other computers connect

c)

an individual user's computer connected to a public network

d)

standard defining the form of presentation and the method for forwarding the message

e)

network program that does not conduct a dialogue between one user and another

41.

A hard disk is a device, which provides

a)

input of graphic information;

b)

data storage with random access;

c)

output of alphanumeric and graphic information;

d)

storage of data on laser disks;

e)

to connect computers to the global network.

42.

Flash drives are devices that provide

a)

output of alphanumeric and graphic information;

b)

data storage with random access;

c)

input of graphic information;

d)

output of alphanumeric and graphic information on the sheet;

e)

input alphanumeric and graphic information.

43.

The biggest and complex integral microcircuit of the computer

a)

Motherboard

b)

CPU

c)

Network Card

d)

Sound card

e)

Video card

44.

Device used for transmitting information over telephone lines:

a)

Microphone

b)

Modem

c)

Scanner

d)

network card

e)

Printer

45.

Any information (text, graphic, sound, etc.) is written to disk in the form:

a)

picture;

b)

digits;

c)

file;

d)

extensions;

e)

mathematical expressions.

46.

While the operating system is loading there is a

a)

copying operating system files from a floppy disk to a hard disk;

b)

sequential downloading of files from the operating system to the random access memory;

c)

copying operating system files from CD-ROM to hard disk;

d)

copying the contents of RAM to the hard disk;

e)

copying files to the hard disk.

47.

The function of the operating system does not include:

a)

dialogue with the user

b)

transfer of information to a remote user

c)

input-output and data management

d)

allocation of resources (RAM, cache, processor, etc.)

e)

launching programs for execution

48.

Translate the number 32 from decimal to binary.

a)

010010

b)

100000

c)

100001

d)

1111111

e)

100001

49.

Hardware is

a)

one of the components of information technology - hardware

b)

a hard disk inside the system unit

c)

one of the components of information technology - software

d)

CD

e)

reboot program

50.

Software is

a)

one of the components of information technology - hardware

b)

All programs that installed on a computer

c)

a hard disk inside the system unit

d)

CD

e)

reboot program

51.

Define the system software

a)

This is the set of programs of the operating system.

b)

This is part of the software used to provide work of PC hardware and work with application programs.

c)

It is a means of creating application programs.

d)

These are standard programs

e)

This is part of the software that serves to solve user tasks.

52.

Define the application software

a)

This is part of the software needed to develop application programs.

b)

This is part of the software for solving application problems.

c)

This is the set of programs of the operating system

d)

This is a collection of utilities.

e)

This is part of the operating system program

53.

Utilities are

a)

application programs.

b)

system programs for service purposes.

c)

collection of tools.

d)

resident programs.

e)

used for creating application programs.

54.

General Application Programs

a)

This is part of the software needed to develop system programs.

b)

These are the programs for solve problems in any area of the PC application.

c)

This is a collection of applications for solving problems in a specific area of a PC application.

d)

Is a collection of programs for service purposes.

e)

This is the main part of the software needed to develop it.

55.

Anti-virus programs are:

a)

application programs.

b)

system programs.

c)

tools.

d)

programming systems

e)

Utilities

56.

The software tools are designed for:

a)

creation of application programs.

b)

creation of system and application programs.

c)

creation of system programs.

d)

creating utilities.

e)

programming languages

57.

The software of the PC includes:

a)

system, problem and application programs.

b)

system, applied, instrumental software.

c)

system and tool software.

d)

applied, problematic and instrumental software.

e)

none

58.

Windows registry is an example of the following database:

a)

Relational

b)

Hierarchical

c)

object-oriented

d)

Network

59.

File is

a)

RAM

b)

Named area for storing documents

c)

Microprocessor

d)

Place on the disk in which the file names are stored

e)

Scanner

ИКТ тест1

Total questions: 59

Worksheet time: 10mins

Similar Resources on Wayground