NEW
Font size
WorksheetsInformation and communications technology 51-100
Total questions: 50
Worksheet time: 2hrs 40mins
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?
Form
Macros
Query
Report
Table
Which data type is better to use for storing phone number in the following format “977-1-1234567” in Access?
Attachment
AutoNumber
Number
Text
Memo
Which criteria return only those addresses beginning with the letter “K” in Access??
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*”
Which of the following Data Type is used to store picture in MS Access?
Image
OLE Object
Picture cannot be stored in MS Access
Memo
Picture
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)?
mbd
accdb
accdc
accbd
mdb
4194304
8388608
4096
256
1048576
What key should be used to edit the content of a cell?
F2
F4
F3
F5
What key should be used to determine the absolute reference?
F2
F3
F7
F4
F1
Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
Paint
Office 2010
Word 2010
Windows
Excel 2010
Which of the following notebook- like features organizes the sheets for use in Excel?
Work
Worksheet
Workbook
Folder
Exercise
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
Workbook
Worksheet
Notepad
File
Folder
What is immediately visible on screen when you open Excel 2010?
Create new workbook dialog box
A new workbook
Open a workbook dialog box
The File panel
A new workcell
256
65536
16385
1024
64536
What do you use to navigate and display different portions of a worksheet in the worksheet window?
Arrow bars
Slider bars
Page Up or Page Down key
Scroll bars
Arrow keys
What is the intersection of a row and a column in a worksheet called?
Sheet
Cell
Block
Cube
Table
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
Backspace
Right arrow key
Down arrow key
Insert key
Which of the following do you use to move down one cell in an Excel worksheet?
Enter key
Backspace
Page Up
Right arrow 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?
Fill handle
Filter
Arrow box
Insert box
Copy box
When copying values in Excel 2010, which feature automatically adjusts cell references for the new copy location?
Insert reference
Relative reference
Variable reference
Absolute reference
Certain reference
Information in computer networks is transmitted via communication channels as separate ones:
local network
folder
data
messages
packages
Which device allows your computer to talk to other computers over a telephone line as well as access the internet?
<variant> CD-ROM drive
<variant> Hard Drive
<variant> RAM
<variant> Modem
<variant> Intranet
Hard Drive
RAM
Modem
Intranet
CD-ROM drive
What is the name of the host computer on the network:
browser.
topology
modem
terminal
host computer
A _______ consists of two or more computers that are linked in order to share resources.
Client/server
Communications Channel
Network
Router
Peer-to-peer
Local computer network it?
the network to which all the computers of the town are connected
the network to which all computers are connected
the network to which all computers in the same building are connected
the network to which all computers of one settlement are connected
the network to which all the computers of the country are connected
Two variations of a WAN are:
Modem and Hub
Intranet and Extranet
NICs and Router
Transmission Media and Client
Bridge and Gateway
What is a LAN confined relatively to?
large area
medium area
small area
no area
huge area
What is consist of two or more LANs and connected by routers?
Communication Hardware
Microwaves
Satellite Transmission
WAN
Communications Media
What do most networks consist of?
Wireless media and Physical media
Computer clients and Communication hardware
Computer clients and Network server
Bridge and Gateway
Communication media and Communication hardware
Which of the following is NOT a banefit of a network?
home entertainment
expensive to install
file sharing
Internet connection sharing
printer sharing
An example of communication hardware:
Modem
Microsoft Word
Keyboard
Internet
Monitor
What is a modem?
A special computer that connects on local area network to another.
A computer that uses the services of another program
To transfer data from one computer to another.
Connects on computer to other computers and peripheral devices.
Communications hardware device that facilitates the transmission of data.
What is the most expensive type of cable?
<variant> Twisted-pair cable
<variant> Coaxial cable
<variant> Microwaves
<variant> Satellites
<variant> Fibre-optic cable
Microwaves
Satellites
Fibre-optic cable
Twisted-pair cable
Coaxial cable
The e-mail address in the Internet is set: user_name@mtu-net.ru. What is the name of the owner of this email address?
INTERNET is ...
global network
topology
branch network
local network
regional network
This is a class of programs that searches your hard drive and floppy disks for unknown or potential viruses.
Trojan virus
BIOS-kit
Archive file
intrusion detection
antivirus software
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?
intrusion detection
Virus
Norton
Firewall
Spyware
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
Trojan virus
Delete your data
Desepticons invasion
cryptography
backup
Ensuring the accuracy and completeness of information and methods of its processing.
Integrity
Dr. Web
Feasibility
Availability
Confidentiality
Providing access to information only to authorized users?
Privacy
Damage
Dr. Web
Feasibility
Availability
The greatest threat to network security pose
copying files that have been changed during the day, without a backup mark
Opening of the standard account administrator group
opening standard user account
Main menu
unauthorized access, electronic eavesdropping and intentional or unintentional damage
What is Information Security?
the security of personal information
Total control Protocol
Super secure
measures to protect information from unauthorized access
Identification protocol
IT security
Measures to protect information from unauthorized access is called
Information Security
Destroy database
Desepticons invasion
security admin group
Private security
What is the name of intentionally distorted information?
Misinformation
Stop being information
Reliable information
Informative stream
Short circuit
What is the name of the information to which access is limited?
not available
Messages
Open
Confidential
illegal
This is a computer system on the Internet that is expressly set up to attract and "trap" intruders.
Dr. Web
Exploit
demilitarized zone
honeypot
Trojan horse
