Worksheetsакт сессия 200-250
Total questions: 51
Worksheet time: 25mins
MS Excel. A command of the formulas for calculating SIN, COS:
Formulas-Insert function-Statistical
Formulas-Insert function-Financial
Formulas-Function
Formulas - Calculation
Formulas-Insert function-Math & Trig
In cell B6 was entered a number 8675. If you select this cell and select "Scientific", then this number turns into:
8,68E+03
8 675,00р
8675,00
867500,00%
8675
This error value appears when you incorrectly type the range name
#NAME?
#######
>#DIV/0
>#NUM!
>#REF!
This error can be caused by an invalid argument in an Excel function:
NUM
>#######
DIV/0
>#NAME?
>#REF!
How to insert pie chart in MS Excel?
Insert – Initial data – Pie
Insert – Charts – Chart parameters – Pie
Charts – Insert – Pie
Insert – Charts – Pie
Charts – Charts window
MS Access. The "Form Design" icon lets you:
Create a new blank from in Design view.
Create a that lets you enter information for one record at a time.
Create a spilt form for one record at a time.
Create a new from in Design for one record
Create a new blank form for one record at a time.
MS Access. icon is used for:
Set up relationship between tables.
Insert OLE Object into a table.
Insert different symbols into a table.
Insert attachments into a table.
Run Macro.
MS Access. icon is used for:
Creating a form
Creating a new table
Creating Simple Query
Creating a Simple Report
Insert a macro
MS Access. icon is used for:
Creating a new table in Design View
Creating a new Report in Design View
Creating a new form in Design View
Creating a new query in Design View
Set up relationship between tables
MS Access. icon is used for:
Creating a new form in Design View
Creating a new Report in Design View
Creating a new table in Design View
Creating a new query in Design View
Set up relationship between tables
Which of these buttons are used for creating a simple query:
Which of the buttons are used for creating a table in Table Design
Choose the correct list of data types in the fields of tables in MS Access:
Text, Memo, Number, Date / Time, Currency, OLE Object, Lookup Wizard;
Lookup Wizard, Object OLE, Text, Numeric, Percentage, Counter, Date / Time;
Text, Money, Memo, Numeric, Counter, Date / Time, Perm Wizard, OLE Object;
Text, Memo, Number, Format, Caption, Field Size, Lookup Wizard;
Format, Caption, Field Size, Currency, OLE Object, Lookup Wizard;
MS Access. Where are located Filter commands:
Home – Record – Sort & Filter.
Home – Find – Filter.
Home – Font – Filter.
Home – Styles – Sort & Filter.
Home – Sort & Filter – Filter.
MS Access. Where are located Find and Replace commands:
Home – Find.
Home – Record – Find or replace
Home – Find – Find or replace.
Home – Font – Find or replace.
Home - Editing - Find or replace.
MS Access. In which group of command The "Sort Data" button is located:
Home - Sort and Filter
Table Mode - Sort and Filter
External data – Sort and Filter
Datasheet - Sort and Filter
Create - Sort and Filter
MS Access. Ways of creating the Reports:
Report Design, Multiple items
Report, Report Wizard.
Auto report, Report Blank.
Multiple items, Auto Refort.
Auto report, Report Wizard.
Primary memory
stores the programs currently running and the data being processed
stores programs and data for later use;
convert data and instructions into a form that is convenient for processing on a computer;
represent information processed by a computer in a form convenient for human perception;
communication devices control the reception and transmission of data in local and global networks.
Secondary memory
stores programs and data for later use;
stores the programs currently running and the data being processed;
convert data and instructions into a form that is convenient for processing on a computer;
represent information processed by a computer in a form convenient for human perception;
communication devices control the reception and transmission of data in local and global networks.
Convert decimal number 9 to binary system:
1000;
1101
1011
1110
1001
Convert a binary number 1011 in decimal notation?
11
10
8
2
4
Calculate1011 +1000 in binary system
11011
10111
11101
10011
10000
Calculate 10111 - 10101inbinarysystem
11
111
10
101
110
Convert decimal number 25 tooctal number system:
31
10
28
12
15
Convert decimal number160 to hexadecimal number system:
11
B0
12
A0
1C
Convert number 10 fromdecimalsystemtobinarynumbersystem:
1010
1000
1101
1011
1100
Convert decimal number 64 tooctal number system:
112
100
101
125
111
Convert number 11 fromthedecimalsystemto binary system:
1011
1111
1101
1010
1100
Convert number 13 fromthedecimalsystemto binary system
1000
1001
1011
1110
1101
Convert binary number 1111 to decimal number system
15
11
8
12
14
Execute addition in the binary system 1001+1100
10011
11001
10101
11000
11100
Convert decimal number 100 tooctal number system
144
134
112
125
101
Convert decimal number 101 tooctal number system
145
144
112
125
101
To use the mouse to open an object or start the program, you must perform one of the following actions
Double-click and release the left mouse button twice on the desired object
Move the mouse pointer to an image on the desired object
Place the mouse pointer over the object, click the left mouse button and without releasing it, move the pointer to the desired location, then release
Press and quickly release the left mouse button on the desired object
Twice quickly press and quickly release the right mouse button on the desired object
In order to move the object, select text and move the selected text with the mouse, you must perform one of the following actions
Twice quickly press and quickly release the left mouse button on the desired object
Move the mouse pointer to an image on the desired object
Рlace the mouse pointer over the object, click the left mouse button and without releasing it, move the pointer to the desired location, then release
Press and quickly release the left mouse button on the desired object
Twice quickly press and quickly release the right mouse button on the desired object
Windows. Command for formatting the drive in MS Windows
Explorer - ROM - Edit – Format
Start - Disk - View - Format
My computer -Edit - Format - Disk
My computer - Disk - Right click – Format
Explorer - Edit - Format - Drive
Windows. To create the shortcut you need
Call the context menu (left-click), select New-Shortcut
Call the context menu (right-click), select New-Shortcut
Go to the main menu of Microsoft Windows and select the label Shortcut
Call the context menu (right-click), select New - Object
Call the context menu (right-click), select New – Folder
The full form of the table of contents on the right panel of NC is displayed when you press the keys...
F9 R F
F9 R B
F9 L F
F9 L B
F9
The command MS DOS C: \ DOC \ STR.DOC indicates the path to:
The SYS subdirectory of the root directory
Files * .SYS of the DOC directory
The STR.DOC file of the DOC subdirectory of the root directory
The SYS subdirectory of the DOC directory
The DOC subdirectory of the root directory
The EKG.txt file is located on drive C in the PHYSICS directory. Specify its full path:
С:/ PHYSICS / EKG.txt
С:/ PHYSICS / EKG;txt
С:/ PHYSICS \ EKG;txt
С:\ PHYSICS \ EKG.txt
С:\ PHYSICS \ EKG:txt
The operating system can be stored on: 1) a hard magnetic disk; 2) in a special DOS directory; 3) flexible system disk; 4) in the user directory
1,2 and 3
2 and 4
Only 4
1 and 3
1,2,3,4
The file test.txt is located on drive D in the school directory, in the test subdirectory, its full path:
d:\school\test\test:txt.
d:\test.txt.
d:\school\test.
d:\school\test\test.txt.
d:/schoоl/test/test.txt
MS DOS. The directory of the first level STUDENT of the current drive C can be deleted with the command:
RD А:\STUDENT
RD C:
MD
RD C:\STUDENT
CDSTUDENT
How to group several graphic elements in the Word editor:
<variant>Select the grouping elements– click Grouping –Regroupfrom context menus.
Select a grouping items –runcontext menu - click Group -group.
Select a grouping items – click Order –Group from context menus.
Select the grouping elements – click Paste from context menus
Select the grouping elements – click Grouping –Ungroupfrom context menus.
Select the grouping elements– click Grouping –Regroupfrom context menus.
To merge cells in a text editor:
Select cells that you wish to merge – click Merge Cells from the context menu.
Select cells that you wish to merge – click Add command from the Table menu.
Select cells you want to merge and then click the Tab from the Insert menu.
Select cells you want to merge – On the Table Tools/Design choose Merge Cells.
Select cells you want to merge – On the Table Tools/ Layout tab, in the Table group, click the Properties button.
Word. The Page Layout Tab holds thegroup of commands:
Text, Page Setup, Links, Paragraph, Tracking.
Themes, Page Setup, Page Background, Styles, Editing.
Themes, Clipboard, , Page Background, Zoom, Arrange.
Themes, Pages, Tables, Macros, Links.
Themes, Page Setup, Page Background, Paragraph, Arrange.
To double the segment in MS Word use the command:
View– Zoom– 200%.
File – Zoom– 200%.
Type – Main document – 200%.
Type – Main document– 2.
Proofing– Insert – 2.
MS Word. There are all the commands for combining table cells, except for one :
Select cells you want to merge –Layout – Merge group – Merge Cells.
Select cells you want to merge –Design – Draw Borders – Eraser.
Select cells you want to merge, press the Delete key.
Select cells you want to merge –click Merge Cells command from the context menu.
Select the cells you want to merge – click Alt+A keys – then press "M".
We can change the thickness of a table borders using commands…
Select table – On the TableTools/Design choose group Table Styles
Select table – click Borders and Shading from the context menu, then choose width of the line.
Select table –Insert tab – click Borders and Shading, then Line width.
Select table –click the Table – Borders, then Line width.
Select table –click the Table – Borders, then Line width.
Which of the following represent pre-set paper size types which you can select from the Size button in the Page Setup group?
Legal, Letter, A5, A4.
Narrow, Wide, Normal, Mirrored, Moderate.
Letter, Landscape, Executive, A4, A3.
Tabloid, Portrait, Moderate, Legal.
Legal, Wide, Landscape, Mirrored
If you have to write a paper where the margins need to be set to the following exact measurements: Left: 1.5", Right: 4", Bottom: 1", Top: 1", how can you go about setting this up?
Page Layout–Page Setup group – Margins section, then enter the page margin values as noted in the question above
Click Page Setup–Margins button. Select the margin values as noted in the question above.
Page Layout–Page Setup group – Paper size section, then enter the page margin values as noted in the question above
Page Layout–Page Setup group –Columns section, then enter the page margin values as noted in the question above.
None of the above options are correct as they all contain errors.
