wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

икт42-90

Total questions: 83

Worksheet time: 46mins

Name
Class
Date
1.

Define the core components of a data centre

a)

Storage infrastructure

b)

Computing resources

c)

Network infrastructure

d)

System infrastructure

e)

Database infrastructure

2.

Cloud computing is the delivery of computing services such as servers, storage, databases, … , …,  … and more—over the Internet

a)

networking

b)

analytics

c)

software

d)

hardware

e)

firmware

3.

What do you do with the cloud?

a)

Create new apps and services

b)

Host websites and blogs

c)

Store, back up and recover data

d)

Conversion operations

e)

Delete, back and covering data

4.

Cloud should solve a number of basic tasks

a)

Conversion operations

b)

Delete, back and covering data

c)

Stream audio and video

d)

Analyse data for patterns and make predictions

e)

Deliver software on demand

5.

Most cloud computing services fall into … broad categories:

a)

infrastructure as a service (IaaS)

b)

platform as a service (PaaS)

c)

software as a service (Saas)

d)

Internet as a service (IaaS)

e)

Programming as a service (PaaS)

6.

Types of cloud deployments:

a)

public

b)

hybrid

c)

private

d)

in hybrid

e)

miss hybrid

7.

The Basic Elements of Multimedia

a)

Text

b)

Audio

c)

Graphics, Animation, Video

d)

e-mail

e)

networks

8.

Hypertext

a)

is a text which contains links to other texts

b)

was invented by Ted Nelson around 1965

c)

means a database in which information (text) has been organized nonlinearly

d)

is a text which without links to other texts

e)

was invented by Bill Gates around 1965

9.

Important questions in designing the hypermedia are:

a)

Converting linear text to hypertext

 

b)

Dividing the text into nodes

c)

Text format conversions

d)

Converting hypertext text to linear

e)

division format Text

10.

SMART as a diagnostic method is  originally developed by … and introduced with the … specification

a)

Apple company

b)

ATA-3

c)

Compaq

d)

Intel

e)

IBM

11.

… is the conduct of business processes on the internet.

a)

e-gov (electronic government)

b)

E-business (electronic business)

c)

General business

d)

SMART

e)

E-learning

12.

… an approach to conducting an electronic business on the internet

a)

E-learning model

b)

E-Business Model

c)

E-Gov model

d)

E-conference model

e)

E-Business learning model

13.

The Individual Funding Request (IFR) class includes:

a)

database management systems (DBMS)

b)

Programming Language system

c)

System software

d)

Networking tools

e)

Case-technology

14.

Text editors designed to handle text and perform mainly the following functions:

a)

insert, delete, replace characters, lines, text fragments

b)

Defragmenting discs

c)

record the text file

d)

Backing up the content of a hard disc

e)

Create a databases

15.

What is a computer virus?

a)

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

b)

A program just simply destroys the files system of computer making it completely unusable

c)

A useful computer program developed by a person that continues operations of a computer in various ways

d)

A program just simply corrects the files system of computer making it completely usable

e)

a system software that treats important files such as documents beyond recovery

16.

Boot Sector Virus

a)

This type of virus affects the boot sector of a floppy or hard disk.

b)

Examples of this viruses include: Polyboot.B, AntiEXE.

c)

It increases network traffic, CPU utilization of computer thereby making systems slow

d)

can do nasty actions such as creating unnecessary files inside system folders, steal information from user‟s computers and upload to web sites and etc.

e)

do not require user actions to spread, they move from system to system over networks on their own

17.

Worms

a)

do not require user actions to spread, they move from system to system over networks on their own

b)

It increases network traffic, CPU utilization of computer thereby making systems slow

c)

infect documents created by Microsoft Office programs (Word, Excel, PowerPoint and Access).

d)

This type of virus affects the boot sector of a floppy or hard disk.

e)

Examples of this viruses include: Polyboot.B, AntiEXE.

18.

Macro viruses

a)

It increases network traffic, CPU utilization of computer thereby making systems slow

b)

infect documents created by Microsoft Office programs (Word, Excel, PowerPoint and Access).

c)

This type of virus affects the boot sector of a floppy or hard disk.

d)

infect to the files that are created using certain applications or programs that contain macros.

e)

Examples of this viruses include: Polyboot.B, AntiEXE.

19.

Resident virus

a)

always runs on computers memory and runs automatically or trigged by an action performed by user to infect or replicate itself to new locations or files

b)

infect to the files that are created using certain applications or programs that contain macros.

c)

infect documents created by Microsoft Office programs (Word, Excel, PowerPoint and Access).

d)

It increases network traffic, CPU utilization of computer thereby making systems slow

e)

This type of virus affects the boot sector of a floppy or hard disk.

20.

Examples of macro viruses:

a)

Relax, Melissa.

b)

Bablas, O97M

c)

Trile.C, Sobig.D, Mapson

d)

Polyboot.B, AntiEXE

e)

Confiker, PSWBugbear.B,

21.

Examples of worm viruses:

a)

Trile.C, Sobig.D, Mapson

b)

Confiker, PSWBugbear.B,

c)

Relax, Melissa.

d)

Bablas, O97M

e)

Polyboot.B, AntiEXE

22.

Examples of boot viruses:

a)

AntiEXE

b)

Polyboot.B

c)

Confiker, PSWBugbear.B,

d)

Relax, Melissa.

e)

Bablas, O97M

23.

Most of the computer viruses are designed to

a)

Not self-replicate

b)

Improve systems` work

c)

Update installed programs

d)

Exploit some kind of an error (security hole)

e)

Help uploading applications

24.

Which virus runs on computers memory

a)

Multipartite virus

b)

Worms

c)

Resident virus

d)

Direct Action Virus

e)

Boots

25.

Power faults can cause

a)

Speed increase

b)

Data problems

c)

Diligence

d)

Versatility

e)

Accuracy

26.

Lower voltages at electrical outlets is a

a)

Loss

b)

Brownout

c)

Attack

d)

Infection

e)

Accessing floppy

27.

What can cause Voltage spikes as the circuits balance

a)

Exploit some kind of an error

b)

Sudden losses (ex; a driver hits a power pole)

c)

Attack systems

d)

Slowing down

e)

Formatting the data

28.

Which of the followings is a solution for an incompatibility

a)

Shut down 

b)

Make a really good backup before installing anything

c)

Restart

d)

Format all files

e)

Upgrade all programs

29.

A way to find out that a computer virus or malware program is present in your computer

a)

Your computer works more appropriate

b)

Your computer keeps shutting down itself

c)

Your computer works faster

d)

Your computer works more accurate

e)

Your computer suddenly slows down after installing a program downloaded from internet

30.

Today most of the viruses are being infected

a)

Using removable media like thumb drives and through networks and the Internet.

b)

Only by internet

c)

Opening links

d)

Clicking on infected files

e)

Using computer without anti-virus software

31.

Nonresident viruses are activated

a)

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

b)

Through the storage devices

c)

Through email account

d)

By executable code found in specific system areas on a disk

e)

Through the replication of malicious code

32.

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

a)

Anti-virus programs

b)

Adobe Flash

c)

DevOps

d)

Cleaners

e)

MACROS

33.

A person can exchange his/her messages digitally through

a)

E-mail

b)

Dead links

c)

Universal document identifier (UDI)

d)

Locator

e)

HyperCard

34.

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)

Restore , zip

e)

Archive,transmit

35.

The first e-mail was sent by

a)

HåkonWium Lie in 1994

b)

Ray Tomlinson in 1971

c)

HåkonWium Lie in 1991

d)

Ray Tomlinson in 1974

e)

HåkonWium Lie in 1997

36.

To send and receive e-mail messages, you can use an e-mail program as

a)

ProgramData

b)

Microsoft Outlook or Mozilla Thunderbird

c)

Adode Flash Player

d)

TeamViewer

e)

Microsoft Access

37.

The CC or Carbon Copy field

a)

Receives e-mail messages

b)

Allows you to send a copy of the message to another e-mail address

c)

Transmits information from one place to the other

d)

Translates codes

e)

Change the appearance of website

38.

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

39.

The username and e-mail addresses as a whole cannot begin or end with

a)

It is a server of the recipient`s email service

service

 

b)

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

c)

It's a new message

d)

It`s an online e-mail service

e)

It is the location you type your main message

0

40.

Each domain name represents a unique Web address which is called

a)

An e-mail client

b)

Internet protocol (IP) address

c)

Signature

d)

The SMTP Server

e)

Carbon Copy

41.

Basically email contains 2 parts

a)

the sender and recipient

b)

the senderdomain name

c)

the bodyand recipient

d)

username and a domain name

e)

the headerand the body

42.

… 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

43.

Which one of the followings   is used to perform mathematical calculations

a)

Microsoft Publisher

b)

Microsoft Word

c)

Microsoft Excel

d)

Microsoft Access

e)

Microsoft Power point

44.

What concept  is used to create a new file, open an existing file, save a file, and perform many other tasks.

a)

The start button

b)

The Microsoft Office Button

c)

ESC button

d)

ALT button

e)

SHIFT button

45.

What does give you access to commands that  you frequently use

a)

The Formula bar

b)

The Quick Access toolbar

c)

Title bar

d)

The Ribbon

e)

The Status bar

46.

On what bar Microsoft Excel displays the name of the workbook

a)

The Formula bar

b)

Title bar

c)

The Quick Access toolbar

d)

The Status bar

e)

Title ribbon

47.

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 Title bar

e)

The Ribbon

48.

Which command  is used to check logical expression in MS Excel

a)

Sum

b)

Max

c)

If statement

d)

Avr

e)

Min

49.

The general form of the IF statement looks as

a)

IF (value if true;value if false)

b)

IF value if true; value if false; logical expression;

c)

IF (value if true; value if false; logical expression;)

d)

IF (logical expression; value if true; value if false)

e)

IF (value if true; logical expression; value if false)

50.

It provides shortcuts to menu commands.

a)

The Formula bar

b)

The Ribbon

c)

The Quick Access toolbar

d)

Title bar

e)

Toolbar

51.

Microsoft Excel consists of

a)

Rows

b)

Worksheets

c)

Columns

d)

Tabs

e)

Toolbars

52.

How do you move a pointer on the spreadsheet in Excel?

a)

By clicking the right button of a mouse

b)

By clicking the down button of a mouse

c)

By clicking the up button of a mouse

d)

By clicking the toolbar

e)

By clicking the left button of a mouse and using arrow keys on the keyboard

53.

A mathematical formula is entered with

a)

an addition sign

b)

a back slash sign

c)

a slash sign

d)

a subtraction sign

e)

an equal sign

54.

The AutoSum icon on the Standard toolbar

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 counts an amount of numbers

e)

automatically adds a column of numbers

55.

This function is used to add numbers

a)

the MAX

b)

the SIN

c)

the MIN

d)

the AVR

e)

the SUM

56.

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

a)

“/”

b)

“@”

c)

“*”

d)

“&”

e)

 “=”

57.

MS Excel. The MAX function is

a)

automatically finds a minimum value of numbers

b)

automatically counts an amount of numbers

c)

automatically adds a column of numbers

d)

automatically finds an average value of numbers

e)

automatically finds a maximum value of numbers

58.

MS Excel. The AVR 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 counts an amount of numbers

e)

automatically adds a column of numbers

59.

MS Excel. The Count function is

a)

automatically finds a maximum value of numbers

b)

automatically adds a column of numbers

c)

automatically finds an average value of numbers

d)

automatically finds a minimum value of numbers

e)

automatically counts of the number of items in a list

60.

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)

finds an average value of numbers

e)

appears a new row

61.

MS Excel. The F5 function key is

a)

The “Home” key

b)

the "Go To" key

c)

The “End” key

d)

The “Delete” key

e)

The “ESC” key

62.

The right arrow key is used

a)

to move left one cell at a time

b)

to move up and down one cell at a time

c)

to move down one cell at a time

d)

to move up one cell at a time

e)

to move right one cell at a time

63.

The left arrow key is used

a)

 to move right one cell at a time

b)

to move left one cell at a time

c)

to move up one cell at a time

d)

to move down one cell at a time

e)

to move up and down one cell at a tim

64.

The up arrow key is used

a)

to move right one cell at a time

b)

to move up one cell at a time

c)

to move left one cell at a time

d)

to move down one cell at a time

e)

to move up and down one cell at a time

65.

The down arrow key is used

a)

to move right one cell at a time

b)

to move down one cell at a time

c)

to move up one cell at a time

d)

to move up and down one cell at a time

e)

to move left one cell at a time

66.

The Menu bar is located

a)

directly near the Title bar

b)

directly below the Title bar

c)

directly before the Title bar

d)

directly over the Title bar

e)

directly behind the Title bar

67.

This bar is located at the very top of the screen

a)

The Menu bar

b)

the Title bar

c)

The status bar

d)

The cell address

e)

The formula bar

68.

How many pages  does The ribbon contain in MS Excel

a)

5

b)

8

c)

9

d)

10

e)

3

69.

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 Quick Access tool bar

e)

On the Formula bar

70.

How do you rename the spreadsheet in MS Excel

a)

By using the start bar

b)

By clicking on file

c)

By clicking on the name twice

d)

By clicking on Formula bar

e)

By using Quick Access tool bar

71.

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(C1:C10)=10;”Excellent”;”Bad”)

d)

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

e)

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

72.

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

a)

A formula bar

b)

A cell address

c)

A worksheet name

d)

Acolumncoordinate

e)

A title bar

73.

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 coordinate of the cell

e)

The address of the worksheet

74.

Which expression give the “ИСТИНА” value if A3=20 and A4=40?

a)

=ИЛИ(A3>20;A4<50)

b)

=И(A3>19;A4<50)

c)

=И(A3=19;A4=50)

d)

=И(A5>19;A6<50)

e)

=И(A3<19;A4<50)

75.

Which expression gives the “ЛОЖЬ” value if A3=20 and A4=40?

a)

=ИЛИ(A3=20;A4=40)

b)

=И(A3>19;A4<50)

c)

=И(A3=20;A4=40)

d)

=ИЛИ(A3>50;A4<40)

e)

=НЕТ(A5>19;A6<50)

76.

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

a)

=AVR(R3:R17)

b)

=SUM(R3:R17)

c)

=MAX(R3:R17)

d)

=SIN(R3:R17)

e)

=AUTOSUM(R3:R17)

77.

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

a)

=AVR(R3:R17)

b)

=AVR(R18:R20)

c)

=AUTOSUM(R3:R17)

d)

=MAX(R3:R17)

e)

=SIN(R3:R17)

78.

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

a)

=AVR(R3:R17)

b)

=SIN(R3:R17)

c)

=MAX(R3:R17)

d)

=AUTOSUM(R3:R17)

e)

=MAX(R18:R20)

79.

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

a)

=AVR(R3:R17)

b)

=MIN(R3:R17)

c)

=SIN(R3:R17)

d)

=AUTOSUM(R3:R17)

e)

=MIN(R18:R20)

80.

Each worksheet contains

a)

Records

b)

data types

c)

Numbers

d)

Symbols

e)

columns and rows

81.

The trunk-modular principle of the architecture of modern personal computers implies such a logical organization of its hardware components, in which:

a)

each device communicates with others directly;

b)

each device communicates with others directly, and also through one central highway;

c)

devices communicate with each other in a certain fixed sequence (ring);

d)

the devices communicate with each other through the central processor, to which they are all connected.

e)

they all communicate with each other via the highway;

82.

Specify the devices that are part of the processor:

a)

random access memory, printer, video memory;

b)

cache memory, video memory;

c)

scanner, ROM;

d)

display processor, video adapter.

e)

arithmetic logic unit, control unit;

83.

Audio is …

a)

Music

b)

speech

c)

picture

d)

other sound

e)

sentence