ikt
Symbol to denote the absolute cell addressing
$
In cell C4-number 1000.The result of the function if (C4>0;100;200)
100
In Access, the number of types of links:
3
In Access field names are allowed to:
64 characters
The symbol is not an arithmetic operation in Excel:
: #
In Access, in the template table fields delete button of the selected fields:
<<
In Excel, enter the formula in cell begins with the sign:
=
Correctly written formula in Excel:
=SUM(A1:B14)-1A/B14 =SUM(C5:C30) =A1^2
Correctly written formula in Excel:
=а1+а2+а3 =МАКС(К3:М9)
Server - is:
A computer that provides services to clients
The correct designation worksheet columns in Excel:
AK AB D
The Access operation of calculating the mean value:
AVG
The cells left, right, top and bottom of the current known as:
Adjacent
In Access, the main difference between AutoForm regime in the column of the table mode:
Allows you to view only a single record
Correct identification range in EXCEl
B2:C4
The network topologies are distinguished:
Bus Ring Star
To select non-contiguous blocks in Excel use the key:
CTRL
AutoSum button in Excel is needed to:
Calculating the amount of cells
Elementary object of spreadsheet is:
Cell
To select an entire column to Excel, you must:
Click on the label, the column header.
To create a new workbook in Excel program:
Click the New button on the Quick Access Toolbar Run Office command - Create Execute the Home - Create
Topology - is:
Connection configuration of elements in the network
Resource Internet address consists of:
Connection type, server name
In Access function COUNT:
Count the number of records
In Access Expression Builder is used to:
Create a calculated field
Use the AutoFill feature in Excel table program can be:
Create a series of numbers, days, dates
"Save" command in Word match:
Ctrl + S
To sort the data in Excel to enter the menu item:
Data
In Access mode allows you to change the layout of the table, query, report:
Design mode
In Excel for graphical representation of numerical data is used:
Diagram
In Access to include the desired field in the request form should be:
Drag the field from the table in the appropriate column of the query Double-click on the desired field in the table
Expansion has XLS files created by the application:
EXCEL
Key transition from relative to absolute references,and vice versa
F4
The correct address of the cell in Excel:
F6 B1 MN3
In Access, a column called:
Field
Command OPEN in word is equal to
File-open ctrl+o
The MAX function provides in Excel:
Find the highest value
The MIN function provides in Excel:
Find the smallest value
According to the length of the network of communication lines are distinguished:
Global Regional Local
The language of design hypertext documents is:
HTML
Add cells to the table in Excel with the command:
Home - Insert the cell
In Access possible to establish a connection between the tables:
If there are identical records
In Access field names in calculated fields should be taken:
In square brackets.
Insert characters in a text editor Microsoft Word
Insert-Symbol
For the numbering of pages in Word,use the command
Insert-page numbers
Internet Provider - is:
Internet Service Provider
Sign <> in EXCEL
Is not equal to sign
FTP - a service that:
It is intended to transfer files between computers
The logical OR operand is:
Logical negation
Database management system - is:
MS Access
In Access the proportion (∞ - 1) corresponds to the relationship:
Many-to-one
Formulas are created using in Excel:
Masters of Functions.
The spreadsheet's function is performed:
Microsoft Excel.
Type list in Word document can be:
Multi-level Are labeled Numbered
In Access the proportion (1 - 1) corresponds to the relationship:
One-to-one
In Access to the field names must not contain:
Point [] !
To actually enter the formula in a cell,it is necessary to:
Press(ctrl)
Browser - is:
Program for Internet access services
In Access, the line is called:
Records
In Access sampling means is:
Request
Internet Explorer - is a tool for:
Scan Web-pages
To correct already entered information in Excel is necessary:
Select the cell and press [F2] Double-click on an editable cell Select the cell and click on the formula bar
The electronic mail address after the @ sign:
Server name
Book in EXCEL is consists of:
Sheets
The element that displays the current page number, number of pages:
Status bar
Sort data in Excel - is:
Streamlining the data in descending order Streamlining ascending data
Result sum of numbers arranged in line 7 in columns 1 to 4:
Sum(A7:D7). СУММ(A7:D7).
In Access, the basic object is:
Table
Element Word window that allows you to set the document margins, indents:
Task pane.
A line of formulas in Excel displays:
The address and the contents of the active cell.
Diagram showing only one data series:
The circular.
Internet Services uses the architecture:
The client-server
In Access, you can enter to create a table in Design view:
The field names, data types, descriptions.
In Access, the key field is used to:
The links between tables
The logical operand AND means:
The logical multiplication
The process of creating a table in Access by choosing from existing fields:
The template tables
In Access, there is a data type:
The text Logical The counter
Using E-mail can be:
To send and receive messages
The electronic mail address before the @ sign:
User Name
The Internet address of the E-mail has the format:
User Name @ FQDN of the mail server on the Internet
Menu item in Word to enable /disable the coordinate line
View
Text in WORD is impossible to align
according to paragraph in the center in length
to select a word,it is necessary to
double-click on it
Stylistic errors are underlined in Word:
green color
By the logic functions in EXCEL function applies
if and or
Spelling errors are underlined in Word:
red
Coordinate line in Word is used for
setting custom margins and margin sizes
