Вопрос №13
V2
|
What does key combination «Ctrl+Esc» do?
|
1
|
Opens the “Start” Menu
|
0
|
Closes all programs
|
0
|
Ends a non-responsive program
|
1
|
Same as the “win” ( ) key
|
0
|
Switching to another running programm
|
Вопрос №14
V2
|
What happens when you press F12 in office applications (commonly)?
|
0
|
The file will be saved and automatically closed
|
0
|
Same as pressing Alt + f4
|
0
|
Same as pressing Alt + Tab
|
0
|
A file “format” window will open
|
1
|
A file “save” window will open
|
0
|
A file “parameters” window will open
|
1
|
Same as pressing “Save as” command
|
Вопрос №15
V2
|
The tables of the relational database (DB) may contain:
|
0
|
Extremely homogeneous information (only one type of data)
|
0
|
Text only
|
1
|
Heterogeneous information (different types of data)
|
0
|
Only logical quantities
|
0
|
Neither of above
|
1
|
Text, numeric, hyperlinks data
|
Вопрос №16
V2
|
Which of the following is NOT a part of a common database?
|
0
|
Tables
|
0
|
Records
|
0
|
Fields
|
1
|
Worksheets
|
1
|
Logical drives
|
0
|
Primary key
|
0
|
Table relationships
|
Вопрос №17
V2
|
The feature of the “Counter” field in Microsoft Access is that
|
|
1
|
it has the property of auto fill in
|
|
0
|
the data is not stored in the field itself, but in another place, but only the pointer is stored in the field
|
|
0
|
the maximum size of the number stored in it cannot exceed 255
|
|
0
|
it is intended to fill in with integers data
|
|
0
|
it is intended to fill in with hyper-links data
|
|
1
|
each new record will be automatically filled with next in order number ( increased by 1)
|
|
Вопрос №18
V2
|
In order to present the chart as an independent sheet in a workbook, you must:
|
0
|
Select a chart - select “On a separate sheet” in the “Chart” context menu
|
1
|
Select a chart - in the context menu or the «Designer» menu, select “On a separate sheet”
|
0
|
Copy chart - open new sheet - paste chart
|
0
|
Copy the chart - on the new sheet select "Paste" - "Chart"
|
0
|
Select chart – press ctrl+A+→
|
1
|
Select a chart – select “On a separate sheet” in the context menu or the «Designer» menu of the chart properties
|
Вопрос №19
V2
|
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?
|
0
|
The following two cells will be filled with the text: "Wednesday".
|
0
|
The next two cells will be formatted in the same way as the last cell in the list, and their contents will remain empty.
|
0
|
This will copy the contents of the active cell.
|
1
|
The next two cells of the column will be filled with the continuation of the days of the week list: “Thursday”, “Friday”, etc.
|
0
|
Nothing, cells will remain empty
|
0
|
A program error will occur
|
1
|
Following cell will be filled with “Thursday”, “Friday” and so on.
|
Вопрос №20
V2
|
The addresses of which rows and columns when copying the formula =$A23 + C$21 will NOT be changed:
|
1
|
A
|
0
|
C
|
1
|
21
|
0
|
23
|
0
|
A23
|
0
|
C21
|
Вопрос №21
V2
|
The addresses of which rows and columns when copying the formula =$F15 + K$44 will be changed:
|
0
|
F
|
1
|
K
|
1
|
15
|
0
|
44
|
0
|
K44
|
0
|
F15
|
Вопрос №22
V2
|
The addresses of which rows and columns when copying the formula =G$3 + $H21 will NOT be changed:
|
1
|
H
|
0
|
G
|
1
|
3
|
0
|
21
|
0
|
G3
|
0
|
H21
|
Вопрос №23
V2
|
The addresses of which rows and columns when copying the formula =$F15 + A$44 will be changed:
|
0
|
F
|
1
|
15
|
1
|
A
|
0
|
44
|
0
|
A44
|
0
|
F15
|
Вопрос №24
V2
|
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
V2
|
The addresses of which rows and columns when copying the formula =$F$15 + $A$44 will be changed:
|
0
|
F
|
0
|
15
|
0
|
A
|
0
|
44
|
1
|
A44
|
1
|
F15
|
Вопрос №26
V2
|
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?
|
0
|
F
|
0
|
4
|
1
|
None of the above
|
0
|
C
|
1
|
F$4+$C$1
|
0
|
Cells F$4 and $C$1 addition result
|
Вопрос №27
V2
|
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?
|
0
|
H
|
0
|
G
|
1
|
None of the above
|
0
|
3
|
1
|
H$3+$G$3
|
0
|
Cells H$3 and $G$3addition result
|
Вопрос №28
V2
|
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?
|
0
|
F
|
0
|
4
|
1
|
None of the above
|
0
|
C
|
1
|
A$14+$C101
|
0
|
Cells A$14 and $C101addition result
|
Вопрос №29
V2
|
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?
|
0
|
F
|
0
|
4
|
1
|
None of the above
|
0
|
C
|
1
|
B$24+F$11
|
0
|
Cells B$24 and F$11 addition result
|
|
Скачать 111.26 Kb.