Font size
Worksheets110-230
Total questions: 95
Worksheet time: 48mins
*!Cybersecurity. Loading viruses can infect
Загрузочные вирусы могут заражать
exe-файлы
OBJ-файлы
batch-файлы
COM-файлы
Boot-Strap программу
MS Excel. In $A2 address absolute is
MS Excel. В адресе $A2 абсолютным является
number of a line
name of the range
name of a column
number of a line and a name of a column
neither number of a line, nor a name of a column
*!Cybersecurity. Replicators
Репликаторы
Find a virus
Delete a virus
Transfer a virus
Destroy a virus program
Warning infection with a virus
*!Cybersecurity. Auditor programs
Аудиторские программы
Treat a disk
Use vaccines
Treat all computer
Delete only the infected files of Windows
Remember data on a condition of programs
*!Cybersecurity. Macro viruses are
Макровирусы — это
Network files
Package files
Dialogue files
Loading files
Macros
*!Cybersecurity. AVP is
AVP — это
graphics editor
anti-virus program
the program spreading virus
program of defragmentation
the program, the pressing the file for saving of the place on a disk
*!Cybersecurity. The computer virus is
Компьютерный вирус — это
text editor
graphic editor
programming language
the program damaging computer programs and data
the program which is carrying out start of the computer
#117
*!Cybersecurity. Distinctive features of a computer virus are
Отличительные признаки компьютерного вируса:
ease of recognition
considerable volume of a program code
need of start of the program from the user
ability to increase in a noise stability of an operating system
small volume; ability to independent start and repeated copying of code; creation of noise to correct operation of the comрутер
!How the computer can be infected a virus
Как компьютер может быть инфицирован вирусом
when loading drivers
when opening the internet
in case of the wrong loading
in case of execution of the infected program
when inserting the disc with the infected program
*!The computer virus is
Компьютерный вирус — это
the hidden programs which erase, but they aren’t removed
the program which protects the computer from harmful files
not readable data which are kept on rigid or on a floppy disk
programs which don’t give the chance to open data with the password
the program which breeds itself and does harm to the computer of the user and other objects located in network
!*The text "SYRYECUMT SSTEI" deciphered by method of simple swap will look as follows
Текст «SYRYECUMT SSTEI», расшифрованный методом простой перестановки, будет выглядеть так
«SEQURITY RISK»
«STORAGE DEVICE»
«SECURITY SYSTEM»
«INFORMATION SYSTEM»
«SECONDARY STORAGE »
*!The abbreviation designating interaction of business with the state
Аббревиатура, обозначающая взаимодействие бизнеса с государством
business-to-business
consumer-to-business
business-to-consumer
government-to-business
business-to-government
*!The abbreviation designating interaction of citizens with the state
Аббревиатура, обозначающая взаимодействие граждан с государством
consumer-to-business
business-to-consumer
consumer-to-consumer
consumer-to-government
government-to-government
*!Method how to obtain digital signature:
Метод получения цифровой подписи:
to register on Population service center website
to register on the website www.egov.kz
to enter a private office through e-mail
to set JavaScript and to get permission for registration
it is necessary to submit the application for obtaining the electronic digital signature (EDS) on www.egov.kz
*!For authorization on the Web portal of "Electronic government" the following data are necessary:
Для авторизации на веб-портале «Электронного правительства» необходимы следующие данные:
marriage certficate
e-mail address (e-mail)
number of the identity card
e-mail address (e-mail) and password of the user
personal identification number and password of the user
*!E-mail address of the electronic government web portal of Kazakhstan:
Адрес веб-портала электронного правительства Казахстана:
#136
*!Web portal of the electronic government of Kazakhstan was created in
Веб-портал электронного правительства Казахстана был создан в
12.04.2006
17.11.1997
12.04.2007
14.04.2007
20.07.2007
*!Second stage of the electronic government development in Kazakhstan
Второй этап развития электронного правительства в Казахстане
Interactive
Transaction
Information society
Democratic society
Information
*!First stage of the electronic government development in Kazakhstan
Первый этап развития электронного правительства в Казахстане
Interactive
Transaction
Information society
Democratic society
Information
*!Third stage of the electronic government development in Kazakhstan
Третий этап развития электронного правительства в Казахстане
Interactive
Transaction
Information society
Democratic society
Information
#140
*!External contour of the electronic government of Kazakhstan
Внешний контур электронного правительства Казахстана
G2C, G2B
G2B, G2G
G2G
G2C, G2G
B2G
!Internal contour of the electronic government of Kazakhstan
Внутренний контур электронного правительства Казахстана
G2C, G2B
G2B, G2G
G2G
G2C, G2G
B2G
*!National Program for Building up e-Government in the Republic of Kazakhstan for 2005-2007 was approved with Presidential Decree
Программа построения «E-government» в Республике Казахстан на 2005–2007 гг. была утверждена Указом Президента
No.1471 of November 10, 2004
No.995 of October 13, 2006
No. 991 of October 25, 2005
No. 1166 of August 18, 2003
No. 1459 of October 11, 2004
*!Program for bridging digital divide in the Republic of Kazakhstan for 2007-2009 was approved with Government Resolution
Программа по преодолению цифрового разрыва в Республике Казахстан на 2007–2009 гг. была утверждена постановлением Правительства
No.1471 of November 10, 2004
No. 995 of October 13, 2006
No. 991 of October 25, 2005
No. 1166 of August 18, 2003
No. 1459 of October 11, 2004
*!Е-learning system is
Система электронного обучения — это
credit system
pedagogical way
operating system
innovative approach
traditional teaching
*!Basic elements of distance learning
Основные элементы дистанционного обучения
evening courses
pedagogical education
correspondence conference
information transfer environment
international scientific and practical conference
*!Distance learning occupations forms are
Формы занятий дистанционного обучения:
discussion, debate
open lesson, master class
traditional lesson, conference
seminar, practical and laboratory classes
chat occupation, web occupation, teleconfer
*!System Internet of training E-learning
Система интернет-обучения (E-learning) — это
credit system
operating system
traditional training
pedagogical method
innovative approach
#151
*!Basic elements of distance learning
Основные элементы дистанционного обучения
evening course
pedagogical education
correspondence conference
information transmission medium
international scientific and practical conference
*!Law of Healthcare was accepted
Закон «О здравоохранении» был принят
March, 2009
October, 2009
February, 2010
September, 2008
September, 2009
#153
*!Composition of a health care system
Состав системы здравоохранения
only state organizations
organizations of public sector
state and non-state health sector
state and private medical organizations
public sector of health care and insurance companies
#154
*! Beginning of implementation of a uniform national health care system
Начало внедрения единой национальной системы здравоохранения
1st July, 2010
1st March, 2011
1st January, 2011
1st February, 2011
1st January, 2010
#155
*!Advantages of distant education
Преимущества дистанционного обучения
well without the Internet
constant presence at a lecture
constant presence at a conference
constant presence on practical occupations
it is available to all segments of the population
!Distance learning. Privileges of e-learning
Дистанционное обучение. Преимущества e-learning
high cost
mobility
response in writing
geographical limitation
the response in the oral form
#157
*!Second generation computers used value technology as
Компьютеры второго поколения использовали технологию на основе
transistors
microcircuits
vacuum tubes
integrated circuit chips
large scale integration chips
#158
*!First computer
Первый компьютер
IBM
BASM
MINSK
ENIAC
ZODIAC
*!Hard drive is
Жёсткий диск — это
zip disk
input/output
high capacity floopy disk
high capacity integral disk
the device of input-output for floopy discs
*!Operative memory is
Оперативная память — это
information containing on a hard disk
information containing on a floppy disk
device for direct perception of the information to the person
device for long storage of the information on magnetic disks or magnetic tapes
device which addresses regularly to machine during performance of operations
#163
*!In 32 Gbytes there are
В 32 Гбайтах содержится
224 bytes
222 bytes
235 bytes
32000 bytes
16 220 bytes
#164
*!Convert binary number 1001 into decimal system
Преобразовать двоичное число 1001 в десятичную систему
7
8
1
9
510
*!Multiplication of binary numbers 1011 and 110
Умножение двоичных чисел 1011 и 110
0011100
0000100
0100000
1000000
1000010
#166
*!Convert hexadecimal number 255 into decimal system
Преобразовать шестнадцатеричное число 255 в десятичную систему
333
531
343
211
597
*!Decimal number 2 in binary system is written as
Десятичное число 2 в двоичной системе записывается как
11
01
10
1001
1111
*!The sum of binary numbers 111011 101010 is equal to
Сумма двоичных чисел 111011 и 101010 равна
1100111
0111100
0101100
0011011
1100101
*!The multiplication of binary numbers 110 and 111
Умножение двоичных чисел 110 и 111
101100
111100
101110
111000
101010
#170
*!Why is mathematical coprocessor necessary
Зачем нужен математический сопроцессор
printing information
for recording data on cd
reading of the information
to help to basic processor in performance of mathematical operations
permanent storage of the information which is used at work in a computer
The modem and the fax-modem are used for
Модем и факс-модем используются для
conversation with users
effective work with office equipment
connections to satellite communication
information output on paper or on computer
exchanging information with other computers
Order of switching off of the computer
Порядок выключения компьютера
printer, system unit
system unit, monitor
system unit, monitor, printer
monitor, printer, system unit
system unit, printer, monitor
Вопрос #173
The lowest level software is
Программное обеспечение самого низкого уровня — это
BIOS
system
service
applied
operating
Вопрос #174
Data are
Данные — это
text
table
properties of objects
the registered signals
the data transferred between people
The binary number system concerns to
Двоичная система счисления относится к
numerical systems
positional systems
arithmetic notations
depositional systems
no numerical systems
The smallest unit of information measure
Наименьшая единица измерения информации
Hz
Bit
File
Byte
Character
1 byte is equal to
1 байт равен
4 bits
8 bits
16 bits
8 Kbyte
1 Kbyte
Device of temporary storage of information
Устройство временного хранения информации
adder
bufer
register
adapter
processor
Special program for control of the device
Специальная программа для управления устройством
driver
utilities
appendix
expanded memory
additional memory
The device which is managing operation of the computer and carrying out calculations
Устройство, управляющее работой компьютера и выполняющее вычисления
disk drive
graph plotter
microprocessor
random access memory
internal memory of the processor
MS Excel. Number of cells in highlited group A2:C4
MS Excel. Число ячеек в выделенной области A2:C4
2
4
6
8
9
MS Excel. Samples belong to two different populations if
MS Excel. Образцы принадлежат двум разным совокупностям, если
p<1,00
p<0,08
p<0,10
p<0,50
p<0,05
MS Excel. Samples belong to the same population
MS Excel. Образцы принадлежат одной совокупности, если
p<1,00
p<0,08
p<0,10
p<0,50
p>0,05
The size of the sample: 1,2,8,7,5,6,6,8
Объём выборки: 1, 2, 8, 7, 5, 6, 6, 8
1
2
8
7
9
The size of the sample: 1,2,3,7,5,6,6,3,1,2
Объём выборки: 1, 2, 3, 7, 5, 6, 6, 3, 1, 2
3
7
12
6
10
The size of the sample: 1,2,8,7,5,6,6,8,1,2,3,4
Объём выборки: 1, 2, 8, 7, 5, 6, 6, 8, 1, 2, 3, 4
1
2
7
11
12
The significance level which is applied in medicine
Уровень значимости, применяемый в медицине
1
0,95
0,005
0,05
—
MS Excel. Confidence level which is applied in medicine
MS Excel. Уровень доверия, применяемый в медицине
1
0,05
0,025
0,95
0,5
MS Excel. The mode of a given sample 1,2,3,7,5,6,6,8
MS Excel. Мода выборки 1, 2, 3, 7, 5, 6, 6, 8
1
2
7
6
10
MS Excel. The mode of a given sample 1,5,3,5,5,6,6,3,1,2
MS Excel. Мода выборки 1, 5, 3, 5, 5, 6, 6, 3, 1, 2
5
7
6
1
3
MS Excel. The mode of a given sample 1,2,8,2,5,6,2,8,1,2,3,4
MS Excel. Мода выборки 1, 2, 8, 2, 5, 6, 2, 8, 1, 2, 3, 4
1
2
7
8
12
MS Excel. В анализе данных выступают в роли столбца
constants
researched values
character variables
parameters
values which accept variables
MS Excel. A basic element of spreadsheets is
MS Excel. Основным элементом электронных таблиц является
table
a line
a sheet
a column
a cell
MS Excel. What cell in Excel is active
MS Excel. Какая ячейка активна в Excel
any cell reflected the screen
the active cell in excel is not present
a cell in which you carry out calculations
the cell, which contents is displayed in a line of formulas
a cell which specifies the cursor
MS Excel 2007. The group of the diagram is located on the tab
MS Excel 2007. Группа «Диаграммы» расположена на вкладке
view
home
references
page layout
insert
MS Excel. When the background formula checker finds a rule that might be in violation, it places a ____ triangle in the cell
MS Excel. Когда фоновый проверщик формул находит возможное нарушение, он ставит ____ треугольник в ячейке
green
yellow
blue
red
grey
MS Excel. To add borders to a range of cells, right-click the selected range, select ____ on the shortcut menu, then click the border tab
MS Excel. Чтобы добавить границы диапазону ячеек, щёлкните правой кнопкой по выделенному, выберите ____ и перейдите на вкладку «Границы»
cut
borders and shading
format cells
border contents
insert
The relative address in Excel, is
Относительный адрес в Excel — это
such address is not present
the address containing cyclic references
the address to which it is impossible to refer in the formula
the address depending on type of data in a cell
the address which is corrected at moving formulas from one cell to another
MS Excel. The element of the diagram showing the name of markers of data
MS Excel. Элемент диаграммы, отображающий названия рядов данных
a file
a kind
a command
a legend
a format
MS Excel. In a line of formulas it is showed
MS Excel. В строке формул отображается
figures
symbols
value of cells
the address of a cell
the formula
MS Excel. For construction of schedules and drawing up of formulas it is necessary to use the master
MS Excel. Для построения диаграмм и составления формул необходимо использовать мастер
functions
diagrams
drawing
reports
forms
MS Excel. The document created in Excel, is called
MS Excel. Документ, создаваемый в Excel, называется
file
spreadsheet
sheet
workbook
document
MS Excel. Use the ____ function to determine the lowest number in a range
MS Excel. Используйте функцию ____, чтобы определить наименьшее число в диапазоне
range finder
low
find
search
min
MS Excel. The ____ on a worksheet is one in which you can enter data
MS Excel. ____ на листе — это ячейка, в которую можно вводить данные
cell
active cell
reference cell
absolute cell
home cell
MS Excel. Statistics studies
MS Excel. Статистика изучает
single signs of the studied phenomenon
properties of the studied phenomenon
single phenomena
mass phenomena
periodic events
MS Excel. Binary file format (BIFF12) in Excel
MS Excel. Двоичный формат файла (BIFF12) в Excel
.xlsx
.xltx
.xls
.xlsm
.xlsb
MS Excel. The term "statistics" was introduced by
MS Excel. Термин «статистика» был введён
A. Byushing
G. Akhenval
A. Quetelet
F. Galton
G. Konring
The size of a worksheet in Excel 2007/2010
Размер листа в Excel 2007/2010
1 048 576 rows and 16 384 columns
66 536 rows and 512 columns
65 536 rows and 256 256 columns
65 536 rows and 16 384 columns
1 626 536 rows and 165 484 columns
MS Excel. It is possible to make changes to the created chart
MS Excel. Возможно вносить изменения в созданную диаграмму
in plot area
in the added legend and data sheets
in data rows
in a legend
by sight the created chart
MS Excel. Samples belong to the same population
MS Excel. Образцы принадлежат одной совокупности, если
p<1,00
p<0,50
p<0,10
p>0,05
p<0,08
MS Excel. Possible options of number format of the date
MS Excel. Возможные варианты формата даты
14/13/1999
30/32/1996
05.12.1996
30/02/2015
32/08/2014
MS Excel. By default, Excel positions text in a cell
MS Excel. По умолчанию Excel выравнивает текст в ячейке
left-aligned
right-aligned
centered
justified
randomly
MS Excel. The number of worksheets that you can add to a workbook is
MS Excel. Число листов, которое можно добавить в книгу,
100
1 067 456
65 536
256
Limited by the amount of memory on the computer
MS Excel. A mistake in record of the formula of the SUMS (C7:C10)
MS Excel. Ошибка в записи формулы SUMS(C7:C10)
such function is not present
the wrong range of cells is set
insufficient quantity of arguments
there is no a sign "=" at the beginning of the formula
there are no one more brackets near function of the sums
MS Excel. The range of cells B2:B10 contain numbers 44, 64, 52, 37, 82, 52, 32, 93, 48. Show result of MEDIAN(B2:B10)
MS Excel. В диапазоне B2:B10 содержатся числа 44, 64, 52, 37, 82, 52, 32, 93, 48. Результат MEDIAN(B2:B10)
56
93
52
9
32
In electronic spreadsheets when writing a formula are used
В электронных таблицах при записи формулы используются
text
letters
names of cells
names of tabs
names of subgroups
Value of correlations in statistics
В статистике корреляция означает
function
connection
equation
relation
ratio
The absolute address in Excel, is
Абсолютный адрес в Excel — это
such address is not present
the address, not dependent on type of data in a cell
the address to which it is possible to refer in the formula
the address of the cell containing constants
the address which does not vary at moving formulas from one cell to another
MS Excel. What action will be done by formula =PRODUCT(F8:F9)
MS Excel. Какое действие выполняет формула =PRODUCT(F8:F9)
divides value of cell F8 on F9
multiplies values in cells F8 and F9
summarizes values in cells F8 and F9
will give out a mistake as such formula is not present
multiplies arguments in brackets
