Font size
WorksheetsИкт 1
Total questions: 100
Worksheet time: 50mins
The computer is:
multifunctional electronic device for information
device for working with text
electronic computing device for handling numbers
device to store information of any kind
analog signal processing device
What device is used by computer to process information?
processor
the manipulator "mouse"
keyboard
monitor
RAM
Processor speed is:
the number of generated pulses per second, clock work computer nodes
the number of binary operations committed per unit of time processor
speed of information exchange between the processor and i/o devices
the number of possible references to the operating memory in unit of time
speed of information exchange between the CPU and ROM
RAM defines:
how much information can be processed without the access to your hard drive
how much information can be stored on the hard disk
how much information you can print
how much information you can copy
how much information can use the Internet
Specify the most complete list of main devices:
microprocessor, coprocessors, monitor
the CPU, memory, i/o devices
monitor, Winchester, printer
ALD, DD, coprocessor
scanner, mouse, monitor, printer
Name the device included in the processor:
random access memory, printer
cache memory, video memory
arithmetic logic unit, control unit
scanner, ROM
the display processor, video card
Processor handles information:
Basic language
binary
in ternary code
radix
as text
During the execution of an application program is stored:
ROM
hard disk space
processor
the VRAM
RAM
Personal computer will not function if you disable:
mouse
scanner
drive
printer
memory
For long-term storage information is:
power supply
external storage
RAM
processor
drive
Drive is a device for:
long-term storage information
paper output
read/write data from external media
command processing executable program
store commands executable program
Which device is used to enter information:
printer
ROM
monitor
keyboard
processor
The manipulator "mouse" is a device:
input information
modulation and demodulation
read
long-term storage information
to connect the printer to the computer
To connect your computer to the Internet using:
fax
modem
scanner
printer
monitor
Which one runs on a computer hardware and serves as a platform for other software to run on?
System Software
Database System
Operating System
Malicious Software
Application Software
Which of the following Operating System does not implement multitasking truly?
Windows XP
Linux
Unix
Windows 7
MS DOS
Which is the first program run on a computer when the computer boots up?
System software
System file
Operating Shell
Operating system
System operations
Which is the layer of a computer system between the hardware and the user program
Operating system
System environment
Drivers
Operating environment
Utilities
Specialized program that allows users to utilize in specific application is classified as
relative programs
application programs
replicate programs
utilities
database packages
Programs used to control system performance are classified as
specialized program
organized programs
system programs
experimental programs
utilities
Which application software would best be used when you need to print a letter for a legal client?
MS Access
MS Excel
MS Publisher
MS Word
Google Chrome
If Aidar has already saved his file, then what choice can he use to change the file name?
Change the template
Change page setup
Double-click
Open file properties
Use save as
In Windows operating system , an icon or a link that provides access to some original program or resource is known as.
Cursor
Shortcut
Desktop
Panel
Icon
Moving an item across the screen with the mouse
Recycle bin
Double-click
Drag and drop
Web browser
Clipboard
A picture that represents a file
Start menu
Folder
Desktop
Icon
Shortcut
Windows 7 Operating System is an upgrade from
Windows 8
Windows 2000
Windows Millennium
Windows 98
Windows XP or Vista
Set of programs with full set of documentation is considered as
software
operating system
database packages
software packages
file package
When sizing a window
Mouse pointer has one-headed arrow
Mouse pointer does not change
Mouse pointer change into a two-headed arrow
Mouse pointer turns into a cross
Mouse pointer change into a three-headed arrow
What is the key combination to Quit a program through Task Manager that is not responding?
Shift + Enter
Shift + Alt + Del
Ctrl + Alt + Del
Alt + Del
Ctrl + Del
Elements of the dialog box:
scrollbar
roll
working field
control button
Menu bar
Which of the following functions are displayed state of the control buttons of the window?
Cut, copy, paste, close
minimize, maximize, restore, close
minimize, maximize, close
Cut, copy, paste
Scroll bars
The elements of the Windows desktop:
text box
Minimize, maximize, close
"Start" button
scrollbar
check box
Right-click exercises
a context menu
start
hang
selection
Cascade
Icon is ...
selection
Label
drawing
Taskbar
start
What is the window bar displays the name of the disclosed subject?
Title bar
Status Bar
Menu bar
Toolbox
drawing
The set of tools and rules of user interaction with the computer is called
Processor
user interface
the object of control
Menu bar
interface
Double-clicking the left mouse button performs
the title
a context menu
selection
start
Drag and Drop
Clicking the left mouse button performs:
start
Move
hang
contextual
the title
Hyperlinks to the Web can provide choices of transition
programming language translators
The means of Web browser - pages
Tools for creating Web - pages
The text typed on a computer
Internet Server
Markup text, images and other objects on a web page is realized with the help of ...
Team
Operators
Tag
the operands
Binary
Browser - a program for ...
creating web pages
Web browsing
the creation of databases
Programming Language
creation of multimedia presentations
What is a shortcut?
a copy of the file
a graphical representation of the object
a pointer to an object
the active control
Window
Pressing the START button will open the
application
main Menu
document
window
command
As a context menu?
the left mouse button
Right-click
key F1
Start button
F5 key
Which of the following datatypes is used to attach Microsoft Office files, graphics files, sound files, and pdf files to a table in Access?
Currency
Memo
Text
Hyperlink
OLE object
Which of the following data types is more commonly called Boolean in Access ?
Hyperlink
Attachment
Date/Time
Yes/No
OLE object
Which of the following data types is used to enter more than 255 characters?
OLE object
Text
Hyperlink
Memo
Date/Time
Which of the following programs is used to work with DataBase?
MS Power Point
MS Word
MS Excel
MS Access
Calculator
What is an intersection of a row and a column in a Microsoft Access?
Cell
Form
Cursor
Record
field
Which is the not valid data type in Access?
Currency
Picture
Number
Text
Memo
How many relations may exist between tables in databases?
1
2
3
4
5
What the object used for printed on paper the database in a Microsoft Access?
Table
Query
Report
Form
Macros
Which data type is better to use for storing phone number in the following format “977-1-1234567” in Access?
Currency
Memo
Number
AutoNumber
Text
Which criteria return only those addresses beginning with the letter “K” in Access??
Address = “K?”
Address = “K*”
Address = “K”
Address = “K#”
Address = “*K”
Which criteria return only a phone number ending the number "5" in Access??
number phone = “*5”
number phone = “*5*”
number phone = “5”
number phone = “5?”
number phone = “5*”
Which of the following Data Type is used to store picture in MS Access?
Picture cannot be stored in MS Access
OLE Object
Picture
Memo
Image
What is the maximum length a Text field can be in MS Access?
75
265
256
120
255
What is the extension of Access Database files (2007 and later)?
accdc
mdb
accdb
accbd
64536
256
65536
1048576
1024
What key should be used to edit the content of a cell?
F4
F3
F1
F5
F2
What key should be used to determine the absolute reference?
F1
F2
F3
F4
F5
Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
Excel 2010
Office 2010
Calc
Windows
Word 2010
Which of the following notebook- like features organizes the sheets for use in Excel?
Worksheet
Workbook
Notepad
Folder
File
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
Workbook
Notepad
Worksheet
Folder
File
What is immediately visible on screen when you open Excel 2010?
Create new workbook dialog box
Open a workbook dialog box
The File panel
A new workbook
A new workcell
256
64536
65536
1024
16385
What do you use to navigate and display different portions of a worksheet in the worksheet window?
Scroll bars
Arrow keys
Page Up or Page Down key
Slider bars
Arrow bars
What is the intersection of a row and a column in a worksheet called?
Block
Cell
Table
Cube
Sheet
What symbol should be put in the cell address in the formula to make the Absolute reference?
!
^
$
@
%
Which of the following do you use to move one cell to the right in an Excel worksheet?
Home key
Down arrow key
Right arrow key
Enter key
Page Up key
Which of the following do you use to move down one cell in an Excel worksheet?
Right arrow key
Page Up key
Home key
Enter key
Insert key
What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells?
Filler
Copy handle
Copy box
Insert box
Fill handle
When copying values in Excel 2010, which feature automatically adjusts cell references for the new copy location?
Relative reference
Absolute reference
Certain reference
Variable reference
Insert reference
Information in computer networks is transmitted via communication channels as separate ones:
messages
packages
data
messages
local network
Which device allows your computer to talk to other computers over a telephone line as well as access the internet?
RAM
CD-ROM drive
Modem
Hard Drive
Intranet
What is the name of the host computer on the network:
terminal
modem
browser
host computer
topology
A _______ consists of two or more computers that are linked in order to share resources.
Router
Client/server
Communications Channel
Peer-to-peer
Network
Local computer network it?
the network to which all computers in the same building are connected
the network to which all the computers of the country are connected
the network to which all computers of one settlement are connected
the network to which all computers are connected
the network to which all the computers of the town are connected
Two variations of a WAN are:
Intranet and Extranet
Modem and Hub
Transmission Media and Client
NICs and Router
Bridge and Gateway
What is a LAN confined relatively to?
large area
no area
small area
medium area
huge area
What is consist of two or more LANs and connected by routers?
Communications Media
Satellite Transmission
Microwaves
WAN
Communication Hardware
What do most networks consist of?
Computer clients and Network server
Bridge and Gateway
Cable modem and modem
Wireless media and Physical media
Communication media and Communication hardware
Which of the following is NOT a banefit of a network?
Internet connection sharing
home entertainment
expensive to install
file sharing
printer sharing
An example of communication hardware:
Internet
Keyboard
Modem
Microsoft Word
Monitor
What is a modem?
Connects on computer to other computers and peripheral devices.
To transfer data from one computer to another.
A computer that uses the services of another program.
Communications hardware device that facilitates the transmission of data.
A special computer that connects on local area network to another.
What is the most expensive type of cable?
Coaxial cable
Microwaves
Twisted-pair cable
Satellites
Fibre-optic cable
INTERNET is ...
local network
global network
branch network
regional
topology
This is a class of programs that searches your hard drive and floppy disks for unknown or potential viruses.
security identifier
antigen
antivirus software
archive file
intrusion detection
What is the name of a program or programming code that replicates by being copied or initiating its copying to another program, computer boot sector or document?
Spyware
Firewall
Norton
Virus
intrusion detection
Encryption information is…:
The process of its transformation, in which the content of the information becomes incomprehensible to non-authorized subjects
A conversion process in which information is deleted.
The process of its transformation, in which the content of information is changed to a false
The process of converting information into machine code
Identification protocol
Software information protection
backup
cryptography
uninterrupted power supply unit
data dublication
Desepticons invasion
Ensuring the accuracy and completeness of information and methods of its processing.
Confidentiality
Availability
Integrity
Dr. Web
Feasibility
Providing access to information only to authorized users?
Availability
Integrity
Feasibility
Privacy
Dr. Web
The greatest threat to network security pose
opening standard user account
opening of the standard account administrator group
copying files that have been changed during the day, without a backup mark
unauthorized access, electronic eavesdropping and intentional or unintentional damage
main menu
What is Information Security?
Identification protocol
Software update
the security of personal information
PC security measures
Measures to protect information from unauthorized access
Measures to protect information from unauthorized access is called
Private security
security admin group
Information Security
PC security
Desepticons invasion
What is the name of intentionally distorted information?
Informative stream
Reliable information
Stop being information
Misinformation
Short circuit
What is the name of the information to which access is limited?
Illegal
Open
not available
Messages
Confidential
This is a computer system on the Internet that is expressly set up to attract and "trap" intruders.
Honeypot
Demilitarized zone
Exploit
Trojan horse
Dr. Web
