Free Printable ict aisan

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)

Media Access Control (MAC) address

d)

Data Link Control (DLC) address

e)

fault-tolerant features

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)

Firewalls and routers

d)

Telephones and PDAs

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)

Mobile handheld devices

c)

A local area network (LAN)

d)

Security area Network

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)

Broadcast area

e)

LAN

7.

The largest WAN in existence is

a)

Ethernet

b)

Optical fiber

c)

Mozilla

d)

Home PAN

e)

The Internet

8.

Network topology`s category is

a)

Peer-to-peer (workgroup)

b)

Client-server networking

c)

Personal Area Network (PAN)

d)

Tree or Hierarchical topology

e)

Ethernet

9.

The basis of Active-Networking category is

a)

Scale

b)

Functional Relationship (Architecture)

c)

Network topology

d)

Client-server networking

e)

Home PNA

10.

Most of the computer viruses are designed to

a)

Exploit some kind of an error (security hole)

b)

Help uploading applications

c)

Improve systems` work

d)

Not self-replicate

e)

Update installed programs

11.

Which virus runs on computers memory

a)

Worms

b)

Multipartite virus

c)

Direct Action Virus

d)

Boots

e)

Resident virus

12.

Nonresident viruses are activated

a)

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

b)

Through the storage devices

c)

Through the replication of malicious code

d)

Through email account

e)

By executable code found in specific system areas on a disk

13.

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

a)

Cleaners

b)

Anti-virus programs

c)

Adobe Flash

d)

MACROS

e)

DevOps

14.

The functions of e-mail servers

a)

Provides a way to locate a resource on the web

b)

Store,relocate

c)

Restore , zip

d)

To accept, forward, deliver, and store messages

e)

Archive,transmit

15.

An e-mail must have a

a)

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

b)

ID

c)

Address

d)

Server

e)

Recipient

16.

What is an email client

a)

It is a server of the recipient`s email service

b)

It is the location you type your main message

c)

It's a new message

d)

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

e)

It`s an online e-mail service

17.

Each domain name represents a unique Web address which is called

a)

Carbon Copy

b)

Signature

c)

An e-mail client

d)

The SMTP Server

e)

Internet protocol (IP) address

18.

… is an electronic spreadsheet that runs on a personal computer

a)

Microsoft Excel

b)

Microsoft Access

c)

Microsoft Power point

d)

Microsoft Word

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)

The Title bar

c)

The Ribbon

d)

Status bar

e)

The Quick Access toolbar

20.

Which command is used to check logical expression in MS Excel

a)

Sum

b)

Max

c)

If statement

d)

Avr

e)

Min

21.

Microsoft Excel consists of

a)

Columns

b)

Worksheets

c)

Rows

d)

Toolbars

e)

Tabs

22.

This function is used to add numbers

a)

the MAX

b)

the AVR

c)

the MIN

d)

the SIN

e)

the SUM

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 maximum value of numbers

b)

automatically finds an average value of numbers

c)

automatically finds a minimum 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 finds an average value of numbers

c)

automatically counts of the number of items in a list

d)

automatically finds a minimum value of numbers

e)

automatically adds a column of numbers

27.

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

a)

removes the highlighting

b)

adds the highlighted diapason

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)

9

b)

5

c)

10

d)

8

e)

3

29.

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

a)

On the Formula bar

b)

On the ribbon

c)

On the Status bar

d)

On the Quick Access tool bar

e)

On the Title 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)

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

b)

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

c)

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

d)

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

e)

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

31.

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

a)

A cell address

b)

A formula bar

c)

A title bar

d)

A worksheet name

e)

A column coordinate

32.

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

a)

The name of the workbook

b)

The coordinate of the cell

c)

The address of the worksheet

d)

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

e)

The reference to the worksheet ”test”

33.

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

a)

=SUM(R3:R17)

b)

=AVR(R3:R17)

c)

=AUTOSUM(R3:R17)

d)

=MAX(R3:R17)

e)

=SIN(R3:R17)

34.

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

a)

=AVR(R3:R17)

b)

=AUTOSUM(R3:R17)

c)

=AVR(R18:R20)

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)

=AUTOSUM(R3:R17)

c)

=SIN(R3:R17)

d)

=MAX(R18:R20)

e)

=MAX(R3:R17)

36.

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

a)

=AVR(R3:R17)

b)

=AUTOSUM(R3:R17)

c)

=MIN(R18:R20)

d)

=SIN(R3:R17)

e)

=MIN(R3:R17)

37.

Each worksheet contains

a)

Symbols

b)

Numbers

c)

Records

d)

columns and rows

e)

data types

38.

During execution, the application program is stored:

a)

in the processor;

b)

in video memory;

c)

in the operative memory;

d)

in ROM.

e)

on the hard disk;

39.

Function performed by peripheral devices ...

a)

input and output of information

b)

information processing

c)

data storage

d)

program input control

e)

computer control of a given program

40.

The server is

a)

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

b)

network program that conducts a dialogue between one user and another

c)

A powerful computer to which other computers connect

d)

an individual user's computer connected to a public network

e)

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

41.

A hard disk is a device, which provides

a)

output of alphanumeric and graphic information;

b)

data storage with random access;

c)

input of 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)

CPU

b)

Motherboard

c)

Network Card

d)

Sound card

e)

Video card

44.

Device used for transmitting information over telephone lines:

a)

Printer

b)

Microphone

c)

network card

d)

Scanner

e)

Modem

45.

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

a)

file

b)

picture

c)

digits

d)

extensions

e)

mathematical expressions.

46.

While the operating system is loading there is a

a)

copying files to the hard disk.

b)

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

c)

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

d)

copying the contents of RAM to the hard disk;

e)

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

47.

The function of the operating system does not include:

a)

transfer of information to a remote user

b)

dialogue with the 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)

100001

b)

010010

c)

100001

d)

100000

e)

111111

49.

Hardware is

a)

one of the components of information technology - hardware

b)

one of the components of information technology - software

c)

a hard disk inside the system unit

d)

reboot program

e)

CD

50.

Software is

a)

CD

b)

All programs that installed on a computer

c)

a hard disk inside the system unit

d)

reboot program

e)

one of the components of information technology - hardware

51.

Define the system software

a)

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

b)

These are standard programs

c)

This is the set of programs of the operating system.

d)

It is a means of creating application 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 the set of programs of the operating system

c)

This is part of the software for solving application problems.

d)

This is part of the operating system program

e)

This is a collection of utilities.

53.

Utilities are

a)

system programs for service purposes.

b)

application programs.

c)

collection of tools.

d)

used for creating application programs.

e)

resident programs.

54.

General Application Programs

a)

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

b)

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

c)

Is a collection of programs for service purposes.

d)

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

e)

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

55.

Anti-virus programs are:

a)

programming systems

b)

application programs.

c)

tools

d)

Utilities

e)

system programs.

56.

The software tools are designed for:

a)

creation of application programs.

b)

creation of system programs.

c)

creation of system and application 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)

object-oriented

c)

Hierarchical

d)

Network

59.

File is

a)

Scanner

b)

Place on the disk in which the file names are stored

c)

RAM

d)

Microprocessor

e)

Named area for storing documents

60.

A file that loads the drivers of external devices and sets the operating system parameters is represented as

a)

CONFIG.SYS

b)

MSDOS.SYS

c)

AUTOEXEC.BAT

d)

IO.SYS

e)

NORTON COMMANDER

61.

Define the operating system

a)

This is a system program for controlling external devices.

b)

This is a tool for developing user programs.

c)

This is a system program that manages all operations in the PC.

d)

These are devices for controlling external devices.

e)

It is an application program that allows the user to communicate with a PC.

62.

Define drivers

a)

These are the tools for developing operating systems.

b)

These are system programs that serve individual peripheral devices.

c)

These are application programs that serve individual peripheral devices.

d)

These are devices for controlling external devices.

63.

Catalog (or directory)…

a)

This is the hard drive where user files are stored.

b)

This is a special place in the RAM where user files are stored.

c)

This is a special place on the disk where file names are stored.

d)

This is a system program for controlling external devices.

e)

This is a special place for storing the parameters of the operating system.

64.

Specify a symbol that combines the name and file type

a)

Comma

b)

Colon

c)

Star

d)

Dot

e)

Question mark

65.

The file system on the disk has

a)

tree structure.

b)

relational structure.

c)

linear structure.

d)

dynamic structure.

e)

network structure

66.

2 Gigabyte is equal to

a)

1024 Kilobytes

b)

2048 Megabytes

c)

2048 Terabytes

d)

2048 Bytes

e)

2000 bits

67.

A hard disk is divided into tracks which is further subdivided into

a)

Vectors

b)

Heads

c)

Sectors

d)

Foots

e)

Clusters

68.

The file extension of MS-Power Point document is

a)

doc

b)

.txt

c)

.PPT

d)

. docx

e)

xlsx

69.

The file extension of MS-Excel document in Office 2007 is

a)

.xlsx

b)

.txt

c)

.ppt

d)

doc

e)

. docx

70.

The main function of E-Government

a)

the usual interaction among the Government, citizens, and the commercial institutions.

b)

the non-digital interaction among the Government, citizens, and the commercial institutions

c)

The computer interaction among the Government

d)

the interaction among citizens, and the commercial institutions.

e)

the digital interaction among the Government, citizens, and the commercial institutions.

71.

E-learning

a)

learning face-to-face

b)

Learning with electronic text

c)

comprises of distributed learning, network or web-based learning

d)

Learning on a computer

e)

Traditional learning

72.

SMART stands for

a)

Same-Monitoring Analysis and Recruitment Technology

b)

Safety-Monitoring Analysis and Recording Technology

c)

Self-Managing Analysis and Regarding Technology

d)

Self-Meaning Analysis and Recording Technology

e)

Self-Monitoring Analysis and Reporting Technology

73.

Multimedia Components are

a)

Sound, speech

b)

Text, IP address, file size, file name

c)

animation and video

d)

Graphics, Sound, speech

e)

text, sound, images, animation and video

74.

Platform-as-a-service (PaaS) refers to

a)

Internet services that supply software applications

b)

Databases needed for development

c)

cloud computing services that supply an on-demand environment for developing, testing, delivering and managing software applications.

d)

other datacenter infrastructure

e)

software applications over the Internet

75.

The hexadecimal number system consists of the symbols

a)

0..9,A..F

b)

0..7

c)

0..5, A..F

d)

0..1

e)

0..9

76.

What is blog?

a)

Intranet

b)

A personal or corporate Google search

c)

Data storage

d)

A personal or corporate website in the form of an online journal

e)

Online music

77.

HTML stands for

a)

Hyper Text Managing Links

b)

Hyper Text Markup Language

c)

Hyper Text Manipulating Links

d)

Hyper Text Manipulation Language

e)

Hyper Text Management Language

78.

DNS in internet technology stands for

a)

Digited Name System

b)

Dynamic Name System

c)

Domain Name System

d)

Distributed Name System

e)

Delivered Name system

79.

The binary number system consists of the following symbols :

a)

0..5

b)

0 ..9

c)

0..7

d)

0..1

e)

0..9; a..f

80.

The octal number system consists of the following symbols :

a)

0..9

b)

0 .. 1

c)

0..5

d)

0..9; a..f

e)

0..7

ict aisan

Total questions: 80

Worksheet time: 43mins

Similar Resources on Wayground