Font size
Worksheetsсессия акт2
Total questions: 101
Worksheet time: 51mins
By pressing the shortcut keys Ctrl +X you can make
cut, send the object to the clipboard
insert the object from the buffer into the specified location
select all objects
copy, send a copy of the object to the clipboard
In the NC shell program, the F3 function key is used to
delete file
rename the file
view a text file
copy file
MS DOS. The command issuing directory tree
TREE
DIR
RD.
MD.
MS DOS. Quick access to the root directory
\Cd
C:\>nc\temp.//
C: Cd
Cd\
Norton Commander. The search command for the record (word, sentence) of the file being viewed or edited in the embedded NC editor is performed when you press the keys:
F10
F7
F2
F4
Windows OS. When working in the Windows environment, the Paste command corresponds to a key combination:
Ctrl+V
Ctrl+C
Ctrl+P
Ctrl+X
Windows OS. You can Cut the selected item in Windows OS by pressing the keys:
Ctrl+V
Ctrl+X
Ctrl+C
Ctrl+P
Windows OS. You can Copy the selected item in Windows OS by pressing the keys
Ctrl+V
Ctrl+C
Ctrl+P
Ctrl+X
Windows OS. You can Delete the selected item without moving it to the Recycle Bin first in Windows OS by pressing the keys:
Shift +Delete
Ctrl+Z
Ctrl +Right Arrow
Ctrl+V
The primary purpose of an operating system is
To make the most efficient use of the computer hardware
To allow people to use the computer
To make computers easier to use
To convert the numbers from one number system to another number system
By pressing the keyboard shortcut Ctrl +C, you can
Paste an object from the clipboard to the specified location
select all objects
copy, send a copy of the object to the clipboard
undo the previous action performed
By pressing the keyboard shortcut Ctrl +Х, you can
cut, send the object to the clipboard
Paste an object from the clipboard to the specified location
select all objects
copy, send a copy of the object to the clipboard
In order to specify an object with the mouse, you must do one of the following actions
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
Move the mouse pointer to establish its image on the desired object
The appearance on the calculator of the M sign in the upper left corner of the keyboard means that
in memory is the number
it is necessary to enter the sign of mathematical operation
you cannot enter a sign of mathematical action
changes sign of number
Number of operations performed by the processor per second
processor clock speed
processor bit width
volume of operative memory
volume of information processed
Which of the following commands is given to reboot the computer?
Ctrl +Alt +Tab
Ctrl + Alt + Del
Ctrl + Shift + Del
Shift + Alt + Del
The type of device which data is recorded when it is made into a microchip and that can not be changed, and the programs running on the computer can only read these data is called:
Operative memory device.
Constant-memory device
External storage device.
A hard disk.
The keys F1 - F12 are called:
managers
command
editing
functional
A multi-core processor
a computer processor which incorporates the functions of a computer's central processing unit (CPU) on a single integrated circuit (IC), or at most a few integrated circuits
a theoretical quantum computer
a computer with a high-level computational capacity compared to a general-purpose computer
is a single chip that contains more than one microprocessor core
The main system board of the computer having connectors for installation of additional expansion cards and serving as a mechanical basis of all electronic circuit of the computer
Network adapter
Motherboard
Data bus
Operational fee
A Hard disk is a device for:
recording data and programs on the magnetic tapes.
storage of large amounts of data and programs used when working with a PC.
display text and graphic information on the screen
control the PC work by the given program
The clock speed of the microprocessor is measured in:
megahertz
codes of symbol table
megahertz and bits
megahertz and bytes
The number of operations executed by the processor per second:
the clock speed
the bit width
RAM
the volume of information processed
A scanner is a device for:
the exchange of information with other computers via the telephone network
read graphic and text information into the computer.
output of drawings on paper.
quick save all the information stored on the hard disk.
The coprocessor is designed to:
record information on the floppy disk
constant storage of information used when working with computer.
help the main processor in performing mathematical operations.
read information in the computer
One Terabyte (1 Tb) is equal to
1028 Gb
1024 Mb
1024 Gb
1028 Mb
The mouse is a device used for:
the exchange of information with other computers via the telephone network
quick save all the information stored on the hard disk.
output of drawings on paper.
facilitate entry of information into the computer.
Plotter is a device for:
exchange of information with other computers
text output on paper.
reading text into the computer
output of drawings on paper.
A printer is a device for:
printing of text and graphic information
quickly save all the information on the hard disk.
output drawings on paper.
reading of graphic and text information in the computer.
A special type of memory chip that holds software that can be read but not written to.
RAM
Mother Board
ROM
CPU
What is the name of the device responsible for performing arithmetic and logical operations and control operations written in the machine code?
microprocessor.
RAM.
input system
long-term memory
Computers of the second generation were based on
transistors
integrated circuits
electron tubes
over large integrated circuits
Computers of the third generation were based on
transistors
integrated circuits
electron tubes
over large integrated circuits
The coprocessor is intended for:
write information to a floppy disk.
permanent storage of information used when working with a computer.
help the main processor in performing mathematical operations.
reading information into the computer
Principle of addressing:
execution by the processor automatically in a certain sequence of the instruction set;
the main memory structurally consists of numbered cells;
A certain set of actions can be performed on the data;
programs and data are stored in the same memory;
Processor bit width:
is the number of bits simultaneously stored, processed or transferred to another device;
the number of operations performed by the processor per second
the small size of RAM built-in processor;
the amount of RAM and processed information
What is formatting?
Disk Optimization
Search for files
Drive initialization (markup)
Scan for viruses
The processor function consists of:
Outputting data for printing .
Processing of data entered in the computer.
Connections of a computer to an electronic network.
Input of data
How to create a table using the Table Design?
Tables - Creating a Table //
Creation - Table Wizard
Create – Tables – Table Design
Creating – Multiple items – Table Design
MS Access 2007. How to create a form using the wizard?
Forms Wizard - Creating a Form
Creation - Forms Master
Create – Forms – More forms - Form Wizard
Create – Forms -Forms Wizard
Commands for inserting Greek letters μ, ξ, λ :
Insert tab – Illustrations group – SmartArt
Insert tab – Text group – Object– Microsoft Excel
Insert tab – Record – Symbol
Insert tab– Symbols group – Symbol button
Word. What commands are found on the Quick Access Toolbar (default commands)?
Save, Page Setup, Redo.
Redo, New, Display all features
Storage, Undo, E– mail
Save, Undo, Redo
MS Word. How to add and change the border around the page:
Page Layout – Page Background - Page Borders
Home –Paragraph - Page Borders
Insert – Pages – Page Borders
View –Zoom - Page Layout
MS Word. Where are located Find and Replace commands:
Home – Editing - Find or replace
Home - Format - Find or replace
Home - Font - Find or replace
Home - Styles - Find or replace
How to put a chart in a document
View –Table –Chart
View –Macros - Chart
Insert –Illustrations – Chart
Insert – Window - Chart
MS Word. How to insert the equation
Insert – Symbols – Symbol
Home – Font – Symbol
Insert – Symbols – Equation
Home – Font – Symbol
How to run Microsoft Equation 3.0 editor in MS Word?
Insert – Table – Correction of column widths
Insert –Text - Object – choose Microsoft Equation 3.0
Insert – Symbols – Equation
Insert –Table – Correct track – Microsoft Equation 3.0
How to merge selected cells In MS Word:
Layout – Merge - Merge Cells
Layout – Merge – Split Cells
Table – Add Table
Table – Replace
Groups of commands in Insert tab
pages, tables, illustrations, links, head & footer, text, symbols
cutting, copying, inserting, cleaning
spelling, paragraph, tema.
Sort layouts and sheets
Groups of commands in View tab
pages, tables, illustrations, links, head & footer, text, symbols
cutting, copying, inserting, cleaning
document views, show/hide, zoom, window, macros.
Sort layouts and sheets
The Font dialog box contains the following packages
Free space, slots and page layout
Font, Character Spacing
The size of fields and sheets
Page Numbers and Symbols
MS Word. How do we change the page numbers of a document when we add an additional page?
The number of pages of the document are automatically numbered
The new page will be left without a number, we need to rearrange the page numbers
When we add a new page, the system prompts us to re– number the pages and waits for a response
When we add a new page, the system asks you to enter the page number
The MS WORD contains the next text alignments
Left, right, bottom and top
Left, right, width and height
Left, right, center and justify
Width, height and diagonal.//
Left and right margins .
What parameters are displayed when insert table in Word
number of rows and columns and autofit behavior
columns, widths, table shape, and its fields
The widths and numbers of the rows, columns
number of rows and columns, column width and table form
MS Excel. How to adjust the size of columns and rows in a cell
Home –Cells – Format - Row height – Column width
Home – Row (Column) –Height (Width
Data– Cells – Format - Row – Column
Data - Row height – Column width
Formula for summation the range of cells
=SUM(А1:А7)
=SUM(А1,А7)
=SUM(А1-А7)
=SUM(А1,А3,А7)
Correct version of the formula in MS Excel:
=А3*100:В3
=А3*100/В3.
А3!*100/В3
=А3!*100/В3
Command that can be used to merge cells in MS Excel
Insert – Cells – Alignment – Merge cells
Home – Alignment – Merge cells
Home – Cells - Alignment – Merge cells
Review - Cells - Alignment – Merge cells
What commands do you need to completely copy the page in MS Excel?
Sheet label – Context Menu – Move or copy – OK
Insert – Copy sheet – Create copy – OK
View - Move or copy– Create copy – OK//
Context Menu – Page layout - Copy sheet – Create copy – OK//
What is the type of chart shown in figure?
Pie
Bar
Histogram
Organizational
What is the type of chart shown in figure?
Cone
Cone
Scatter
Line
What is the type of chart shown in figure?
Line
Histogram/
line
bar
What is the type of chart shown in figure?
Doughnut/
Pie
Bar
Scatter
How to get the command to calculate the square root of a value in Excel?
Formulas tab – Insert function – Math & Trig – SQRT
Formulas tab – Insert function – Statistical – SQRT
Formulas tab – Calculate –SQRT
Formulas tab – Insert function –SQRT
MS Excel. A command of the formulas for calculating SIN, COS:
Formulas-Insert function-Statistical
Formulas-Insert function-Financial
Formulas-Insert function-Math & Trig
Formulas - Calculation.
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%
This error value appears when you incorrectly type the range name:
#NAME?
#######
#DIV/0
#NUM!
This error can be caused by an invalid argument in an Excel function
#######
#NUM!//
#NAME?//
#DIV/0//
How to insert pie chart in MS Excel?
Insert – Charts – Pie
Insert – Initial data – Pie
Insert – Charts – Chart parameters – Pie
Charts – Insert – Pie
MS Access. The "Form Design" icon lets you
MS Access. The "Form Design" icon lets you
Create a that lets you enter information for one record at a time.
Create a that lets you enter information for one record at a time.
Create a new blank form for one record at a time
MS Access. icon is used for:
Set up relationship between tables
Insert attachments into a table
Insert different symbols into a table
Insert OLE Object into a table
MS Access. icon is used for:
Creating a form
Creating a new table
Creating Simple Query
Creating a Simple Report
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
Set up relationship between tables
MS Access. icon is used for:
Creating a new table in Design View
Creating a new Report 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;
Text, Money, Memo, Numeric, Counter, Date / Time, Perm Wizard, OLE Object;
Lookup Wizard, Object OLE, Text, Numeric, Percentage, Counter, Date / Time
Format, Caption, Field Size, Currency, OLE Object, Lookup Wizard;
MS Access. Where are located Filter commands
Home – Sort & Filter – Filter.//
Home – Record – Sort & Filter.//
Home – Find – Filter.//
Home – Styles – Sort & Filter.
MS Access. Where are located Find and Replace commands:
Home – Sort & Filter – Find.//
Home – Record – 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:
Table Mode - Sort and Filter
Home - Sort and Filter
Datasheet - Sort and Filter
External data – Sort and Filter
MS Access. Ways of creating the Reports
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
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
Convert decimal number 9 to binary system
1001
1101
1000
1110
Convert a binary number 1011 in decimal notation
10;
8;
11
12
Calculate 1011 +1000 in binary system
10011
11101
10011
10111
Calculate 10111 - 10101in binary system
101
10
111
110
Convert decimal number 25 to octal number system
10
28
12
31
Convert decimal number160 to hexadecimal number system
11;
В0;
А0;
12;
Convert number 10 from decimal system to binary number system:
1000;
1010;
1101
1100;
Convert decimal number 64 to octal number system:
100;
101
112
125
Convert number 11 from the decimal system to binary system:
1011
1010;
1100;
1100;
Convert number 13 from the decimal system to binary system
1101;
1000
1001
1011
Convert binary number 1111 to decimal number system
8
15
12
14
Execute addition in the binary system 1001+1100
10101
11100
11000
11001
Convert decimal number 100 to octal number system
144
101
112
125
Convert decimal number 101 to octal number system
145
144
112
125
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 //
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
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
Move the mouse pointer to an image on the desired object
Twice quickly press and quickly release the left mouse button on the desired object
Press and quickly release the left mouse button on the desired object
Windows. Command for formatting the drive in MS Windows:
My computer - Disk - Right click – Format
Start - Disk - View - Format
Explorer - ROM - Edit – Format
Explorer - Edit - Format - Drive
Calculate 1011 +1000 in binary system
10011
11101
10011
10111
