WorksheetsPage 1
Total questions: 150
Worksheet time: 1hrs 15mins
The spreadsheet is set. In cell D3 the formula A1∗B2−3 is written down. What will be the result of calculation?
1
9
17
15
27
How long is information stored in external memory?
5 years
half a year
long time
1 year
while a computer is used
What is the key activates the digital buttons located on the right side of the keyboard?
Scroll Lock
Num Lock
Caps Lock
Enter
Back Space
What combination of words was the word INFORMATICS formed of?
cybernetics and telematics
automation and mathematics
information and science
information and automatics
information and mathematics
What type of network include the Internet?
Local
National
Corporate
International
Global
What is ASCII?
American Standard Code for Information Interchange
a lossless image compression algorithm
a hardware bus interface
an operating system
What is capacity of video memory of a computer with configuration AMD Athlon II X4 610e 2.4GHz / 4 GB DDRIII / 1000 GB SATA 3G (7200 rpm) / DVDRW / ATI Radeon HD 5450 (512 MB) / 20" LED 1600 × 900 / Windows 7, 64 equal to?
1000 GB
3 GB
64
512 MB
4 GB
What is the operating system?
UNIX, Windows, Notepad, LINUX
MS-DOS, Windows, MacOS, LINUX
UNIX, CorelDraw, Paint, MS-DOS
Windows, Word, Paint, Excel
LINUX, Access, MS-DOS, Norton Commander
Specify the row of programming languages
Delphi/Turbo Pascal
C++/WinRAR
Norton Commander/Fortran
BASIC/MS-DOS
Delphi/Windows
What is a server?
An operating computer of network
Monitors connected to network
Antivirus
Office program
A special device in network
How many KB will take place in the memory together an audio file of volume 3 MB, a drawing file of volume 200 KB, and a text file of volume 2048 bytes?
3272
3072
3274
2252
2248
What device of a computer does designations CPU Intel LGA1155 Core i5 2400 Box (Sandy Bridge, 4-Core, 3.1-3.4GHz, 6Mb L3kes) (BX80623I52400) belong to?
hard disk
processor
motherboard
has no relation to the computer
system unit
What is the relevance of the information?
determines the quality of the information about the object and event
the interface of search and use of the information
the degree of compliance of the information with the current time
correct characteristic of the information
the method making information in a logical meaning
What is number 37 of octal notation equal to at its representation in hexadecimal notation?
1F
9A
F1
33
2D
What is the keyboard shortcut uses to close the window in Windows?
Alt+Spacebar
Enter
Alt+Tab
Alt+F4
Alt+Esc
The information is processed on a computer is encoded ...
symbols
8-ary codes
only zeros and ones
numbers and symbols
letters
Which of the following defines the number of bits of information processed for 1 clock cycle?
BIOS Memory
word length of the processor
processor memory
RAM dimension
How many bits are there used for recording of one hexadecimal figure?
10 bit
4 bit
8 bit
16 bit
2 bits
In cell E3 there is written formula = D3 + A$2. How will this formula be changed after moving into cell F3?
=E3 + A$2
=E4 + B$2
=E3 + A$3
=E3 + B$2
=E3 + E4
Which of the statements: "The computer can not be operated without ... a) the processor; b) the internal memory; c) the printer; d) the external memory; e) the scanner" is correct:
a, b, d
a, b, c
b, c, d
c, d, e
b, e, d
What is computer internal memory?
RAM and ROM
RAM and CD
DVD and ROM
BIOS and Flash memory
floppy disk and DVD
100 KB = ? bit
100×220
100×23
100×223
100×210
100×213
Which of the keys is functional?
Shift
Enter
End
Tab
F3
How many bytes is 1 exabyte (EB)?
232
260
224
250
264
Unit of resolution of a printer
number of pages printed in a second
frequency
quantity of steps
quantity of symbols printed in a second
number of dots per inch
What is frequency of the processor of a computer with configuration (Intel Core2 Duo E7300 (2x2.66GHz; FSB1066MHz; 3MB) /4096Mb /750Gb / ATi HD 5450 1Gb /DVD-RW /cardreader / WI-FI адаптер PCI /ATX 500W) equal to?
2*2,66 Hz
7300
5450
1066 MHz
500
Who created the mathematical logic based on the binary number system?
Ch. Babbage
G. Leibniz
A. Lovelace
J. Boole
B. Pascal
Information is transferred as … and stored as …
signals … data
files … folders
graphics … text
programs … commands
The menu is used to store the addresses of pages in Internet Explorer:
Save
Pages
Edit
Tools
Favorites
What form is the information processed in by the processor?
in binary code
in decimal code
16 hex code
in quaternary code
in octal code
Which of the following commands doesn't contain menu “File”?
Cut
Save
Open
New
In the spreadsheet shown, cell A1 contains -5, cell B1 contains the formula =A1*2, and cell C1 contains the formula =A1+B1. What will be the result of calculation in cell C1?
−15
5
−3
15
0
In cell E3 there is written formula = D3 + A$2. How will this formula be changed after moving into cell E4?
=D4 + A$2
=D3 + A$2
=E3 + A$3
=E4 + B$2
Which operating system is single-process?
Mac OS
MS DOS
WINDOWS 3.1
WINDOWS 8
UNIX
Information types in informatics
true and false
analog and digital
reliable and valid
full and incomplete
objective and subjective
How many symbols is it possible to code in 1 byte?
65536
256
512
128
255
What figures can contain 1 bit?
0
1 and 0
2
0 or 1
1
What is capacity of video memory of a computer with configuration (Intel Core i5-650 (2x3200MHz; 4096k) /4096Mb /1000Gb /1280Mb GeForce GTX 470 /DVD-RW /ATX 550W) equal to?
1280 Mb
4096 Mb
4096 K
1000 Gb
3200 Mz
It may be two files with the same name?
May be, if they are in different folders
It is possible, there is no limit
Cannot be
How does number 1000101111 of binary notation look at its representation in decimal notation?
567
559
495
557
439
3 KB 772 bytes + 2 KB 252 bytes = How many bytes?
6400 bytes
2800 bytes
3754 bytes
6144 bytes
2048 bytes
How many symbols can a file name contain in Windows operating system?
3
64
255
32
16
Technical devices of computer
Word, Access, Internet
Excel, CD-R, Notepad
Windows, Материнская плата, Монитор
scanner, mouse, paint
keyboard, printer, monitor
Without which device can a computer not work?
Mouse
Drive
RAM
Printer
Microphone
Specify external memory devices
BIOS, CD
RAM, ROM
FDD, VGA, BIOS
What is the symbol placed between the name and the file extension?
Line
Comma
Colon
Point
Lower line
Which of the statements: "A computer can be operated without ... a) the processor; b) the internal memory; c) the printer; d) external memory; e) the scanner" is false:
c, d, e
a, b, d
b, e, d
b, c, e
a, c, d
Which memory is erased all the information at shutdown?
With the permanent memory
With the RAM
From the hard drive
From the BIOS
From the CMOS
What is a modem?
The mail program
The network protocol
The Internet Server
The program
The technical equipment
Which of the statements: "The computer can be operated without ... a) the processor; b) the internal memory; c) the printer; d) the external memory; e) the scanner" are correct:
c, e
a, b
b, c
c, d
b, e
Type of the address $A6 in MS Excel
absolute for a column, relative for a line
absolute both for a line and for a column
relative both for a line and for a column
relative for a column, absolute for a line
relative for a column
What is the BiOS?
Life Program
Programming Language
Basic Input-Output System
Interactive shell
operating system command language
Which of the statements are true: a) The drives on the disks are part of the computer's external memory; b) It is not possible to accidentally erase the information on the disc; c) When the computer is turned off, the contents of the RAM are saved; d) The plotter is an input device. e) The processor's cache memory is not part of the internal memory;
d, e
a, e
a, b
b, c
c, d
Which of the following records is not correct for addressing cells in Excel?
R4C3; R5C4
A 3; D$5
C_1; D_5
R[4]C[3]; R[5]C[4]
C4; B5
Which of the statements are false: a) The computer can not be operated without a CD-ROM; b) Arithmetic logic device is not part of the processor; c) The cache is a very fast memory with a small volume;
a) The computer can not be operated without a CD-ROM;
b) Arithmetic logic device is not part of the processor;
c) The cache is a very fast memory with a small volume;
Main property of random access memory
possesses boundless capacity
broadcasts information
stores information temporarily
stores information long
serves for information transfer to other computers
Which of the statements are false: a) The computer can not be operated without a DVD-ROM; b) When the computer is turned off, the contents of the RAM are erased; c) The cache is a very fast memory with a small volume; d) Plotter - a device for entering graphic images into a computer;
a, b
a, d
a, c
b, c
b, d
Which of the following does not concern applications?
games
database management
operating system
dictionaries and translators
spreadsheet
What monitors are used in portable computers?
plasma
on the basis of ELT
none of 3 types
LCD
all of 3 types
Which file has the largest information capacity?
1 minute video
black and white image 100 × 100
1 page text
color image 100 × 100
1 minute audio clip
What is a hypertext?
Very large text
The text typed on a computer
The text which can make the transition on the dedicated label
The printed text
Protocol
What is the capacity of cache memory of a computer with the configuration: PS.vbhec.007; Intel Atom D525 (1.8GHz/1MB); nVidia GeForce GT218; RAM 1GB ddr3; HDD 160GB; VGA+HDMI; Gigabit LAN; 4‑in‑1 reader; COM port; VESA mount; Linux?
1 GB
218
1 MB
160 GB
1,8
What can be used as a hypertext link to?
Just a word or group of words
Only videos
Only photo and picture
Only the word
Any word or picture
Using the shown menu, which number corresponds to saving of the file? The menu items are labeled: 1 Info, 2 New, 3 Open, 4 Save, 5 Save As, 6 Print, 7 Share, 8 Export, 9 Close.
1
3
4
5
9
Using the shown menu, which number corresponds to opening of the file? The menu items are labeled: 1 Info, 2 New, 3 Open, 4 Save, 5 Save As, 6 Print, 7 Share, 8 Export, 9 Close.
1
3
4
5
9
Using the shown menu, which number corresponds to closing of the file? The menu items are labeled: 1 Info, 2 New, 3 Open, 4 Save, 5 Save As, 6 Print, 7 Share, 8 Export, 9 Close.
1
3
4
5
9
Using the shown menu, which number corresponds to saving the file under a different name? The menu items are labeled: 1 Info, 2 New, 3 Open, 4 Save, 5 Save As, 6 Print, 7 Share, 8 Export, 9 Close.
1
3
4
5
9
What software does Windows use for operations on files and folders?
Windows Explorer
Winword
Paint
Internet Explorer
Excel
What type of memory uses magnetic recording of information?
CD
HDD
Flash-memory
Blu-ray disk
DVD
Specify the icon assignments in the TABLE TOOLS in MS Word. Using the ribbon image with numbered icons 1–6, choose the option that correctly pairs: a) Line type; b) Border color; c) Fill color; d) Line thickness.
(a-2), (b-4), (c-1), (d-3)
(a-2), (b-5), (c-6), (d-2)
(a-1), (b-4), (c-5), (d-3)
(a-4), (b-1), (c-5), (d-6)
(a-1), (b-4), (c-3), (d-4)
Which of the following operations is used if it’s necessary performance at least one of the conditions?
AND
NOT
XOR
OR
any
Using the menu shown, select the option that correctly pairs each action with its numbered command: a) Close of the file, b) Saving of the file, c) Open file, d) Save an existing file with a different name.
A) (a-9), (b-1), (c-3), (d-4)
B) (a-9), (b-4), (c-3), (d-5)
C) (a-9), (b-4), (c-3), (d-4)
D) (a-8), (b-1), (c-2), (d-4)
E) (a-8), (b-4), (c-3), (d-2)
What does a system unit consist of?
A) monitor, motherboard, video card
B) motherboard, processor, video card, hard drive
C) hard drive, cash - memory, BIOS, keyboard
D) video card, plotter, processor
E) motherboard, hard drive, printer,
What is the resolution of the monitor in the configuration described as HP S2031A (20-inch, 1600 x 900), Intel Pentium E5800 3.20 GHz, 2 GB DDR3 SDRAM, 320 GB SATA (7200 rpm), Intel Graphics Media Accelerator 4500MHD, Realtek RTL8103EL 10/100 Ethernet, 6 USB 2.0?
1600×900
1920×1080
1366×768
1280×1024
Which device isn't contained in a computer in accordance with fon Neumann?
control unit
arithmetic-logic device
external memory
communication device
random access memory
The main part of the computer is responsible for processing information
Converter
Container
Controller
Conveyor
Processor
Which device is called the "brain" of the computer?
ROM
CPU
RAM
HDD
BIOS
For long-term storage of information is
Processor
Memory
Permanent memory
External Memory
cache memory
What is a computer generation defined by?
quantity of the commands executed by a computer
architecture of a computer
date of emergence and memory capacity
capacity of random access memory
element base
What are called all the programs loaded into the computer?
drivers
software
applications
operating systems
utilities
What is a clock frequency?
quantity of commands
binary code for addressing random access memory
rotation speed of a hard disk
number of the operations which are carried out in unit of time
quantity of bits
Unit of clock frequency
Hertz
Byte/sec.
Pixel
Bit/sec.
Hertz/sec.
What is a cache-memory of the processor?
part of random access memory
a memory increases work speed of the processor
a memory accelerating data reading from random access memory
a memory connecting a hard disk with a RAM
a memory accelerating common between RAM and monitor
What is a computer virus?
One of standard programs
Special program
Has no relation to a computer
Illness
Special device
How does number 101101010 of binary notation look at its representation in decimal notation?
503
362
518
525
449
How long will it take to the modem, transmitting data at 2880 bps, to transfer 3600 bytes of information?
16 sec
121 s
10 sec
124 sec
What memory is used to accelerate the exchange of information between RAM and the processor?
cash memory
Video
CMOS
Floppy Disk
CD
What does the red line underlining words specify on in a text?
On a grammatical mistake
On a stylistic error of a sentense
On a spelling mistake
On a morphological mistake
On a phonetic mistake
Which of the following commands allows to pass to the end of a document?
Ctrl + End
PageUp
End
PageDown
Home
Which term means set of technical devices of a personal computer?
Software
Hardware
Drivers
Adapter
HDD
The main function of the CMOS
memorizes the configuration of your computer, the time and date
provides transmission of numbers into the microprocessor
configures RAM
performs the function of RAM
provides the setting of voltage in personal computers
Select the line where the information units are arranged in ascending order
megabyte, terabyte, gigabyte
gigabyte, megabyte, terabyte
terabyte, megabyte, gigabyte
megabyte, gigabyte, terabyte
What is capacity of random access memory of a computer with configuration Intel Pentium G620 (2.6 GHz) / MB Asus P8H61-M LE / RAM 4096 Mb DDR III 1333 GHz Kingston / HDD WD 500 Gb 7200 rpm / Video GF GT520, 1024 Mb / DVD-RW / Card-Reader / sound on board / case Winard equal to?
4 GB
1024 MB
500 GB
620 MB
1333 MB
How does the font size for printing change if you increase the text size using the View/Zoom command in MS Word?
Decreases in size 2 times
Font size becomes 200 pt
Does not change the font size
Increases to 200 pt
The size is increased by 2 times
What memory is the program that tests a computer at its turning on located in?
ROM
HDD
RAM
Cache
FDD
What is the smallest object that is used in a text editor?
Screen point
Paragraph
Symbol
Word
Sentence
Which device turns a digital signal from a computer into an analog signal for a phone and vice versa?
Transformer
Processor
Modem
Server
Lock
What type of random access memory does a computer have with configuration Intel Celeron 430 (1.8 GHz) / MB Asus P5G41T-M LX / RAM DDRIII 1024 Mb 1333 MHz?
DDR3
DDR2
SDRAM
DDR4
Kingston / HDD Seagate 250Gb 7200rpm SATA-III / video on board / sound on board / case 450W ATX?
MB Asus P56414-MLX
Sata III
INTEL® Celeron™
DDR III
Seagate
What ensures the management of hardware devices connected to the computer?
RAM
HDD
FDD
driver
VGA
What is the name the team HTML?
Block
tag
Hyperlink
Protocol
Attribute
One of the claims of the IP-address is erroneous:
IP-address in the network consists of two groups of numbers, each of which does not exceed 256
IP-address has a length of 4 bytes
When separating the IP-addresses of the basis of a hierarchical principle
IP-addresses are divided into 4 classes
Each computer on the Internet has a unique IP-address
can be transmitted by electronic mail:
Information and attached to the letter file
Only files
Only news
Only videos
Only photos
Which of the following files has the least dimension?
audio clip in 1 minute
1 page of text
video in 1 minute
In accordance with the functions software shares on
system software, maintenance program, programming languages
system software, applied programs, programming languages
problem-oriented and object-oriented programs
maintenance program, service program, antiviruses
testing program, applied programs, drivers
What operating system is established of a notebook with configuration 15.6" Notebook TOSHIBA Satellite L750-12G-RU i3 2310M/4/640/DVD-RW/G T525M/WiFi/BT/Win7HP?
Windows 7
Satellite
Vista
Windows XP
Norton
What was translated wrong for the spreadsheet Excel?
row - строка
column - столбец
cell - ячейка
book - книга
paper - страница
What is the uncertainty of information called?
Distropiya
Entropy
Cryptography
Interface
Ecliptic
What is frequency of the processor of a computer with configuration TAY Intel Original Ctelеron220 (FSB 533MHz, 1,2GHz, 512Kb)/ASUS Socket-775: i945GC, ITX-220/1024Mb DDR-II PC5300/160.0Gb/DVD+-RW/MIDI 350W equal to?
220 GHz
775 Hz
533MHz
512 KB
1,2 GHz
Winchester symbol
A
B
CD ROM
COM
C
Whose name connected the term "Algorithm"?
Shannon
Pythagoras
Al Khoresm
Pascal
Khayyam
Minimum unit of information measure
Kb
Mb
byte
bit
Mbit
What is OLE technology?
Changing the properties of an object
Ensure collaboration and exchange objects with other programs
Removed copy of the object
All answers are correct
Providing relief of the object with other programs
Which of the statements "The computer can not be operated without ... a) the processor; b) the internal memory; c) the printer; d) external memory; e) the scanner" is false
c, e
b, c
a, b
c, d
b, e
Which memory contains the test program of a computer?
ROM
RAM
Cache
Hard disk
Specify random access memory
CMOS
BIOS
RAM
HDD
ROM
Which of the following is a plotter?
output device
external memory
device inputting
internal memory
printer for various graphic objects
What is not part of the operating system?
operating system kernel
loading program
basic input/output system
test program
drivers
Which of the following is an output device?
keyboard
scanner
laser printer
BIOS
Digitizer
What is an organization providing a user with Internet access called?
Domain
Server
Provider
Host
Load the program, this ...
Copy the program from operational memory to the external memory
Copy the program from external memory to operational memory
Transfer the program from cache to CPU registers
Save the program to external memory from the CPU
Which expression represents the amount of information in 1 byte?
00112031
00110101
ABCD
0011
All answers are correct
What is a piece of text?
Some string
A sequence of characters
All answers are correct
Some paragraph
Some word
How many bytes is 1 zettabyte (ZB)?
248
224
250
272
270
Which of the following devices is not necessary for connection to Internet?
Modem
Telephone line
Monitor
Computer
Printer
What is considered the minimal element of a spreadsheet?
page
book
cell
column
string
What operating system is used by Apple computers?
Windows
Unix
Specify the smallest amount of information
512 MB 500 bytes
512 MB 5300 KB
0.5 GB
0.5 GB 53 MB
512 MB 53 KB
Select the buttons corresponding to the commands in the MS Word program on the “TABLE TOOLS”. a) Sorting in ascending b) Split Cells c) Alignment d) Distribute columns
A) (a-9), (b-4), (c-7), (d-6)
B) (a-8), (b-5), (c-6), (d-7)
C) (a-9), (b-3), (c-8), (d-6)
D) (a-8), (b-3), (c-6), (d-7)
E) (a-8), (b-4), (c-7), (d-5)
What is frequency of the processor of a computer with configuration HP P3130M (WU403ES) Intel Core i7 2.93 GHz, 6 Gb DDR3, 750 Gb (SATA, 7200 d/daq), DVD- SATA SuperMulti LightScribe, Nvidia GeForce GT 420, 2 Gb, Gigabit Ethernet, 8 USB 2.0?
750
420
7200
2.93
450
What is the minimum set of software tools, provides computer work?
Application Software
System Software
Program shell
All answers are correct
What is dimension of the display (in cm) of a notebook with configuration 17.3" Hoyr6yK Acer Aspire 7750G-2434G64Mnkk i5 2430M/4/640/DVD-RW/HD6850M/WiFi/BT/Win7HB equal to?
17,3
34
43,9
173
24,34
What type of memory your computer uses to temporarily store data?
ROM
EPROM
EEROM
RAM
EROM
The information of 1 byte, this is ...
Random set of 10 zeros and ones
Random set of 8 zeros and ones
Random set of 8 characters
Random set of 4 numbers
All answers are correct
What is a domain?
program, which provides the connection between computers
Unit information
A device that provides a connection between computers
The speed of information transfer
Part of your computer network addresses
What is capacity of RAM of a computer with configuration Core i7-2600/4096 DDR3-1600/2000GB SATA/GeForce GTX 490 512 Mb equal to?
1600
490
512
4096
2000
What will be the result in cell G1 after calculation of the autosum shown on the drawing?
The sum of the numeric values in the referenced row
The average of the numeric values in the referenced row
The maximum of the numeric values in the referenced row
The count of the numeric entries in the referenced row
Refer to the spreadsheet image showing the formula SUM(A1:D1) applied to row 1. What is the result returned by this formula?
11
21
10
0
8
What software is included with Microsoft Office?
Power Point
SQL server
Promt
Visual FoxPro
No one
Main devices of a personal computer?
system unit, scanner
mouse, monitor, system unit
system unit, printer, scanner
system unit, monitor, mouse, printer
system unit, monitor, keyboard
Specify the row of programs, located in the folder "Accessories" of Windows operating system
Calculator, NotePad, WordPad, Paint
WordPad, Paint, Turbo Paskal ,C++
Corel Draw, Photoshop, Front Page
Pascal, Basic, Delphi, HTML
Word, Excel, Power Point, Access
Doesn’t include to the Utilities
Antivirus program
Test program
Archive program
Office program
Program driver
Find the wrong statement of local and global networks
in the local network servers perform network resources allocation function
in global networks spread over large geographic areas
on the local network may be several working groups
What of the listed below parameters is the main indicator of quality of a personal computer?
number of the monitors connected to a computer
number of the operations which are carried out in unit of time
capacity of electric power consumed by a computer
number of the input devices which are connected to a computer at the same time
number of the output devices which are connected to a computer at the same time
Specify the true classification of operating system of number users.
command and objectoriented
local, network
uniprocessor, multiprocessor
single-user, multiuser
batch processing, divided by time, in real-time scale
What is frequency of the processor of a computer with configuration HP Pro3010 (WK044ES) Microtower PC CPU Intel Pentium Dual Core E5400 2,7 GHz, L2 2Mb, FSB 800MHz, 2Gb DDR3 (1333MHz), 320Gb SATA 7200rpm, SATA DVD±RW LightScribe, Intel X4500HD PCI Express x16 PCI Express x1-3slot, PCI Express x16-1slot, FreeDOS equal to?
1333 MHz
7200 Hz
800 MHz
3010 MHz
2,7 GHz
What does contain a file with the extension .jpg?
music
video
photo
spreadsheet
text
Which program has the extension .ppt?
Adobe Acrobat
Corel Draw
Power Point
Photoshop
Quarkxpress
The primary name on the Internet:
domain name
IP address
MAC address
file path
How many bits are there in the word INFORMATICS?
8
10
88
11
12
