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