WorksheetsИкт 2рк 1 ответ
Total questions: 81
Worksheet time: 41mins
The special programs oriented for controlling and managing external and internal devices of PC?
Device drivers
New plan of PC
Application software
Computer System
Primary secondary
Name of the first computer
Mainframe
ENIAC
Abacus
Pascaline
Prima
In what kind of memory must all the programs be loaded for being processed?
CD-Rom
RAM
ROM
Hard Drive
Prim
Microphone, mouse and keyboard are ... peripherals.?
Input
Output
Audio
Video
Primary
In most IBM PCs, the CPU, the device drives, memory expansion slots and active components are mounted on a single board. What is the name of this board?
Breadboard
Primary board
Motherboard
Daughter board
Grandmother board
What does the term "hardware" mean?
It is secondary
Media control architecture
System application architecture
Computer system architecture
It is the Application Program
What does GPU stand for?
Gigabyte Processing Unit
Gamma Power Unit
Graphics Processing Unit
Giant Publishing Unit
Primary and secondary
What does RAM stand for?
Random Access Memory
Rom Attack Mode
Ready Access Memory
Read Annual Memos
Primary and secondary
Manipulator converting motion into a control signal
Mouse
Monitor
Plotter
Printer
The CPU
It is a program which transfers a text of other programs to machine codes:
Operating system
Utility
Translator
The CPU
Driver
A device that produces video footage in real time for transmission over the Internet:
The CPU
Monitor
Scanner
Web-Camera
Printer
Name the two types of software
The CPU software
system software and application software
operating software and driver software
utility software and database software
presentation software and reference software
Which is System software?
Microsoft Office
The CPU
Graphic programs
Type of hardware
Formatting disks
Which is Application software?
Drivers
Graphic programs
Type of hardware
Formatting disks
The CPU
You control and interact with a computer using a ...?
CPU
User Interface
User Output
User Input
User Outerface
Uses icons for the user to select using a mouse?
Natural language and speech
PUQ
Touch
GUI
Command line
Requires the user to type instructions using the keyboard?
Command line
GUI
Touch
Natural language and speech e.g.
CPU
What is an operating system?
Neither of these
The CPU
Programming software
Application software
System software
One kind of type of Operating Systems?
Single-user OS
Mini-user OS
Single-language OS
Multi-functional OS
The opera two
Application software includes?
The CPU
Device drivers. Manipulator
Hardware, Media control
Utilities, Computer System
Text editor, spreadsheet
Mobile technology which based on digital technology:
Data storage system
3G
4G
Virtual reality
Cloud technology
FTP means:
Functional Transfer Protocol
Functional The CPU
File Transfer Protocol
Form Transitive Protocol
FTransportation Protocol
A software package to implement a data base is
DBMS
DASD
Database
System analysis
Transfer Protocol
Close window in WINDOWS OS, you can press:
F8
Ctrl + F4
Alt + Esc
Alt + Tab
Alt + F4
Spreadsheet software -
Provides tools to create electronic spreadsheets
Supplies the tools for combining text, photos, clip art, graphs, animations, and sound
Helps you enter, find, organize, update, and report information stored in a database
Has replaced typewriters for producing many types of documents
Functional Transfer Protocol
The short cut for create a new file Word or Excel...
Ctrl+V
F1+2
Ctrl+Z
Ctrl+N
Ctrl+C
What is a font?
different text style
name of paragraph
type of text color
text alignment
functional protocol
What is a 'Worksheet'?
A document from a text book
A blank document
A page in a spreadsheet
A sheet to show calculations
A photocopy from a text book
Money in cells should be formatted as what?
a text
$
Euro
Currency
?
What is a cell reference?
A cell from a text book
The column letter and row number to identify a cell
The shape of a cell
A cell number and row letter used to identify column
The color of a cell
What formula should you use when adding up a lot of numbers?
ADD
SUM
COUNT
TOTAL
ALL
How many cells are in the range B2:D7?
Unknown
18
12
6
22
Which of the following is a completely absolute cell reference?
$J$4
J4
$?4
$4
A20
What key is Help?
F1
F2
F5
F3
F+A
###### means:
The cell is not wide enough.
You've misspelled something.
You've entered a number wrong.
None of the above
A cell from a text book
#NAME means:
when Excel does not recognize text in a formula
when a formula has the wrong type of argument
when a formula tries to divide a number by 0 or an empty cell
when a formula refers to a cell that is not valid
when a formula from other books
Sorting can be
on increase or on decrease order
selection of data on certain criteria
a calculation that describes the relationship between cells
positional and none positional
statistical, mathematical and logical
Filtration of data -
selection of data on certain criteria
a way of arranging data in a particular order
a calculation that describes the relationship between cells
set of data held in a computer
none of the above
Change addressing in formula possible by key...
F4
F1
F3
F5
F2
What symbol represents absolute reference in MS Excel?
#
&
%
$
+
What is a Chart?
It is a visual way to display and compare data
A way of arranging data in a particular order
A calculation that describes the relationship between cells
None of the above
A photocopy book
Show functions in Excel:
Trigonometrically
A photocopy from a text book
Statistical
System
Symbol
An example of a range address:
A1:B3
C1; B3
A1-B3
A1=B3
B5+A5
Data that are entered into a cell in spreadsheet:
formula, pattern, number
number, formula, text
text, graphics, pattern
text, chart, formula
photocopy, text book
The purpose of a database is:
All are correct
Store data
Update data
Processing data
Query data
The use of electronic signals, marks, or binary digits to represent character, numeric, visual, or audio data:
Data representation
Data analysis
Data redundancy
Data dependence
File Name Extension
How many bits consists one number or symbol?
8
2
32
16
15
The smallest unit of information is:
Bit
Byte
KByte
MByte
GByte
The small measurement of information.
bit
byte
megabyte
gigabyte
terabyte
Where is there small measurement to information?
bit
byte
megabyte
gigabyte
terabyte
The hexadecimal system of the numeration uses the numerals.....
0,1,2,3,4,5,6,7,8,9, A, B, C, D, E, F
0, 1,2,3,4,5,6,7
A, B, C, D, E, F
I, II, III… D, E, F
0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16
How is called a system of interrelated technical devices that perform input, storage, processing and output of information?
SOFTWARE
System support
HARDWARE
Software
Computer equipment
A hard disk is divided into tracks which are further subdivided into:
basics
sectors
clusters
posters
triptors
Integrated circuit (ICs) as basic electronic component (SSIC and MSIC):
Third Generation of Computers
Zero Generation of Computers
The fifth Generation of computers
The sixth Generation of computers
The seventh Generation of computers
The second Generation of Computers -
1980-Onward
1955-1960
1945-1955
1966 - 1981
None of these
Other components of a computer:
Peripheral devices
Output device
Input device
System Unit
Storage device
Connection to the Internet by telephone or cable line.
Online
Internet
Internet Firefox
Google Opera
In Corel Draw Bitmaps can also be edited more extensively using
Corel Photo Paint
Corel Paint graph
SS Photo Paint,
Photo Paint edito
special Photo
Which of these programs is a graphical editor?
CorelDraw
Doctor Web
Opera
WinZip
Special Hub
This is networks connect computers together over large physical distances, remotely connecting them over one huge network and allowing them to communicate even when far apart.
Newsgroups Agents
Metropolitan Area Network
Service net
LAN
WAN
A function of Rambler server in the Internet:
Networks connect
Searching service
Testing Service
Dating Service
Weather forecas
A special computer, emphasized for joint using by net users, is called
Server
Director
Administrator
Processor
Newsgroups
Specify the function of E-mail service in the Internet
Electronic mail
Testing means
Work with the text
Data base
Networks connect
Local net. How does configuration (ink circuit) of local net call?
Topology
Resource
System
Union
Connect
Means for viewing Web-documents is called
Text editor
Browser
Graphics editor
Modem
Multimedia Player
How does a personal computer with high volume disk for storage files, which can be used by other computers, connected to the net, call?
Server
Network interface card
Modem
Hub
Connect
PowerPoint is best described as
Presentation software
Database software
Drawing Software
Desktop publishing software
Desktop publishing
The section of informatics dealing with problems of creation and processing on the computer of graphics images (figures, drawings, animation), is called...
computer graphics
information network
electronic spreadsheet
topology of networks
publishing software
Possible symptoms of virus infection
All of the above.
Slow down some programs, suddenly encountered a variety of video and sound effects;
Increasing the size of files (especially running);
The emergence did not exist before, "strange" files;
Reducing the amount of available RAM (compared to the usual mode of operation);
As habitat viruses can be divided into
Batch, interactive and passive.
Text and Image.
Character and graphics.
Active and passive.
File, boot, macro viruses, and network.
Viruses can be divided into classes according to the following criteria:
All of the above;
According to the habitat;
By way of infection of habitat;
On the destructive capabilities;
On the specifics of the algorithm of the virus;
The source of infection may include:
Computer networks infected disks, floppy disks, flash drives;
Cable, floppy disks;
Disks, floppy disks, flash drives;
Diskette, flash drives;
Desktop
When archiving the volume of files ...
Is reduced by 10-70%
Increased by 20-75%
Increased by 100%
Reduced by 0.1-0.7%
Publishing by 100%
Create a new document
Ctrl + N
Ctrl + C
Ctrl + A
Ctrl + O
Ctrl + Insert
Save the current document, project, etc.
Ctrl + S
Ctrl + C
Ctrl + V
Ctrl + f
Ctrl+R
Move to the top line of text
Tab
Home
End
Ins
Delete
Move to the end of a line of text
End
Home
Delete
Tab
Desk
Removing an object
Delete
Enter
Caps Lock
Num Lock
Page Down
How many the main components are of "e-gov" system?
3
4
5
7
6
The goal of e-government:
All of these answers are correct
Transparency of public authorities;
The destruction of monopoly officials for information;
The efficiency of public administration;
Both resource development
The arranging of data in a logical sequence is called:
sorting
reproducing
classifying
summarizing
development
