WorksheetsICT 81-160
Total questions: 80
Worksheet time: 44mins
The octal number system consists of the following symbols :
0..7
0 .. 1
0..9
0..5
0..9; a..f
Which one of the following is an example of Operating System?
Microsoft Word
Microsoft Windows
Microsoft Excel
Microsoft Access
Microsoft Power Point
Which one of the following is not a network device?
Hub
Router
CPU
Switch
bridge
HTML is basically used to design:
Web-site
Graphics
Web-page
Tables and Frames
Calculations
Which is the largest unit of storage among the following?
Gigabyte
Terabyte
Megabyte
Kilobyte
Byte
RAM means:
Rapid Access Memory
Rigid Access Memory
Random Access Memory
Range Access Memory
Revolving Access Memory
WWW stands for
word wide web
world wide web
weird wide web
who what and where
Wind wild web
Which of the following is the appropriate definition of a computer?
Computer is a machine that can process information.
Computer is an electronic device that can store, retrieve and quickly process only quantitative data.
Computer is an electronic device that can store, retrieve and process both qualitative and quantitative data quickly and accurately
Computer is a machine that can store, retrieve and process quickly and accurately only qualitative information.
Computer is a car that can store, retrieve and process quickly and accurately only qualitative information.
ICT stands for :
Inter connected Terminals
Intera Common Terminology
Information and Communication Technology
International Communication Technology
Internet and Communication Technology
A private cloud can be
logically located on the company’s on-site datacenter.
physically located on the company’s on-site datacenter.
located on the server of the user.
located on my own computer.
located on every
Types of cloud deployments:
General, common, public
public, private, hybrid
Public, common
Hybrid, common, public
General, middle, security
One byte equals to
16 bits
8 bits
256 bits
1024 bits
1 bit
Most cloud computing services fall into three broad categories
infrastructure as a cloud, platform as a network and software as a service
infrastructure as a service, platform as a service and software as a service
infrastructure as a provider, platform as a provider and software as a service
infrastructure as a speed, platform as a data and software as a hardware Productivity
infrastructure as a service, platform as a data and software as a Productivity
Benefits of cloud computing do not include
cost
User feeling
Global scale
Speed
Productivity
Companies offering these computing services are called
Computer engineering
Cloud workers
Cloud providers
Cloud makers
Cloud administrators
The main functions of the operating system include:
Dialogue with the user, creating a computer program.
Print information by the printer.
Dialog with the user, control the resources of the computer, start the program.
Management of computer resources, execution of computer programs.
Copying information from the scanner to the computer, starting the program
Types of addressing in Excel spreadsheet:
Absolute, mixed, simple.
Relative, mixed, simple
Relative, absolute, simple .
Absolute, relative, mixed.
Absolute, simple, mixed.
Access. The data representation model is
system of making managerial decisions involving computer.
logical structure stored in the database
diagram
a set of programs for data exchange;
software system for storing, adding, deleting and editing data in a database
Access. The data representation model is
system of making managerial decisions involving computer.
logical structure stored in the database
diagram
a set of programs for data exchange;
software system for storing, adding, deleting and editing data in a database
Specify a package that allows you to work with databases ...
MathCAD.
Math Lab.
MS Access.
MS word.
Notepad
Which one is used to connect tables in MS Access?
Forms
Data scheme
Table
Macros
Record
MS Access. Specify the field type if the field name is "date of birth"
Logical
Text
Number
Date Time
Currency
Query in MS Access:
An object in which the developer places controls that accept user actions or serve to enter, display, and modify data in fields
To enter and edit data.
Displays all the fields of a single entry, it is convenient for entering and editing data.
Formalized requirements for sampling data from tables or performing certain actions with data
Represents the macro sequence of the built-in Access language
The first computers appeared in ...
1948
1936
1946
1949
1951
List the main objects of the Access database:
In the Access database, the main objects are tables, queries, forms, reports.
In the Access database, the main objects are tables, reports, macros, and modules.
In the Access database, the main objects are tables, queries, macros, and forms.
In the Access database, the main objects are tables, queries, macros, and modules.
In the Access database, the main objects are tables, queries, forms, reports, macros, and modules
The average of the contents of the cells from A1 to A10 is calculated by the formula in Excel:
= SIGNAL (A1, A10).
= SUM (A1: A10).
= AVERAGE (A1: A10).
= CP3HA4 (A1; A10) ..
= DA1; A10)
1 megabyte is equal to
1024 KB
8 bits
8 bytes
2
1000 KB
MS Access. Specify the type of the field if the name of the field "number of medicines"
monetary
textual
numerical
logical
memo
MS Excel. Specify the correct summation formula entry ...
= sums (A1: A10)
of the sums A1: A10
= sumA1: A10
sum (A1: A10)
sums (A1: A10)
Specify which of the following is the "brain" of the computer
CD-R.
Processor.
Monitor.
Keyboard.
RAM.
The hyperlink allows:
save documents.
move to the place of the bookmark.
view pictures.
archive documents.
create new documents.
MSAccess. Macros is ....
An object that is a structured description of one action
An object that represents a structured description of several actions that Access Basic must perform
An object that is a structured description of one action that Access Basic must perform
An object that is a structured description of several actions that [Human computer interaction] must perform
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
What does allow web developers to alter the layout and appearance of their web pages
Domain Name System (DNS)
Internet Engineering Task Force (IETF)
Cascading Style Sheet, CSS
HyperText Transfer Protocol (HTTP)
The Internet Archive
Why are web pages called “hypertext documents”
Because when you click a word or a picture which is hyper linked you can go to another location
They contain only text
Because it accepts information through text
Because it is made for readable manner
Documents are used for storing text
FTP is commonly used to
Make connection
Transmit the information from one place to the other
Transfer Web page files from their creator to the computer
Download programs
Install applications
A computer which is capable of receiving the information from the server in the Internet is called a
Server
Domain
Client
Service
Locator
What is a browser
Set of rules and guidelines for communicating data
Foundation of data communication
A computer software which can be used to view documents on the Internet
Transmission of information from one place to the other
Largest service acquired amongst the services provided by the Interne
This type of virus can steal information from user`s computers and upload to web sites
Worms
Boots
Resident virus
Polymorphic virus
Multipartite virus
What is a computer virus
An application
Type of hardware
MS document
A harmful computer program developed by a person that disrupts operations of a computer in various ways
Browser
What is a router
A device which makes the use of computer technology cost effective
A networking device that forwards packets between networks using information in protocol headers
Devices used to connect end devices to the network
Device attached to the network to obtain human computer interaction
A device used to extend a network so that additional workstations can be attached
What do connect multiple network segments at the data link layer (layer 2) of the OSI model
Interfaces
Bridges
Security cameras
Network printers
Modems
An Internet Protocol (IP) address is a
Set of devices which form the interface between the human network and the underlying communication network
Set of devices which obtain protection functions
Numerical identification (logical address) that is assigned to devices participating in a computer network
Numerical identification (logical address) that is assigned to provide network
Set of devices which perform typical tasks for appropriate function of hard disk
What is the “HUB”
A device used to extend a network so that additional workstations can be attached
Is a device for providing programs` access
A device used to run applications
Type of operating system
Name of the Browser
What does have several processors rather than just one and may be dedicated to a specific support function
Router
Network
Broadcast
Server
Intermediary device
The device needed to connect computers to the local network:
TV tuner
video card
Network Card
tire
plume
The main element of MS Access is
Forms
Record
Field
Table
Macros
The protocol, domain, directories, and files are all separated by
Periods (.)
Commas (,)
Forward slashes( / )
Asterisks (*)
Low lines (_)
What are the systems of interconnected computers that share a central storage system and various peripheral devices
Networking
Hardware
ICloud system
Computer systems
Firmware
Computer programs installed in the computer are called …
Hard disc
Firmware
Hardware
Engineering
Software
The first technical characteristics of a CPU is a
Diligence
The accuracy
Speed
Reliability
No feeling
Most common type of computers in the society are …
Personal computers
Super computers
Minicomputers
Mainframes
Double computers
Which type of computer is capable of handling and processing very large amounts of data quickly
Microcomputers
Minicomputers
Mainframes
Super computers
Double computers
Which one defines the physical equipment that is involved in the computer functioning
Software
Hardware
Firmware
Nextware
Hard disc
Which computer is used for performing complex scientific and numerical computations such as weather forecasting, fluid dynamics, and etc.
Microcomputers
Mainframes
Super computers
Minicomputers
Double computers
The computer hardware is typically divided into four main parts which are
Printers, Xerox, input and output devices
Control Unit (CU) and the Arithmetic and Logic Unit (ALU)
Processing Devices, Memory Devices, Input/, Output Devices
Local, broadband, personal, regional
Printer, plotter, modem, headphones
A series of instructions that tells a computer how to perform the tasks is called
device
Number
A program
Command
Text
Any hardware component that allows you to enter data, programs, commands, and user responses into a computer is known as
An output Device
Power supply
Processing
An Input Device
BIOS
Which device is not classified as an input device
Keyboard
Trackball
Printer
Mouse
Joystick
How do we call the digital representations of non-text information such as drawings, charts, pictures and photographs
Graphics
sound
Text
number
video
Music, speech, or any other sound is called
Text
Video
Graphics
Audio
0..9
The number system whose base is 8 is known as
the Hexadecimal number system
the octal number system
the binary number system
the decimal number system
The non octal number system
What contains the CPU, BIOS, memory, mass storage interfaces, serial/parallel ports, expansion slots, and all the controllers required to control standard peripheral devices
RAM
Control unit
the motherboard
ALU
storage device
Type of Operating Systems
single-user single-task
mini-user single-task
micro-user single-task
multi-user micro-task
mini-user mini-task
Single-user single-task OS allows
Work out the most efficient use of computer processing cycles
many applications running at the same time
Keep logs of how much processing time and resources they use
Each user logged on to the system, their workspace and so on
only one person running only one application at a time
Which option below researches the design and use of computer technology, focused on the interfaces between users and computers
System software
Human–computer interaction
Computer Hardware
Shortcut Icons
Task Bar
What does Human–computer interaction study in communication
Computer and software
A computer and Computer systems
A human and a machine
User and users
A computer and applications
In HCI on the human side, there are not considered concepts such as
communication theory
linguistics
computer graphic
social sciences
cognitive psychology
The main problem of human-computer interaction is how to improve
the reliability of CPU
the speed of CPU
The accuracy of computer interfaces
the usability of computer interfaces
The diligence of computer interfaces
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 Text interface with menus
A Voice user interfaces
A Graphic userInterface
A Command Line interface
A Desktop Interface
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 Text interface with menus
A Command Line Interface
A Graphic interface
A Desktop Interface
A Voice user interfaces
What type of chart is useful for comparing values over categories?
Column Chart
Line Chart
Pie Chart
Dot Graph
Big Chart
Which function in Excel tells how many numeric entries are there?
COUNT
NUM
CHKNUM
ADDRESS
SUM
Choose the suitable variant for Public Cloud
Access limited to client and its partner network.
Client owned and managed.
Service provider owned and managed.
Drives efficiency, standardization and best practices while retaining greater customization and control.
Service provider own
Choose the Advantage of Cloud Computing
Web-based applications require a lot of bandwidth to download, as do large documents.
Cloud computing is impossible if you cannot connect to the Internet
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.
Changes to computers, applications and documents follow you through the cloud.
Cloud computing needs connecting to the Internet
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
Query
DDL(Data Definition Langauge)
Relational Schema
DML(Data Manipulation Langauge)
Report
A relational database consists of a collection of
Tables
Records
Keys
Fields
Tabs
How will you graphically represent expenditure in different departments?
Line Chart
Column Chart
Dot Chart
Pie Chart
Big Chart
Choose right variant. Find example of ergonomics.
use of red for warning, green for okay, awareness of color-blindness
all answers are correct
physical position, environmental conditions temperature, humidity
seating arrangements adaptable to cope with all sizes of user
use of awareness of color-blindness
Choose right variant.
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
1,2
1,3
1,2,3
2,3
1
What is a sign of copyright protection?
$
#
^
©
&
