Font size
Worksheetsикт42-90
Total questions: 83
Worksheet time: 46mins
Define the core components of a data centre
Storage infrastructure
Computing resources
Network infrastructure
System infrastructure
Database infrastructure
Cloud computing is the delivery of computing services such as servers, storage, databases, … , …, … and more—over the Internet
networking
analytics
software
hardware
firmware
What do you do with the cloud?
Create new apps and services
Host websites and blogs
Store, back up and recover data
Conversion operations
Delete, back and covering data
Cloud should solve a number of basic tasks
Conversion operations
Delete, back and covering data
Stream audio and video
Analyse data for patterns and make predictions
Deliver software on demand
Most cloud computing services fall into … broad categories:
infrastructure as a service (IaaS)
platform as a service (PaaS)
software as a service (Saas)
Internet as a service (IaaS)
Programming as a service (PaaS)
Types of cloud deployments:
public
hybrid
private
in hybrid
miss hybrid
The Basic Elements of Multimedia
Text
Audio
Graphics, Animation, Video
networks
Hypertext
is a text which contains links to other texts
was invented by Ted Nelson around 1965
means a database in which information (text) has been organized nonlinearly
is a text which without links to other texts
was invented by Bill Gates around 1965
Important questions in designing the hypermedia are:
Converting linear text to hypertext
Dividing the text into nodes
Text format conversions
Converting hypertext text to linear
division format Text
SMART as a diagnostic method is originally developed by … and introduced with the … specification
Apple company
ATA-3
Compaq
Intel
IBM
… is the conduct of business processes on the internet.
e-gov (electronic government)
E-business (electronic business)
General business
SMART
E-learning
… an approach to conducting an electronic business on the internet
E-learning model
E-Business Model
E-Gov model
E-conference model
E-Business learning model
The Individual Funding Request (IFR) class includes:
database management systems (DBMS)
Programming Language system
System software
Networking tools
Case-technology
Text editors designed to handle text and perform mainly the following functions:
insert, delete, replace characters, lines, text fragments
Defragmenting discs
record the text file
Backing up the content of a hard disc
Create a databases
What is a computer virus?
A harmful computer program developed by a person that disrupts operations of a computer in various ways
A program just simply destroys the files system of computer making it completely unusable
A useful computer program developed by a person that continues operations of a computer in various ways
A program just simply corrects the files system of computer making it completely usable
a system software that treats important files such as documents beyond recovery
Boot Sector Virus
This type of virus affects the boot sector of a floppy or hard disk.
Examples of this viruses include: Polyboot.B, AntiEXE.
It increases network traffic, CPU utilization of computer thereby making systems slow
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.
do not require user actions to spread, they move from system to system over networks on their own
Worms
do not require user actions to spread, they move from system to system over networks on their own
It increases network traffic, CPU utilization of computer thereby making systems slow
infect documents created by Microsoft Office programs (Word, Excel, PowerPoint and Access).
This type of virus affects the boot sector of a floppy or hard disk.
Examples of this viruses include: Polyboot.B, AntiEXE.
Macro viruses
It increases network traffic, CPU utilization of computer thereby making systems slow
infect documents created by Microsoft Office programs (Word, Excel, PowerPoint and Access).
This type of virus affects the boot sector of a floppy or hard disk.
infect to the files that are created using certain applications or programs that contain macros.
Examples of this viruses include: Polyboot.B, AntiEXE.
Resident virus
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
infect to the files that are created using certain applications or programs that contain macros.
infect documents created by Microsoft Office programs (Word, Excel, PowerPoint and Access).
It increases network traffic, CPU utilization of computer thereby making systems slow
This type of virus affects the boot sector of a floppy or hard disk.
Examples of macro viruses:
Relax, Melissa.
Bablas, O97M
Trile.C, Sobig.D, Mapson
Polyboot.B, AntiEXE
Confiker, PSWBugbear.B,
Examples of worm viruses:
Trile.C, Sobig.D, Mapson
Confiker, PSWBugbear.B,
Relax, Melissa.
Bablas, O97M
Polyboot.B, AntiEXE
Examples of boot viruses:
AntiEXE
Polyboot.B
Confiker, PSWBugbear.B,
Relax, Melissa.
Bablas, O97M
Most of the computer viruses are designed to
Not self-replicate
Improve systems` work
Update installed programs
Exploit some kind of an error (security hole)
Help uploading applications
Which virus runs on computers memory
Multipartite virus
Worms
Resident virus
Direct Action Virus
Boots
Power faults can cause
Speed increase
Data problems
Diligence
Versatility
Accuracy
Lower voltages at electrical outlets is a
Loss
Brownout
Attack
Infection
Accessing floppy
What can cause Voltage spikes as the circuits balance
Exploit some kind of an error
Sudden losses (ex; a driver hits a power pole)
Attack systems
Slowing down
Formatting the data
Which of the followings is a solution for an incompatibility
Shut down
Make a really good backup before installing anything
Restart
Format all files
Upgrade all programs
A way to find out that a computer virus or malware program is present in your computer
Your computer works more appropriate
Your computer keeps shutting down itself
Your computer works faster
Your computer works more accurate
Your computer suddenly slows down after installing a program downloaded from internet
Today most of the viruses are being infected
Using removable media like thumb drives and through networks and the Internet.
Only by internet
Opening links
Clicking on infected files
Using computer without anti-virus software
Nonresident viruses are activated
When user performs specific activity such as accessing floppy/removable media
Through the storage devices
Through email account
By executable code found in specific system areas on a disk
Through the replication of malicious code
Which programs make it possible to automate series of operations so that they are performed as a single action
Anti-virus programs
Adobe Flash
DevOps
Cleaners
MACROS
A person can exchange his/her messages digitally through
Dead links
Universal document identifier (UDI)
Locator
HyperCard
The functions of e-mail servers
Provides a way to locate a resource on the web
To accept, forward, deliver, and store messages
Store,relocate
Restore , zip
Archive,transmit
The first e-mail was sent by
HåkonWium Lie in 1994
Ray Tomlinson in 1971
HåkonWium Lie in 1991
Ray Tomlinson in 1974
HåkonWium Lie in 1997
To send and receive e-mail messages, you can use an e-mail program as
ProgramData
Microsoft Outlook or Mozilla Thunderbird
Adode Flash Player
TeamViewer
Microsoft Access
The CC or Carbon Copy field
Receives e-mail messages
Allows you to send a copy of the message to another e-mail address
Transmits information from one place to the other
Translates codes
Change the appearance of website
An e-mail must have a
Address
Username followed by an @ (at sign) which is followed by the domain name with a domain suffix
Server
Recipient
ID
The username and e-mail addresses as a whole cannot begin or end with
It is a server of the recipient`s email service
service
It is a computer program used to access and manage a user's email
It's a new message
It`s an online e-mail service
It is the location you type your main message
0
Each domain name represents a unique Web address which is called
An e-mail client
Internet protocol (IP) address
Signature
The SMTP Server
Carbon Copy
Basically email contains 2 parts
the sender and recipient
the senderdomain name
the bodyand recipient
username and a domain name
the headerand the body
… is an electronic spreadsheet that runs on a personal computer
Microsoft Power point
Microsoft Excel
Microsoft Word
Microsoft Access
Microsoft Publisher
Which one of the followings is used to perform mathematical calculations
Microsoft Publisher
Microsoft Word
Microsoft Excel
Microsoft Access
Microsoft Power point
What concept is used to create a new file, open an existing file, save a file, and perform many other tasks.
The start button
The Microsoft Office Button
ESC button
ALT button
SHIFT button
What does give you access to commands that you frequently use
The Formula bar
The Quick Access toolbar
Title bar
The Ribbon
The Status bar
On what bar Microsoft Excel displays the name of the workbook
The Formula bar
Title bar
The Quick Access toolbar
The Status bar
Title ribbon
Which bar does give the user information about: the current worksheet, data the worksheet contains and etc.
The Formula bar
Status bar
The Quick Access toolbar
The Title bar
The Ribbon
Which command is used to check logical expression in MS Excel
Sum
Max
If statement
Avr
Min
The general form of the IF statement looks as
IF (value if true;value if false)
IF value if true; value if false; logical expression;
IF (value if true; value if false; logical expression;)
IF (logical expression; value if true; value if false)
IF (value if true; logical expression; value if false)
It provides shortcuts to menu commands.
The Formula bar
The Ribbon
The Quick Access toolbar
Title bar
Toolbar
Microsoft Excel consists of
Rows
Worksheets
Columns
Tabs
Toolbars
How do you move a pointer on the spreadsheet in Excel?
By clicking the right button of a mouse
By clicking the down button of a mouse
By clicking the up button of a mouse
By clicking the toolbar
By clicking the left button of a mouse and using arrow keys on the keyboard
A mathematical formula is entered with
an addition sign
a back slash sign
a slash sign
a subtraction sign
an equal sign
The AutoSum icon on the Standard toolbar
automatically finds a maximum value of numbers
automatically finds a minimum value of numbers
automatically finds an average value of numbers
automatically counts an amount of numbers
automatically adds a column of numbers
This function is used to add numbers
the MAX
the SIN
the MIN
the AVR
the SUM
In the MS Excel, a formula begins with … sign.
“/”
“@”
“*”
“&”
“=”
MS Excel. The MAX function is
automatically finds a minimum value of numbers
automatically counts an amount of numbers
automatically adds a column of numbers
automatically finds an average value of numbers
automatically finds a maximum value of numbers
MS Excel. The AVR function is
automatically finds a maximum value of numbers
automatically finds a minimum value of numbers
automatically finds an average value of numbers
automatically counts an amount of numbers
automatically adds a column of numbers
MS Excel. The Count function is
automatically finds a maximum value of numbers
automatically adds a column of numbers
automatically finds an average value of numbers
automatically finds a minimum value of numbers
automatically counts of the number of items in a list
MS Excel. What happens by pressing Esc key and clicking anywhere on the worksheet
adds the highlighted diapason
removes the highlighting
appears a new column
finds an average value of numbers
appears a new row
MS Excel. The F5 function key is
The “Home” key
the "Go To" key
The “End” key
The “Delete” key
The “ESC” key
The right arrow key is used
to move left one cell at a time
to move up and down one cell at a time
to move down one cell at a time
to move up one cell at a time
to move right one cell at a time
The left arrow key is used
to move right one cell at a time
to move left one cell at a time
to move up one cell at a time
to move down one cell at a time
to move up and down one cell at a tim
The up arrow key is used
to move right one cell at a time
to move up one cell at a time
to move left one cell at a time
to move down one cell at a time
to move up and down one cell at a time
The down arrow key is used
to move right one cell at a time
to move down one cell at a time
to move up one cell at a time
to move up and down one cell at a time
to move left one cell at a time
The Menu bar is located
directly near the Title bar
directly below the Title bar
directly before the Title bar
directly over the Title bar
directly behind the Title bar
This bar is located at the very top of the screen
The Menu bar
the Title bar
The status bar
The cell address
The formula bar
How many pages does The ribbon contain in MS Excel
5
8
9
10
3
Where does Microsoft Excel display the name of the workbook you are currently using.
On the Status bar
On the Title bar
On the ribbon
On the Quick Access tool bar
On the Formula bar
How do you rename the spreadsheet in MS Excel
By using the start bar
By clicking on file
By clicking on the name twice
By clicking on Formula bar
By using Quick Access tool bar
If the =SUM(C1:C10) function is nested within an =IF() function and value is equal to 10, which expression displays value “Excellent”?
=SUM(IF(C1:C10)=10;”Excellent”;”Bad”)
=IF(SUM(C1:C10)=10;”Excellent”;”Bad”)
=IF(C1:C10)=10;”Excellent”;”Bad”)
=IF(SUM(C1:C10)=9;”Excellent”;”Bad”)
=IF(SUM(C10:C1)=10;”Bad’;”Excellent”;”Bad”)
How is the combination of a column coordinate and a row coordinate called?
A formula bar
A cell address
A worksheet name
Acolumncoordinate
A title bar
What does “test!” mean in the following expression:
=IF(test!D11=1;1;0).
The reference to the worksheet ”test”
The name of the workbook
The coordinate of the cell
The address of the worksheet
Which expression give the “ИСТИНА” value if A3=20 and A4=40?
=ИЛИ(A3>20;A4<50)
=И(A3>19;A4<50)
=И(A3=19;A4=50)
=И(A5>19;A6<50)
=И(A3<19;A4<50)
Which expression gives the “ЛОЖЬ” value if A3=20 and A4=40?
=ИЛИ(A3=20;A4=40)
=И(A3>19;A4<50)
=И(A3=20;A4=40)
=ИЛИ(A3>50;A4<40)
=НЕТ(A5>19;A6<50)
Which expression calculates the SUM of the highlighted range (R1:R17) ?
=AVR(R3:R17)
=SUM(R3:R17)
=MAX(R3:R17)
=SIN(R3:R17)
=AUTOSUM(R3:R17)
Which expression calculates the average of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=AVR(R18:R20)
=AUTOSUM(R3:R17)
=MAX(R3:R17)
=SIN(R3:R17)
Which expression finds the maximum of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=SIN(R3:R17)
=MAX(R3:R17)
=AUTOSUM(R3:R17)
=MAX(R18:R20)
Which expression finds the minimum of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=MIN(R3:R17)
=SIN(R3:R17)
=AUTOSUM(R3:R17)
=MIN(R18:R20)
Each worksheet contains
Records
data types
Numbers
Symbols
columns and rows
The trunk-modular principle of the architecture of modern personal computers implies such a logical organization of its hardware components, in which:
each device communicates with others directly;
each device communicates with others directly, and also through one central highway;
devices communicate with each other in a certain fixed sequence (ring);
the devices communicate with each other through the central processor, to which they are all connected.
they all communicate with each other via the highway;
Specify the devices that are part of the processor:
random access memory, printer, video memory;
cache memory, video memory;
scanner, ROM;
display processor, video adapter.
arithmetic logic unit, control unit;
Audio is …
Music
speech
picture
other sound
sentence
