wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ict1

Total questions: 160

Worksheet time: 13hrs 20mins

Name
Class
Date
1.

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

a)

The functional relationship (Network Architectures)

b)

fault-tolerant features

           

c)

            Media Access Control (MAC) address

d)

          Data Link Control (DLC) address

e)

 Local and wide area networks

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)

                          Telephones and PDAs

           

c)

    

            HUB and client

  

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)

            A local area network (LAN)

         

c)

            Security area Network

           

d)

            Mobile handheld devices

      

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.

A network that interconnects users with computer resources in a geographic area or region larger than that covered by a local area network (LAN) but smaller than the area covered by wide area network (WAN) is called

a)

Metropolitan Area Network (MAN)

b)

Wide Area Network (WAN)

c)

A local area network (LAN)

d)

            Media Access Control (MAC) address

9.

Network topology`s category is

a)

              Client-server networking

b)

            Tree or Hierarchical topology

    

c)

            Peer-to-peer (workgroup)

d)

           

            Ethernet

        

e)

    Area Network (PAN)

10.

The basis of Active-Networking category is

a)

               Scale

         

b)

           

            Functional Relationship (Architecture)

       

c)

         

            Network topology

        

d)

            

            Home PNA

   

e)

            Client-server networking

11.

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

12.

Which virus runs on computers memory

           

a)

  Multipartite virus

        

b)

 

            Resident virus

c)

 

            Direct Action Virus

           

d)

            Boots

        

e)

            Worms

13.

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

14.

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

15.

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

16.

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

17.

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

18.

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

19.

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

20.

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

21.

Which command is used to check logical expression in MS Excel

a)

Sum

b)

If statement

c)

Max

d)

Min

e)

Avr

22.

Microsoft Excel consists of

a)

Rows

b)

Worksheets

c)

   Columns

d)

Toolbars

e)

  Tabs

23.

This function is used to add numbers

            

a)

the MAX

b)

  the SUM

c)

the AVR

d)

the MIN

e)

the SIN

24.

In the MS Excel, a formula begins with sign.

             

a)

              “/”

b)

“=”

          

c)

            “@”

     

d)

            “*”

           

e)

            “&”

25.

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

26.

MS Excel. The MIN function is

         

a)

automatically finds a maximum value of numbers

b)

automatically finds a minimum 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

27.

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

28.

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

29.

How many pages does The ribbon contain in MS Excel

            

a)

5

b)

8

c)

10

d)

9

e)

3

30.

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

31.

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

32.

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

33.

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

34.

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)

35.

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)

36.

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)

37.

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)

38.

Each worksheet contains

    

a)

   Records

b)

columns and rows

c)

       Numbers

d)

  data types

e)

   Symbols

39.

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.

40.

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

41.

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

42.

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.

43.

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.

44.

The biggest and complex integral microcircuit of the computer

          

a)

Motherboard

b)

    CPU

c)

    Network Card

d)

     Sound card

e)

Video card

45.

Device used for transmitting information over telephone lines:

      

a)

  Microphone

b)

Modem

c)

      Scanner

d)

network card

e)

            Printer

46.

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

 

a)

    picture;

b)

digits;

c)

       file;

d)

    mathematical expressions.

e)

   extensions;

47.

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 files to the hard disk.

d)

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

e)

   copying the contents of RAM to the hard disk;

48.

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

49.

Translate the number 32 from decimal to binary.

            

a)

010010

b)

   100000

c)

   100001

d)

     111111

e)

    100001

50.

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

51.

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

52.

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.

53.

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

54.

Utilities are

a)

  application programs.

b)

system programs for service purposes.

c)

collection of tools.

d)

resident programs.

e)

     used for creating application programs.

55.

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.

56.

Anti-virus programs are:

a)

application programs.

b)

system programs.

c)

tools.

d)

programming systems

e)

Utilities

57.

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

58.

The software of the PC includes:

            

a)

system, problem and application programs.

b)

system, applied, instrumental software.

c)

system and tool software.

d)

none

e)

applied, problematic and instrumental software.

59.

Windows registry is an example of the following database:

    

a)

           Relational

            l

b)

          

            Hierarchical

c)

object-oriented

d)

Network

e)

  Related

60.

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 

61.

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

a)

MSDOS.SYS

b)

      CONFIG.SYS

c)

       AUTOEXEC.BAT

d)

  IO.SYS

e)

NORTON COMMANDER

62.

Define the operating system

         

a)

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

b)

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

c)

          This is a system program for controlling external devices.

d)

This is a tool for developing user programs.

e)

            These are devices for controlling external devices.

63.

Define drivers

 

a)

      These are application programs that serve individual peripheral devices.

b)

  These are system programs that serve individual peripheral devices.

c)

   These are the tools for developing operating systems.

d)

These are devices for controlling external devices.

64.

Catalog (or directory)…

         

a)

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

b)

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

c)

      This is a system program for controlling external devices.

d)

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

e)

  This is the hard drive where user files are stored.

65.

Specify a symbol that combines the name and file type

           

a)

   Colon

b)

Dot

c)

Star

d)

Question mark

e)

  Comma

66.

The file system on the disk has

       

a)

  relational structure.

b)

tree structure.

c)

linear structure.

d)

dynamic structure.

e)

network structure

67.

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

          

          

a)

     Heads

b)

Sectors

c)

Foots

d)

Vectors

e)

Clusters

68.

The file extension of MS-Power Point document is

a)

.txt

b)

  .PPT

c)

doc

d)

   .xlsx

e)

            . docx

69.

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

          

a)

    .txt

b)

.xlsx

c)

doc

d)

   .ppt

e)

  . docx

70.

2 Gigabyte is equal to

a)

  1024 Kilobytes

b)

  2048 Megabytes

c)

2048 Bytes

d)

    2000 bits

e)

       2048 Terabytes

71.

The main function of E-Government

       

a)

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

b)

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

c)

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

d)

    The computer interaction among the Government

e)

          the interaction among citizens, and the commercial institutions.

72.

E-learning

a)

     learning face-to-face

b)

comprises of distributed learning, network or web-based learning

c)

      Learning with electronic text

d)

      Learning on a computer

e)

Traditional learning

73.

SMART stands for

 

a)

     Self-Managing Analysis and Regarding Technology

b)

      Self-Monitoring Analysis and Reporting Technology

c)

     Self-Meaning Analysis and Recording Technology

d)

         Safety-Monitoring Analysis and Recording Technology

e)

         Same-Monitoring Analysis and Recruitment Technology

74.

Multimedia Components are

   

a)

Text, IP address, file size, file name

b)

      text, sound, images, animation and video

c)

            Sound, speech

d)

   animation and video

e)

  Graphics, Sound, speech

75.

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

a)

Internet services that supply software applications

b)

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

c)

Databases needed for development

d)

            software applications over the Internet

e)

      other datacenter infrastructure

76.

The hexadecimal number system consists of the symbols

         

a)

0..7

b)

    0..9,A..F

c)

   0..1

d)

0..9

e)

    0..5, A..F

77.

What is blog?

a)

         Intranet

b)

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

c)

Data storage

d)

A personal or corporate Google search

e)

  Online music

78.

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

79.

DNS in internet technology stands for

            

a)

   Dynamic Name System

b)

Domain Name System

c)

  Distributed Name System

d)

      Digited Name System

e)

     Delivered Name system

80.

The binary number system consists of the following symbols :

     

a)

0 ..9

b)

0..1

c)

    0..7

d)

0..5

e)

  0..9; a..f

81.

The octal number system consists of the following symbols :

      

 

a)

0 .. 1

b)

0..7

c)

0..9

d)

  0..5

e)

    0..9; a..f

82.

Which one of the following is an example of Operating System?

           

a)

Microsoft Word

b)

Microsoft Windows

c)

Microsoft Excel

d)

Microsoft Access

e)

Microsoft Power Point

83.

Which one of the following is not a network device?

      

a)

Hub

b)

  CPU

c)

    Router

d)

    Switch

e)

  bridge

84.

HTML is basically used to design:

           

a)

  Web-site

b)

Web-page

         

c)

            Graphics

d)

            Tables and Frames

e)

          Calculations

85.

Which is the largest unit of storage among the following?

       

a)

   Gigabyte

b)

       Terabyte

           

c)

     

            Megabyte

d)

    Kilobyte

e)

   Byte

86.

RAM means:

          

a)

Rapid Access Memory

b)

   Random Access Memory

c)

Rigid Access Memory

d)

Range Access Memory

e)

   Revolving Access Memory

87.

WWW stands for

          

a)

word wide web

b)

world wide web

c)

weird wide web

d)

who what and where

e)

   Wind wild web

88.

Which of the following is the appropriate definition of a computer?

a)

Computer is a machine that can process information.

b)

    Computer is an electronic device that can store, retrieve and process both qualitative and quantitative data quickly and accurately

c)

Computer is an electronic device that can store, retrieve and quickly process only quantitative data.

d)

  Computer is a machine that can store, retrieve and process quickly and accurately only qualitative information.

e)

    Computer is a car that can store, retrieve and process quickly and accurately only qualitative information.

89.

ICT stands for :

a)

Inter connected Terminals

b)

  Information and Communication Technology

c)

Intera Common Terminology

d)

     International Communication Technology

e)

  Internet and Communication Technology

90.

A private cloud can be

            

a)

logically located on the company’s on-site datacenter.

b)

physically located on the company’s on-site datacenter.

c)

    located on the server of the user.

d)

     located on my own computer.

e)

located on every

91.

Types of cloud deployments:

         

a)

General, common, public

b)

    public, private, hybrid

c)

Public, common

d)

Hybrid, common, public

e)

General, middle, security

92.

One byte equals to

            

a)

     16 bits

b)

8 bits

c)

  256 bits

d)

1024 bits

e)

1 bit

93.

Most cloud computing services fall into three broad categories

     

a)

infrastructure as a cloud, platform as a network  and software as a service

b)

           infrastructure as a service, platform as a service  and software as a service

c)

infrastructure as a provider, platform as a provider  and software as a service

d)

infrastructure as a speed, platform as a data  and software as a hardware Productivity

e)

     infrastructure as a service, platform as a data  and software as a Productivity

94.

Benefits of cloud computing do not include

    

 

a)

cost

b)

User feeling

c)

Global scale

d)

   Speed

e)

Productivity

95.

Companies offering these computing services are called

a)

Computer engineering

b)

Cloud providers

c)

            Cloud workers

d)

            Cloud makers

e)

  

            Cloud administrators

96.

The main functions of the operating system include:

a)

Dialogue with the user, creating a computer program.

b)

Dialog with the user, control the resources of the computer, start the program.

c)

Print information by the printer.

d)

Management of computer resources, execution of computer programs.

e)

  Copying information from the scanner to the computer, starting the program

97.

Types of addressing in Excel spreadsheet:

         

a)

Absolute, mixed, simple.

b)

Absolute, relative, mixed.

c)

Relative, absolute, simple

d)

Relative, mixed, simple

e)

Absolute, simple, mixed.

98.

Access. The data representation model is

      

a)

system of making managerial decisions involving computer.

b)

logical structure stored in the database

c)

diagram

d)

a set of programs for data exchange;

e)

software system for storing, adding, deleting and editing data in a database

99.

Access. The data representation model is

          

a)

system of making managerial decisions involving computer.

b)

logical structure stored in the database

c)

diagram

d)

a set of programs for data exchange;

e)

software system for storing, adding, deleting and editing data in a database

100.

Specify a package that allows you to work with databases ...

         

a)

  MathCAD.

b)

  MS Access.

c)

Math Lab.

d)

      MS word.

e)

         Notepad

101.

Which one is used to connect tables in MS Access?

      

a)

Forms

b)

  Data scheme

c)

  Table

d)

Macros

e)

Record

102.

MS Access. Specify the field type if the field name is "date of birth"

            

a)

  Text

b)

   Date Time

c)

Number

d)

Logical

e)

Currency

103.

Query in MS Access:

a)

An object in which the developer places controls that accept user actions or serve to enter, display, and modify data in fields

b)

   Formalized requirements for sampling data from tables or performing certain actions with data

c)

  Displays all the fields of a single entry, it is convenient for entering and editing data.

d)

       To enter and edit data.

e)

  Represents the macro sequence of the built-in Access language

104.

The first computers appeared in ...

           

a)

1948

b)

1946

c)

  1936

d)

1949

           

e)

            1951

105.

List the main objects of the Access database:

   

a)

In the Access database, the main objects are tables, queries, macros, and modules

b)

     In the Access database, the main objects are tables, queries, forms, reports, macros, and modules

c)

  In the Access database, the main objects are tables, queries, macros, and forms.

d)

  In the Access database, the main objects are tables, reports, macros, and modules

e)

In the Access database, the main objects are tables, queries, forms, reports

106.

The average of the contents of the cells from A1 to A10 is calculated by the formula in Excel:

 

a)

= SIGNAL (A1, A10).

b)

   = AVERAGE (A1: A10).

c)

  = SUM (A1: A10).

d)

= CP3HA4 (A1; A10) ..

e)

= DA1; A10)

107.

1 megabyte is equal to

          

a)

8 bytes

b)

1024 KB

c)

     8 bits

d)

  2

e)

1000 KB

108.

MS Access. Specify the type of the field if the name of the field "number of medicines"

       

a)

   of the sums A1: A10

b)

= sums (A1: A10) numerical

c)

= sumA1: A10

d)

     sums (A1: A10)

e)

sum (A1: A10)

109.

MS Excel. Specify the correct summation formula entry ...

           

a)

of the sums A1: A10

b)

      = sums (A1: A10)

c)

        = sumA1: A10

d)

sums (A1: A10)

e)

sum (A1: A10)

110.

Specify which of the following is the "brain" of the computer

         

a)

       CD-R.

b)

      Processor.

c)

  Monitor.

d)

       Keyboard.

e)

     RAM.

111.

The hyperlink allows:

      

a)

   save documents.

b)

  move to the place of the bookmark.

c)

view pictures.

d)

     archive documents.

e)

create new documents.

112.

MSAccess. Macros is ....

a)

    An object that is a structured description of one action

b)

 An object that represents a structured description of several actions that Access Basic must perform

c)

          An object that is a structured description of one action that Access Basic must perform

d)

 An object that is a structured description of several actions that [Human computer interaction] must perform

e)

 An object that is a structured description of one or more actions that Access Basic must perform, and which allows you to break the process into smaller actions

113.

What does allow web developers to alter the layout and appearance of their web pages

          

a)

Domain Name System (DNS)

b)

  Cascading Style Sheet, CSS

c)

Internet Engineering Task Force (IETF)

d)

  HyperText Transfer Protocol (HTTP)

e)

The Internet Archive

114.

Why are web pages called “hypertext documents”

   

a)

            Because it accepts information through text

b)

        Because when you click a word or a picture which is hyper linked you can go to another location

c)

      They contain only text

d)

  Because it is made for readable manner

e)

Documents are used for storing text

115.

FTP is commonly used to

           

a)

Make connection

b)

       Transfer Web page files from their creator to the computer

c)

  Transmit the information from one place to the other

d)

  Download programs

e)

        Install applications

116.

A computer which is capable of receiving the information from the server in the Internet is called a

 

a)

Server

b)

Client

c)

     Domain

d)

Service

e)

Locator

117.

What is a browser

a)

Set of rules and guidelines for communicating data

b)

  A computer software which can be used to view documents on the Internet

c)

     Foundation of data communication

d)

Transmission of information from one place to the other

e)

Largest service acquired amongst the services provided by the Interne

118.

This type of virus can steal information from user`s computers and upload to web sites

    

a)

Boots

b)

    Worms

c)

  Resident virus

d)

    Polymorphic virus

e)

    Multipartite virus

119.

What is a computer virus

a)

  An application

b)

A harmful computer program developed by a person that disrupts operations of a computer in various ways

c)

  What is a computer virus

d)

            MS document

         

e)

            Browser

120.

What is a router

a)

   A device which makes the use of computer technology cost effective

b)

         A networking device that forwards packets between networks using information in protocol headers

c)

    Device attached to the network to obtain human computer interaction

d)

  A device used to extend a network so that additional workstations can be attached

e)

Devices used to connect end devices to the network

121.

What do connect multiple network segments at the data link layer (layer 2) of the OSI model

  

a)

nterfaces

b)

Bridges

c)

   Security cameras

d)

      Network printers

e)

            Modems

122.

An Internet Protocol (IP) address is a

                     

a)

Set of devices which form the interface between the human network and the underlying communication network

b)

            Numerical identification (logical address) that is assigned to devices participating in a computer network

c)

Set of devices which obtain protection functions

d)

  Numerical identification (logical address) that is assigned to provide network

e)

Set of devices which perform typical tasks for appropriate function of hard disk

123.

What is the “HUB”

a)

   Is a device for providing programs` access

b)

   A device used to extend a network so that additional workstations can be attached

c)

   A device used to run applications

d)

      Name of the Browser

e)

Type of operating system

124.

What does have several processors rather than just one and may be dedicated to a specific support function

            

a)

Router

b)

  Server

c)

Broadcast

d)

   Network

e)

    Intermediary device

125.

The device needed to connect computers to the local network:

a)

TV tuner

b)

    Network Card

c)

video card

d)

 tire

e)

        plume

126.

The main element of MS Access is

        

a)

  Forms

b)

    Table

c)

        Field

d)

   Record

e)

   Macros

127.

The protocol, domain, directories, and files are all separated by

             

a)

  Periods (.)

b)

Forward slashes( / )

c)

Commas (,)

d)

   Low lines (_)

e)

Asterisks (*)

128.

What are the systems of interconnected computers that share a central storage system and various peripheral devices

a)

Networking

b)

  Computer systems

c)

   ICloud system

d)

    Hardware

e)

    Firmware

129.

Computer programs installed in the computer are called

  

a)

Engineering

b)

Software

c)

    Hardware

d)

       Firmware

e)

    Hard disc

130.

The first technical characteristics of a CPU is a

           

       

a)

Diligence    

b)

  Speed

c)

The accuracy

d)

  Reliability

e)

   No feeling

131.

Most common type of computers in the society are

  

a)

   Minicomputers

b)

   Personal computers

c)

   Super computers

d)

Mainframes

e)

  Double computers

132.

Which type of computer is capable of handling and processing very large amounts of data quickly

a)

Microcomputers

b)

  Mainframes

c)

  Minicomputers

d)

  Super computers

e)

Double computers

133.

Which computer is used for performing complex scientific and numerical computations such as weather forecasting, fluid dynamics, and etc.

           

a)

Microcomputers

b)

   Mainframes

c)

    Super computers

d)

    Double computers

e)

Minicomputers

134.

Which one defines the physical equipment that is involved in the computer functioning

    

a)

  Software

b)

   Hardware

c)

Firmware

d)

   Nextware

e)

Hard disc

135.

The computer hardware is typically divided into four main parts which are

a)

    Printers, Xerox, input and output devices

b)

Processing Devices, Memory Devices, Input/, Output Devices

c)

  Control Unit (CU) and the Arithmetic and Logic Unit (ALU)

d)

Printer, plotter, modem, headphones

e)

Local, broadband, personal, regional

136.

A series of instructions that tells a computer how to perform the tasks is called

         

a)

device

b)

 A program

c)

      Number

d)

      Command

e)

    Text

137.

Any hardware component that allows you to enter data, programs, commands, and user responses into a computer is known as

           

a)

      An output Device

b)

An Input Device

c)

BIOS

d)

   Processing

e)

    Power supply

138.

Which device is not classified as an input device

          

a)

  Keyboard

b)

Printer

c)

  Trackball

d)

    Mouse

e)

            Joystick

139.

How do we call the digital representations of non-text information such as drawings, charts, pictures and photographs

        

a)

     Text

b)

Graphics

c)

  sound

d)

number

e)

video

140.

Music, speech, or any other sound is called

          

           

a)

Video

b)

  Audio

c)

Text

d)

   Graphics

e)

      0..9

141.

The number system whose base is 8 is known as

           

a)

     the Hexadecimal number system

b)

the octal number system

c)

  the binary number system

d)

The non octal number system

e)

            the decimal number system

142.

What contains the CPU, BIOS, memory, mass storage interfaces, serial/parallel ports, expansion slots, and all the controllers required to control standard peripheral devices

       

a)

RAM

b)

the motherboard

c)

Control unit

d)

ALU

e)

storage device

143.

Type of Operating Systems

            

a)

  mini-user mini-task

b)

single-user single-task

c)

mini-user single-task

d)

micro-user single-task

e)

multi-user micro-task

144.

Single-user single-task OS allows

a)

many applications running at the same time

b)

  only one person running only one application at a time

c)

    Each user logged on to the system, their workspace and so on

d)

     Keep logs of how much processing time and resources they use

e)

     Work out the most efficient use of computer processing cycles

145.

Which option below researches the design and use of computer technology, focused on the interfaces between users and         computers

a)

System software

b)

Human–computer interaction

c)

Computer Hardware

d)

   Task Bar

e)

  Shortcut Icons

146.

What does Human–computer interaction study in communication

           

a)

Computer and software

b)

A human and a machine

c)

       A computer and Computer systems

d)

  User and users

e)

   A computer and applications

147.

In HCI on the human side, there are not considered concepts such as

           

a)

   communication theory

b)

computer graphics

c)

linguistics

d)

 social sciences

e)

            cognitive psychology

148.

The main problem of human-computer interaction is how to improve

     

a)

the reliability of CPU

b)

the usability of computer interfaces

c)

the speed of CPU

d)

   The accuracy of computer interfaces

e)

  The diligence of computer interfaces

149.

Which of the followings is used by the user to interact directly with the computer system by typing commands (instructions) in the command line

        

a)

  A Text interface with menus

b)

   A Command Line interface

c)

    A Graphic userInterface

d)

A Voice user interfaces

e)

  A Desktop Interface

150.

What kind of interface is considered as a visual way of interacting with the computer using the components like windows, icons, labels and etc.

       

a)

A Text interface with menus

b)

A Graphic interface

c)

   A Command Line Interface

d)

  A Voice user interfaces

e)

     A Desktop Interface

151.

What type of chart is useful for comparing values over categories?

         

a)

Column Chart

b)

 Line Chart

c)

   Pie Chart

d)

 Dot Graph

e)

Big Chart

152.

Which function in Excel tells how many numeric entries are there?

        

a)

CHKNUM

b)

        NUM

c)

SUM

d)

 COUNT

e)

ADDRESS

153.

Choose the suitable variant for Public Cloud

             

a)

Drives efficiency, standardization and best practices while retaining greater customization and control.

b)

        Access limited to client and its partner network.

c)

   Client owned and managed.

d)

 Service provider owned and managed.

e)

  Service provider owned

154.

Choose the Advantage of Cloud Computing

           

a)

Since you use the Internet to connect to both your applications and documents, if you do not have an Internet connection you cannot access anything, even your own documents.

b)

Web-based applications require a lot of bandwidth to download, as do large documents.

c)

Cloud computing is impossible if you cannot connect to the Internet

d)

  Changes to computers, applications and documents follow you through the cloud.

e)

   Cloud computing needs connecting to the Internet

155.

Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?

      

a)

Query

b)

Relational Schema

c)

DDL(Data Definition Langauge)

d)

     DML(Data Manipulation Langauge)

e)

Report

156.

A relational database consists of a collection of

          

a)

Tables

b)

    Records

c)

         Keys 

d)

 Fields

e)

    Tabs

157.

How will you graphically represent expenditure in different departments?

        

a)

Line Chart

b)

Column Chart

c)

Dot Chart

d)

            Big Chart

e)

Pie Chart

           

158.

Choose right variant. Find example of ergonomics.

          

a)

use of red for warning, green for okay, awareness of color-blindness

b)

 all answers are correct

c)

physical position, environmental conditions temperature, humidity

d)

seating arrangements adaptable to cope with all sizes of user

e)

use of awareness of color-blindness

159.

What is connect with Interface:

1)  A point where two objects meet;

2)  A point where human can tell the computer what to do;

3)  A point where the computer displays the requested information

              

a)

1,2

b)

     1,3

c)

   1,2,3

d)

2,3

e)

   1

160.

What is a sign of copyright protection?

           

           

a)

             $

b)

 #

c)

^

d)

   &

e)

 ©