Вопрос №10

In general, to which of type applications does firewall software belongs?

Utilities

Network firewalls

Drivers

Application software

Malware software

Вопрос №11

The response of the operating system to user actions is displayed by ___ and _______.

Graphical interfaces / output devices

System installers / perepherial devices

Software installers / storage devices

Network equipment / utilities

Firmware software / storage devices

Graphical interfaces /perepherial devices

Operation system / utilities

Вопрос №12

Microsoft Excel files will be saved in the following extension: .exl

True

False

No, the file will be saved in .mxls extension

No, the file will be saved in.excx extension

No, the file will be saved in.xlsx extension

No, the file will be saved in.tbl extension

No, the file will be saved in.org extension

Вопрос №13

What does key combination «Ctrl+Esc» do?

Opens the “Start” Menu

Closes all programs

Ends a non-responsive program

Same as the “win” ( ) key

Switching to another running programm

Вопрос №14

What happens when you press F12 in office applications (commonly)?

The file will be saved and automatically closed

Same as pressing Alt + f4

Same as pressing Alt + Tab

A file “format” window will open

A file “save” window will open

A file “parameters” window will open

Same as pressing “Save as” command

Вопрос №15

The tables of the relational database (DB) may contain:

Extremely homogeneous information (only one type of data)

Text only

Heterogeneous information (different types of data)

Only logical quantities

Neither of above

Text, numeric, hyperlinks data

---

Вопрос №16

Which of the following is NOT a part of a common database?

Tables

Records

Fields

Worksheets

Logical drives

Primary key

Table relationships

Вопрос №17

The feature of the “Counter” field in Microsoft Access is that
it has the property of auto fill in
the data is not stored in the field itself, but in another place, but only the pointer is stored in the field
the maximum size of the number stored in it cannot exceed 255
it is intended to fill in with integers data
it is intended to fill in with hyper-links data
each new record will be automatically filled with next in order number ( increased by 1)

Вопрос №18

In order to present the chart as an independent sheet in a workbook, you must:

Select a chart - select “On a separate sheet” in the “Chart” context menu

Select a chart - in the context menu or the «Designer» menu, select “On a separate sheet”

Copy chart - open new sheet - paste chart

Copy the chart - on the new sheet select "Paste" - "Chart"

Select chart – press ctrl+A+→

Select a chart – select “On a separate sheet” in the context menu or the «Designer» menu of the chart properties

---

Вопрос №19

The names of the days of the week are entered in consecutive cells of the Excel table column: “Monday”, “Tuesday”, “Wednesday”. The last two cell is active. The mouse points to the lower right corner of the list cell, while the plus sign is visible below the right corner of the cell. What happens if you “stretch” the mouse a couple of cells down?

The following two cells will be filled with the text: "Wednesday".

The next two cells will be formatted in the same way as the last cell in the list, and their contents will remain empty.

This will copy the contents of the active cell.

The next two cells of the column will be filled with the continuation of the days of the week list: “Thursday”, “Friday”, etc.

Nothing, cells will remain empty

A program error will occur

Following cell will be filled with “Thursday”, “Friday” and so on.

Вопрос №20

The addresses of which rows and columns when copying the formula =$A23 + C$21 will NOT be changed:

A

C

21

23

A23

C21

Вопрос №21

The addresses of which rows and columns when copying the formula =$F15 + K$44 will be changed:

F

K

15

44

K44

F15

Вопрос №22

The addresses of which rows and columns when copying the formula =G$3 + $H21 will NOT be changed:

H

G

3

21

G3

H21

Вопрос №23

The addresses of which rows and columns when copying the formula =$F15 + A$44 will be changed:

F

15

A

44

A44

F15

Вопрос №24

ч	The addresses of which rows and columns when copying the formula =$G$3 + $H$21 will NOT be changed:
0	H
0	G
0	3
0	21
1	G3
1	H21

---

Вопрос №25

The addresses of which rows and columns when copying the formula =$F$15 + $A$44 will be changed:

F

15

A

44

A44

F15

Вопрос №26

The cell A1 contains “F$4+$C$1” (without quotes). A User copies this cell to 1 row down (to A2). The addresses of which rows and columns (in F$4+$C$1 expression) will be changed in result and what will be displayed in A2 cell?

F

4

None of the above

C

F$4+$C$1

Cells F$4 and $C$1 addition result

Вопрос №27

The cell A1 contains “H$3+$G$3” (without quotes). A User copies this cell to 1 row down (to A2). The addresses of which rows and columns (in H$3+$G$3 expression) will be changed in result and what will be displayed in A2 cell?

H

G

None of the above

3

H$3+$G$3

Cells H$3 and $G$3addition result

Вопрос №28

The cell A4 contains “A$14+$C101” (without quotes). A User copies this cell to 1 row down (to A5). The addresses of which rows and columns (in A$14+$C101 expression) will be changed in result and what will be displayed in A5 cell?

F

4

None of the above

C

A$14+$C101

Cells A$14 and $C101addition result

Вопрос №29

The cell B12 contains “B$24+F$11” (without quotes). A User copies this cell to 1 row down (to B13). The addresses of which rows and columns (in B$24+F$11 expression) will be changed in result and what will be displayed in B13 cell?

F

4

None of the above

C

B$24+F$11

Cells B$24 and F$11 addition result

Вопрос №30

To confirm the entry in a Microsoft Excel cell user have to _____ .

Press the enter key

Press F key

Press A key

Press the TAB key

Press A+End key

Вопрос №31

---

Constructing the formula, you have to enter the cell reference. What do you should do for that?

Click on the desired cell with the left mouse button

Press F4

In the formula bar, call the context menu

Press TAB while on the desired cell is selected

Manually type cell address inside formula

Вопрос №32

In cells A1 and B2, the numbers 24 and 12 are entered, respectively. In cell C1 entered: “A1/B1”. What will be displayed in cell C1 as result?

2

“A1/B1”

#MISTAKE

#VALUE

Text message “A1/B1”

48

Вопрос №33

In cells A1, C1 and C3, the numbers 150, 30 and 15 are entered, respectively (A1 = 150, C1 = 30, C3 = 15). In cell B1 entered: “=C3” and in A2: “=A1/B1”. What will be displayed in cell B1 as result?
30
10
5
#Error
15
Same as in C3
Same as in A2
Same as in C1

Вопрос №34

In cells A1, C1 and C3, the numbers 150, 30 and 15 are entered, respectively (A1 = 150, C1 = 30, C3 = 15). In cell B1 entered: “=A2” and in A2: “=A1/C3”. What will be displayed in cell B1 as result?
30
10
5
#Error
15
Same as in C3
Same as in A2
Same as in C1

Вопрос №35

In cells A1, C1 and C3, the numbers 150, 30 and 15 are entered, respectively (A1 = 150, C1 = 30, C3 = 15). In cell B1 entered: “=A1” and in C3: “=A1/C1”. What will be displayed in cell B1 as result?
30
10
5
#Error
150
Same as in C3
Same as in A1
Same as in C1

Вопрос №36

The Microsoft Excel file in general is a ____.

Set of worksheets representing a workbook

Set of related workbooks

Set of related tables

Set of unrelated formulas

Table processor

Table redactor

---

Смотрите также файлы

• Нижегородский Государственный Технический Университет Кафедра Информационных Радиосистем пояснительная записка.doc

• Задание 1 Рационализм это направление в философии, согласно которому основой как бытия, так и познания является разум. Эмпиризм.docx

• Анализ схемотехники пересчетного устройства.docx

• Виды, формы и организация контроля качества обучения. Понятие контроля. Функции контроля. Требования к контролю.docx

• Мшелер жне мшелер жйесі.docx