- •Internet services are: a) e-mail. B) tcp/ip. C) Usenet, News. D) smtp. E) www, ftp. F) http. G) pop3. H) imap4.
- •Insert characters in a text editor Microsoft Word: a) Insert - Picture - Pictures. B) View - Symbol. C) Insert - Symbol. D) Insert -objects. E) Insert - AutoText.
- •In Excel, enter the formula in cell begins with the sign:
- •In Excel for graphical representation of numerical data is used: a) Diagram. B) Table. C) Formula. D) Sites. E) Pictures.
In Excel, enter the formula in cell begins with the sign:
A) +.
B) =.
C) *.
D) /.
E) \.
$$$ 132
Correctly written formula in Excel:
A) а1+а2+а3=.
B) а1+а2+а3.
C) =а1+а2+а3.
D) +А1/2.
E) =1a+2a.
F) =МАКС(К3:М9).
$$$ 133
The cells left, right, top and bottom of the current known as: A) Neighboring. B) Special. C) Adjacent. D) Noncontiguous. E) Built.
$$$ 134
To select non-contiguous blocks in Excel use the key:
A) SHIFT.
B) ALT.
C) ESC.
D) CTRL.
E) TAB.
$$$ 135
Correctly written formula in Excel:
A) =A+5/B4.
B) =3F-SUM(A1-A5).
C) =SUM(C5-C30).
D) =A46*SUM(F1:F46).
E) =SUM(A1:B14)-1A/B14.
F) =SUM(C5:C30).
G) =A1^2.
H) =2\A1.
$$$ 136
Result sum of numbers arranged in line 7 in columns 1 to 4:
A) Sum(1:4).
B) Sum(7,1:4).
C) Sum(A7:D7).
D) Sum(A1:A4).
E) Sum(A1:D7).
F) СУММ(A7:D7).
$$$ 137
Expansion has XLS files created by the application:
A) WRITE.
B) WORD.
C) EXCEL.
D) PAINT.
E) PHOTO-SHOP.
$$$ 138
Elementary object of spreadsheet is: A) Sheet. B) Book. C) Cell. D) Column. E) Lines.
$$$ 139
To sort the data in Excel to enter the menu item: A) View. B) Insert. C) Format. D) Service. E) Data.
$$$ 140
A line of formulas in Excel displays: A) The name of the spreadsheet. B) Number plate. C) A list of formulas used in EXCEL. D) Title sheet. E) The address and the contents of the active cell.
$$$ 141
The spreadsheet’s function is performed:
A) Microsoft Word.
B) Microsoft Excel.
C) Microsoft Access.
D) Microsoft Windows.
E) Microsoft Power Point.
$$$ 142
Formulas are created using in Excel: A) Masters of Functions. B) AutoFormat commands. C) Chart Wizard. D) Command Sorting. E) Command Data.
$$$ 143
Diagram showing only one data series: A) Histogram. B) Graph. C) Point. D) The circular. E) Over the regions.
$$$ 144
In Excel for graphical representation of numerical data is used: a) Diagram. B) Table. C) Formula. D) Sites. E) Pictures.
$$$ 145
Element Word window that allows you to set the document margins, indents:
A) Standard panel.
B) Status bar.
C) Line.
D) Task pane.
E) Scroll bars.
$$$ 146
The element that displays the current page number, number of pages:
A) Task pane.
B) Panel Format.
C) line.
D) Status bar.
E) Scroll bars.
$$$ 147
Stylistic errors are underlined in Word:
A) Blue.
B) Green color.
C) Purple.
D) Red.
E) Yellow.
$$$ 148
Spelling errors are underlined in Word:
A) Blue.
B) Green color.
C) Purple.
D) Red.
E) Yellow.
$$$ 149
Type list in Word document can be:
A) Multi-level.
B) Hide.
C) Adjacent.
D) Are labeled.
E) Standard.
F) Outside the box.
G) Numbered.
H) Open.
$$$ 150
To create a new workbook in Excel program:
A) Press the button to return to the toolbar.
B) Press the Open button on the toolbar.
C) Click the New button on the Quick Access Toolbar.
D) Run the command New from the File menu.
E) Run the command to open the file menu.
F) Select the command Add from the context menu.
G) Run Office command - Create.
H) Execute the Home - Create.
$$$ 151
Add cells to the table in Excel with the command:
A) Format - Cells.
B) View - Cells.
C) Edit- sheet.
D) Insert - Cells.
E) Service - Cell.
F) Home - Insert the cell.
$$$ 152
Use the AutoFill feature in Excel table program can be:
A) Automatically perform basic calculations.
B) Automatically perform complex calculations.
C) Create a series of numbers, days, dates.
D) Make changes in the cell contents.
E) Copy data.
$$$ 153
The correct designation worksheet columns in Excel:
A) 12A.
B) AK.
C) 21.
D) A12.
E) AB.
F) F1.
G) D.
H) F1S.
$$$ 154
The correct address of the cell in Excel:
A) "A10000.
B) # A10.
C) F6.
D) 1C.
E) B1.
F) F-2.
G) BZ_99.
H) MN3.
$$$ 155
The symbol is not an arithmetic operation in Excel:
A) -.
B) +.
C):.
D) /.
E) ^.
F) #.
$$$ 156
The MIN function provides in Excel:
A) Find the smallest value.
B) Find the mean value.
C) Organizing descending numbers.
D) Find the shortest text.
E) Counting the number of data.
$$$ 157
AutoSum button in Excel is needed to:
A) Non-graphical reporting.
B) Calculating the amount of cells.
C) Graphical representation of information.
D) Graphic construction of columns or rows.
E) AutoFill data.
$$$ 158
Sort data in Excel - is:
A) Ordering Information only ascending.
B) Streamlining the data in descending order.
C) Filtering data.
D) Ordering data in ascending or descending order.
E) Automatic data filling.
F) Calculation data.
G) Ordering data only descending.
H) Streamlining ascending data.
$$$ 159
The MAX function provides in Excel:
A) Find the shortest text.
B) Organize descending numbers.
C) The average value of search.
D) Find the highest value.
E) Organizing ascending numbers.
$$$ 160
"Save" command in Word match:
A) Ctrl + N.
B) Ctrl + P.
C) Ctrl + S.
D) Ctrl + A.
E) Ctrl + O.
$$$ 161
Topology - is:
A) Connection to computer devices.
B) The connection of devices to the computer.
C) Connection configuration of elements in the network.
D) The device is a computer.
E) Program for your computer.
$$$ 162
The network topologies are distinguished:
A) Tree.
B) Continuous.
C) Sector.
D) Bus.
E) Oval.
F) Ring.
G) Star.
H) Fully connected.
$$$ 163
According to the length of the network of communication lines are distinguished:
A) Global.
B) Hierarchical.
C) Centralized.
D) Regional.
E) Cable.
F) Local.
G) Bus.
H) Wireless.
$$$ 164
Server - is:
A) Additional computer device.
B) A variation of network topology.
C) A computer that provides services to clients.
D) Database.
E) Software.
$$$ 165
Resource Internet address consists of:
A) Host name, such as topology.
B) The file name, folder name.
C) The file name, file type.
D) File type, file name.
E) Connection type, server name.
$$$ 166
Browser - is:
A) Hypertext.
B) Program for Internet access services.
C) The topology type.
D) The cable to connect the computers.
E) Connection type.
$$$ 167
Internet Services uses the architecture:
A) Entity - relationship.
B) Demand - offer.
C) The client-server.
D) Client - a commodity.
E) Top - down.
$$$ 168
Internet Provider - is:
A) Internet Service Provider.
B) Hypertext.
C) Client.
D) Station.
E) Server.
$$$ 169
FTP - a service that:
A) Provides network services.
B) Provides the transmission of requests to the server.
C) Program to access Internet services.
D) It is intended to transfer files between computers.
E) Identify and resolve problems encountered in the network.
$$$ 170
Internet Explorer - is a tool for:
A) Creation of presentations.
B) Creation of databases.
C) Creation of graphic images.
D) File transfer between computers.
E) Scan Web-pages.
$$$ 171
Using E-mail can be:
A) Find information on the Internet.
B) Making calls to regular phones.
C) Web-page view.
D) To create presentations.
E) To send and receive messages.
$$$ 172
The Internet address of the E-mail has the format:
A) User Name // FQDN of the mail server on the Internet.
B) User Name @ FQDN of the mail server on the Internet.
C) The fully qualified domain name of the mail server in the Internet @ username.
D) The fully qualified domain name of the mail server in the Internet // username.
E) User Name $ FQDN of the mail server on the Internet.
$$$ 173
The electronic mail address before the @ sign:
A) The domain name.
B) The provider name.
C) Server name.
D) User Name.
E) Title topology.
$$$ 174
The electronic mail address after the @ sign:
A) The name of the topology.
B) The provider name.
C) Server name.
D) User Name.
E) Domain name.
$$$ 175
In Access, in the template table fields delete button of the selected fields:
A) >>.
B)>.
C) DEL.
D) <.
E) <<.
$$$ 176
In Access possible to establish a connection between the tables:
A) In any event.
B) The connection can not be established.
C) If each table is sorted.
D) If you have the same name field.
E) If there are identical records.
$$$ 177
In Access, you can enter to create a table in Design view:
A) Field names.
B) Types of data recording.
C) Field names, entries.
D) The field names, data types, descriptions.
E) Data types.
$$$ 178
In Access field names in calculated fields should be taken:
A) In quotation marks.
B) The braces.
C) In square brackets.
D) In parentheses.
E) In the apostrophes.
$$$ 179
In Access field names are allowed to:
A) 8 characters.
B) 64 characters.
C) To 255 characters.
D) 125 symbols.
E) Does not unlimited.
$$$ 180
In Access, the basic object is:
A) Form.
B) Request.
C) Table.
D) Report.
E) Macros.
$$$ 181
The Access operation of calculating the mean value:
A) SUM.
B) MIN.
C) MAX.
D) AVG.
E) COUNT.
$$$ 182
The logical OR operand is:
A) The logical multiplication.
B) Logical addition.
C) Equivalent.
D) Logical negation.
E) Or exclusive.
$$$ 183
The logical operand AND means:
A) The logical multiplication.
B) Logical addition.
C) Equivalent.
D) Logical negation.
E) Or exclusive.
$$$ 184
The language of design hypertext documents is:
A) HTTP.
B) SMTP.
C) HTML.
D) IMAP4.
E) VRML.
$$$ 185
In Access to the field names must not contain:
A) Letters.
B) Digit.
C) Point.
D)?.
E) -.
F) [].
G)!.
H) _.
$$$ 186
In Access Expression Builder is used to:
A) Sorting records.
B) Filtering records.
C) Create a calculated field.
D) Building a new record.
E) Input date.
$$$ 187
In Access the proportion (∞ - 1) corresponds to the relationship:
A) One-to-one.
B) One-to-many.
C) Many-to-one.
D) Many-to-many.
E) All answers are correct.
$$$ 188
In Access, the number of types of links:
A) 1.
B) 2.
C) 3.
D) 4.
E) 5.
$$$ 189
In Access the proportion (1 - 1) corresponds to the relationship:
A) One-to-one.
B) One-to-many.
C) Many-to-one.
D) Many-to-many.
E) All answers are correct.
$$$ 190
In Access, the line is called:
A) Field.
B) Base.
C) Records.
D) Request.
E) Macros.
$$$ 191
In Access, a column called:
A) Field.
B) Base.
C) Records.
D) Request.
E) Macros.
$$$ 192
In Access, the key field is used to:
A) The links between tables.
B) Filtering records.
C) Replacement of records.
D) Records search.
E) Creating forms.
$$$ 193
In Access sampling means is:
A) Table.
B) Form.
C) Request.
D) Report.
E) Module.
$$$ 194
In Access function COUNT:
A) Calculates the sum of all the numbers.
B) Calculate the average value.
C) Count the number of records.
D) Defines the minimum value.
E) Defines the maximum value.
$$$ 195
In Access mode allows you to change the layout of the table, query, report:
A) Filtering mode.
B) Mode Wizard.
C) Help mode.
D) Design mode.
E) Chart mode.
$$$ 196
In Access, the main difference between AutoForm regime in the column of the table mode:
A) Does not differ.
B) Allows you to view only a single record.
C) Allows you to view multiple records simultaneously.
D) Allows you to view only a single field.
E) Opens view multiple fields of different records.
$$$ 197
The process of creating a table in Access by choosing from existing fields:
A) Mode of the table.
B) Table Design.
C) Link Tables.
D) The template tables.
E) AutoForm.
$$$ 198
In Access to include the desired field in the request form should be: A) Drag the field from the table in the appropriate column of the query. B) Click once on the desired field of the left mouse button. C) Click once on the desired field of the right mouse button. D) Copy the field from the table in the appropriate column of the query. E) Double-click on the desired field in the table. F) Using the context menu.
$$$ 199
Database management system - is:
A) MS Excel.
B) MS Access.
C) MS Word.
D) MS Photo Editor.
E) Word Pad.
$$$ 200
In Access, there is a data type: A) the Index. B) The text. C) Logical. D) A real. E) The counter. F) A calendar. G) The whole. H) A valid.