Информатика РК2 тесты



<discipline>Informatics

Access. What type of the field is used for insertion of the long text?

+ MEMO

— logical

— text

— numeric

— field OLE

\/Access. What field is used for keeping multimedia?

+ field OLE

— MEMO

— logical

— text

— numeric

\/Access.What objects is a source date for the form:

+ Tables and requests

— field OLE

— reports

— reports and macros

— reports and other forms

\/Access.What field is used for making the relationships between table:

+ Key

— MEMO

— logical

— text

— numeric

\/Access. What create the form by means of master:

+ Form, create, master of the forms

-Date, enter, master of the forms

— Date, master of the forms

— Date, create, means of master

— Form, means of master

\/Access. What command is realized performing the request

+Request-Start

— Request-Paste

— Start – Paste- Request

— Start – Paste

— Start — Performing the request

\/The Database created in MS Assess 2003 has an expansion:

+ mdb

-xls

-doc

-txt

-ddm

\/Managerial system of database

+MS Access

-MS PowerPoint 

-WinRar,

-WinZip

-MS Excel

\/What is program archivers

+WinRar, WinZip

-MS Access

-MS PowerPoint 

-MS Excel

-ITOG.rar

\/A structured collection of interrelated data within a certain area, intended for long-term storage in an external COMPUTER memory and permanent use

+ database

— logical

— text

— numeric

— field OLE

\/Where the data is stored in database?

+ table

— logical

— text

— numeric

— field OLE

\/How you can work with the database after creating tables?

+sorting and filtering

— numerical and saving

— saving

— numerical and search

— search and saving

/\ Computer program for storing information in an easily retrievable form.

+ database

-table

-spreadsheet

-text editor

/\ The relational database management system, which allows you to link together data stored in more than one table.

+Microsoft Access

-MS PowerPoint 

-WinRar,

-WinZip

-MS Excel

/\ Which objects hold the raw data in Microsoft Access?

+Tables

-Queries

-Forms

-Reports

-Forms Pages

/\ Which objects reflect any changes to the data in the tables Microsoft Access?

+Queries

-Tables

-Forms

-Reports

-Forms Pages

/\ Which objects user-friendly layouts to display data on the screen Microsoft Access?

+Forms

-Queries

-Tables

-Reports

-Forms Pages

/\ Microsoft Access. Which objects output files, ready for printing ?

+Reports

-Forms

-Queries

-Tables

-Forms Pages

/\ Which objects for creating/editing WWW pages in Microsoft Access.

+ Reports Pages

-Forms Pages

-Queries Pages

-Tables Pages

/\Programs which expert users write in a programming language called Access Basic to perform tailor-made functions not generally available

+Modules

-Forms

-Queries

-Tables

-Forms Pages

/\What is belonging of Cell Contents in MS Excel?

+ Number, Textand Formula

— Numbers,Page and Function

— Function, Simbol and Formula

-Tables, Simbol and Formula

-Forms Pages, Simbol and Formula

/\ A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value in MS Excel.

+Formula

-Number

-Text

-Function

-Simbol

/\ MS Excel. A formula always begins with…

+ An equal sign

— the Line

— the Sheet

— End of the Work

/\ MS Excel. The values that a function uses to perform operations or calculations.

+Argument

-Number

-Text

-Function

-Simbol

/\ MS Excel. Types of Data Filter

+ Auto Filter and Advanced Filter

— Filter and Advanced Date

— Advanced Filter and Date

— Date Filter and Advanced Date

— Filter Date and Advanced

/\ MS Excel. Miscellaneous it is…

+ Validation, Protection

— Filter and Advanced Date

— Advanced Filter and Date

— Date Filter and Advanced Date

— Filter Date and Advanced

/\ Microsoft Access. This objects allow the user to view, change, and analyze data in different ways, such as combining data from two different tables

+ Queries

-Forms

-Tables

-Forms Pages

/\ Microsoft Access. This objects allow users to enter, change, or update data.

+Forms

-Queries

-Tables

-Forms Pages

/\ Microsoft Access. Now that you have all of your data stored in a database, you need to have a way to view it is…

+Reports

-Queries

-Tables

-Forms Pages

/\MS Power Point. Object Animation is…

+Animation Scheme

-Queries Scheme

— Animation Tables

— Forms Pages

-Continuous Presentation

/\ MS Power Point. Command of Continuous Presentation

+ Slide Show, Setup ShowLoop

— Slide, Setup, continuously until Esc

— Slide Show, until Esc

— Setup ShowLoop, continuously until Esc

/\ World wide network that connects millions of computers to share and exchange data, news, opinions, and research results.

+ The Internet

-net

— The aria net

-Appronet

-local net

/\ The Internet has new information every day. To read information on the Internet you need a program such as

+Internet Explorer, Mozilla Firefox, Google Chrome, Opera

— Internet Firefox, Google Opera

— Explorer, Firefox, Google Opera

— Internet Mozilla Firefox, Google Opera

/\ Service that is provided on the internet and it is not same as the

+WWW

-Internet

-Internet Firefox

— Google Opera

— Opera

/\ Are you connected to the Internet by telephone line or cable line?

+Online

-Internet

-Internet Firefox

— Google Opera

— Opera

/\ Are you using your computer but are not connected to the Internet.

+ Offline

-Online

-Internet

— Google Opera

— Opera

/\ A business, government or person’s page on the Internet where you can put information for people to read.

+Web site

-Online

— Web

— Web Google

— Opera

— Offline

/\One page of a web site

+Web page

-Web site

-Online

— Web

— Web Google

— Opera

/\It is an information sharing model that is built on the op internet.

+WWW

-Internet

-Internet Firefox

— Google Opera

— Opera

/\Commercial organizations domain

+com

-Kz

-edu

-cun

-kom

/\ Domain for educational institutions

+ edu

-com

-Kz

-cun

-kom

/\ Domain for government agencies

+gov

-Kz

-cun

-kom

/\ Domain for network access provider

+net

-Kz

-edu

-cun

-kom

/\ Domain for non profit organizations.

+org

-Kz

-edu

-cun

-kom

/\File Extension of Web browser

+ .html, .htm, .php, .asp, .xml.

— .ktml, .itm, .hp, .hsp, .xml.

— .xtml, .htm, .php, .jsp, .uml.

— .oml, .xhtm, .php, .tas, .hml.

\/Hypertext Preprocessor

+.php,

-html,

-.htm,

-.asp,

-.xml

/\Extensible Markup Language

+.xml

-html,

-.htm,

-.asp,

-.jml

/\There is a lot of good information on the Internet, but there is also some bad information. If you go to a web site that you don’t like, leave that web site and go to a better.

+Safety on the Internet

-Change date on the Internet

-Use internet security for virus.

-Change date on the Internet for virus.

/\ Malicious software that attaches itself to other software.

+ VIRUS DISSEMINATION

-Safety on the Internet

-SOFTWARE PIRACY

-NET EXTORTION

/\ Where is the Quick Access Toolbar and when should you use it?

+ It is in the upper-left corner of the screen, and you should use it for your favorite commands.

-It floats above your text, and you should use it when you need to make formatting changes.

-It is in the upper-left corner of the screen, and you should use it when you need to quickly access a document

— It is on the Home tab, and you should use it when you need to quickly launch or start a new document.

— It is the Show Picture Tools command on the Insert tab.

/\ The Mini toolbar will appear if:

+You select text and then point at it.

-You double-click the active tab on the Ribbon.

-You select text.

-Any of the above.

— You select a new document.

/\ A new tab will appear on the Ribbon if:

+You select a picture.

-You click the Show Picture Tools command on the Insert tab.

-Either the first or the third option click a picture

-You right choose Picture Tools.

-You select text.

/\ Which button is used to save our documents?

+Microsoft Office Button

-Home Button

-Insert Button

— Picture Tools Button

— Tools command Button

/\ Which tabs on the Ribbon you find the Zoom?

+View

-Zoom

-Tab

-Insert

-Microsoft Office

/\ Which tabs on the Ribbon do we use to change our font size?

+Home

-Format

-Font

-Zoom

-Tab

/\ What is MS Word?

+It is a typing tool

— It is a calculating tool

-It is a computerized tool

— It is a tool font size

/\ Which tabs on the Ribbon do we use to cut and paste?

+Home

-Format

-Font

-Zoom

-Tab

/\ Which of the following is an input device?

+Keybord

-Speakers

-Monitor

-Printer

-dpi

/\ Which of the following has the highest memory capacity?

+Internal hard disk

-Floppy disk

-diskets

-DVD

-dpi

/\ Which of the following is used to measure hard drive capacity?

+Gigabyte

-bps

-Gigahertz

-dpi

/\ Refers to a number of bytes that can be stored on a storage device.

+Gigabyte

-bps

-Gigahertz

-dpi

/\ Measure of bits per second and is used to measure transmission speeds.

+bps

-Gigabyte

-Gigahertz

-dpi

/\ Measures of processor speed.

+Gigahertz

-bps

-Gigabyte

-Hertz

-Byte

/\ The tower contains the

+ processor, hard drive, memory and expansion cards

-bps ,Gigabyte, Hertz

-Byte, Bit, Mouse

— Mouse, Keybord, DVD

— Floppy disk, diskets, Mouse, Keybord

/\ What is A1 in sheet of MS Excel ?

+Cell address

-Measures

-processor speed

-Row address

-Measures address

/\ Since the button to Print is not readily available in the toolbar, you would click ………. to locate the Print function

+the Office button

— the Format button

— the Font button

— the Zoom button

— the Tab button

/\ You are currently using in MS Excel Sheet1 of…

+ Book1

— Book 3

— Office book

— currently book

/\ Which key loads the help system.

+F 1

-F5

-F7

-F 4

/\ The little arrow on the right of the Alignment group heading on the Home tab.

+Alignment button

-Alignment Home tab

-Alignment arrow

— Alignment arrow heading

/\ What is a sequence of values, cell references, names, functions, or operators in a cell that together produce a new value in MS Excel?

+Formula

— Button

— Home tab

-Alignment tab

— Function

/\ Is a vector graphics editor developed and marketed by Corel Corporation of Ottawa, Canada?

+ Corel Draw

— Paint

— Photo shop

— Corel editor

/\ In Corel Draw a full range of editing tools allow the user to adjust contrast, color balance, change the format from …

+RGB to CMYK

-BMP to CMYK

-CMYK to htp

-RGB to IPJ

-RGB to BMP

/\ In Corel Draw Bitmaps can also be edited more extensively using

+Corel Photo Paint

-Corel Paint graph

— SS Photo Paint,

— Photo Paint editor

/\ Which of these programs is a graphical editor?

+ CorelDraw

— DoctorWeb

— АVР Касперского

— Microsoft Word

— WinZip

/\ Links to Internet resources can be saved by choosing the browser Іnternet Explorer — this menu

+ Shortlist.

— Magazine.

— Folders.

— Service

/\ Program for of detecting and disinfecting viruses:

— Е-Маіl, PowertWeak

— Use Net, Cache Man

+ DrWeb

— Graphics, Word

— Сhаt, Excel

/\ Programs which are capable of detecting files infected by one of several viruses

+ Program — Detectors

— Virus files

— Programs — vaccine

— Program archive

— Programs — viruses

/\ Local area network (LAN) — is:

+ Computer network functioning within the limits departments.

— Regional association networks.

— Association of computer networks at the state level.

— Association networks area.

— Global computer network.

/\ PC with high capacity HDD, which can store applications and files available to other PCs in the network

NICs.

+ The server.

— Modem.

— Network Operating Systems.

— The concentrates.

/\ E-mail is:

+ Agent communication between remote subscribers

— List of search engines

— Program for access to newsgroups

— Program access to search engines

— Viewer WEB pages

/\ he main object for any database:

+ Table.

— Request.

— Forms.

— Macros.

— Tasks.

/\ For each computer connected to the Internet, set two addresses:

+ Digital and domain

— Line and domain

— User and domain

— Digital and user

— Character and domain

/\ Program for viewing Web — pages:

+ a browser.

— Web — surfing.

— Link to hypertext.

— Hypertext.

— a server.

/\ Which of the following programs are programs — archive:

+ WinRAR

— Norton Commander

— Corel Draw

— ScanDisk

— MathCadPro

/\ The main characteristic of the modem:

+ The number of bits transmitted per 1 second

— Quantity of information bytes

— Resolution

— Information storage

— The number performed in 1 second teams

/\ Which mode you can establish a relationship between tables in Ms Access?

+ Scheme for data

— View for data

— Form builder

— Query Designer

— Table for data

/\ What section of the form has the main volume the data in MS Access?

+ Data Area

— The main section

— Header and Footer

— Columns

— Data Section

/\ What object is used to group several commands in MS Access?

+ macros

— reports

— table

— forms

— quire

/\ Which device is used to connect a computer to a LAN?

+ the network adapter

— Graphic Tablets

— the motherboard

— the port

— a slot

/\ Which network topology you know?

+ Bus, ring, star.

— Bus asymmetry.

— Service.

— Ring asymmetry star.

— In the form of an oval.

/\ Which mode Access can not enter data into the table?

+ The constructor

— Edit mode

— Selection Mode

— Table

— Key Field

/\ Expansion of archive files:

+ *. Zip, *. Arj, *. Rar;

— *. Bat, *. Ini, *. Txt.

— *. Sys, *. Іnі *. Sfg;

— *. Doc, *. Hlt, *. Bmp;

— *. Exe, *. Som *. Bat

/\ Telnet-it:

+ Services remote computer control.

— Variety LAN.

— Postal Service.

— A special service for the transmission of graphic information.

— One of the global networks.

/\ The object which does not relate MS Access:

+ Scheme.

— Macros.

— Report.

— Query.

— Form.

/\ An object that contains a description of the action in the MS Access:

+ Macro.

— Table.

— Form.

— Report.

— Query.

/\ Programs are designed protection against virus attacks

+ Antivirus programs

— Applications

— Instrumental Program

— The archiver

— Program-shell

/\ What do you call an organization that has IP — address?

+ Provider;

— Firewall;

— Gateway;

— Does;

— Navigato

/\ What is the purpose of reports in MS Access?

+ To create print copies of information from the database

— To collect and analyze data

— To populate the database tables

— To display the query

— To analyze the information

/\ Which objects are the data sources for the form:

+ Tables and queries

— Tables and Reports

— Queries and Reports

— Tables and Modules

— Reports and modules

/\ What form of graphic do you store photos on your computer:

+ Raster;

— Vector image;

— Databases;

— Illustrations;

— Analog images;

/\ How to start the program MS Access 2007?

+ Start > All Programs > Microsoft office > Microsoft office Access 2007

-Microsoft office > Microsoft office All Programs > Microsoft office Access 2007

— Scheme for data > Microsoft office Access 2007

— All Programs > Microsoft office Access 2007 > Microsoft office

— Start > Programs > office > Access 2007

/\MS Access. Field or set of fields which uniquely identify (determine) a table entry.

+primary key

-second key

-shared key

-shape keys

/\ MS Access. Rules that protect your information from accidental changes or deletions by a support mechanism correctness connection between the related tables.

+ Data Integrity

— Deleting Data

— Sorting Data

— Receive data

— The amount of data

/\ MS Access.Relationship between the tables when a single record from a primary table corresponds to only one record from the subordinate table.

+ Attitude «one — to — one»

— Attitude «many — to — many.»

— Attitude data

— Related relationships

— All relationships

/\ MS Access.Relationship between database tables at each time one copy of the information object A corresponds to 0.1 or more instances of B and vice versa.

+ Attitude «many — to — many.»

— Attitude «one — to — one»

— Attitude data

— Related relationships

— All relationships

/\ MS Access. In order to create a database on the basis of a standard template using command ….

+Local templates

-data templates

-current patterns

-template Wizard

/\ There are two modes display reports

+preview mode and design mode

-read-only mode and typing mode

-The constructor and view mode

— preview mode and typing mode

/\ What do you call plugs, which are installed at the ends of the bus?

+ Terminators;

— Transformer;

-Switches;

-Adapter;

-Chipset;

/\ Vector Art are created and edited by means of professional applications:

+ CorelDraw, Adobe Illustrator;

— Paint;

— Word art;

— Объектов OLE;

— Объектов МЕМО;

/\ Graphic Editors

+ Designed for creating and editing images (drawings);

— Designed to create text;

— Designed for document editing;

— Intended only for creation;

— There is no right answer;

/\ CorelDraw.Abris it is the tool allows you to….

+ Set the color and style of the outline of an object;

— Obtain optimal image sizes;

— Move the image on the screen;

— Create and edit transitions between objects;

— Control of the object, not the whole object;

/\ CorelDraw.Oval in the drawing will turn in a circle if you hold down:

+ the Ctrl key;

— the ALT key;

— the toolbar to Circle;

— the TAB key;

/\ CorelDraw. Drawing Bezier curves is:

+ Create smooth curves, which defines the start and end point of the curve;

— Very similar to drawing with a pencil;

— With automatically calculated line length and slope;

— Trunks used in flowcharts and diagrams;

/\ CorelDraw. A node when drawing Bezier curves called smoothed if:

+ Tangent to the two adjoining segments lie on one line;

— A tangent to the node two adjoining segments are not  lie on a line forming an angle different from the deployed;

— It guides the point equidistant from him;

— If it is an end segment;

— The segments intersect at right angles to it;

/\ When and by whom was created the first version of the spreadsheet?

+ In 1979 by Dan Briklenom

— Bill Gates, 1980

— In 1945 by American mathematician

— 1990 Belgian programmers

— 1945 John von Neumann

/\ How many generations of PC?

+5

-6

-4

-5.5

/\ Where is Toolbar in the Quick Access?

+ It is in the upper-left corner of the screen

-It floats above your text

-It is in the upper-left corner of the screen

— It is on the Home tab

— It is the Show Picture Tools command on the Insert tab.

/\ Minimal object of spreadsheet MS Excel

+cell

-line

-column

-field

-the range of cells

/\ MS Excel. Changing the position of the cell that contains a formula that changes the cell link. What addressing is used in these cells?

+relative addressing

-absolute addressing

-addressing mixed

-dual addressing

-Easy addressing

/\

MS Excel. When you change position of the cell that contains the formula does not change the cell link.

+absolute addressing

-relative addressing

-addressing mixed

-dual addressing

-Easy addressing

/\Select cells relative addressing

+V5

-A$4

-$D3

-$A$16

-$B6$

/\Select absolute addressing cells

+$A$16

-A$4

-$D3

-$B6$

-G4

/\ Select mixed cell addressing

+ A$4

-$A$16

-$DG

-$B6$

-G4

/\MS Excel. Chart can be placed

+ in a sheet with a table and in a separate sheet

-only on the sheet with the table

— only in a single sheet

— on the next sheet

— in a Word document and in a separate sheet

/\ MS Excel. The frame that identifies the patterns or colors or categories of data series in the chart, it named…

+ legend of the graph

— table of the chart

— axis of the chart

— data labels in a char

-art title

/\ Current (active) cell in Microsoft Excel

+ Cell which the cursor is located

-any cell

— Cell that contains the text

-Cell that contains a formula

-Cell, which contains data

/\ If the file name contains an extension of the PDF or DOC, is the file that contains ..

+text

— music

-image

-Video

/\ If the file name contains an extension bmp or gif, this file contains the…

+ image

-program

— music

-text

\/ Why MS Access Relational Database?

+ date store in the table

— date store in the form

— date store in the gluier

— date not store in the table

/\ Property of the fields in the database MS Access.

+ Name of field

— Row of field

— Text of field

— Data of field

/\ Type of field for stores the monetary units the database MS Access.

+ Monetary

— Monies

— Program

— Music

— Text

/\ What objects has not the MS Access?

+ Button

-Report

-Table

-Queries

-Macros

/\ The database files in the database

+ a specific format

— Many table

— a specific program

— a specific table

-a specific fields

\/

/\ What data processing spreadsheet MS Excel?

+The text, numbers, graphics, multimedia

-formulas and functions

-graphics, pictures, music

-mathematical functions

/\What sign starts recording spreadsheet formula MS Excel?

+ =

— <>

— <=

— ??

— /

/\How do we introduce the function in the MS Excel?

+ Using the wizard function

— Using the wizard formula

— Using the wizard diagram

— Using the wizard master

/\ What used to create graphs and charts in the MS Excel?

+ Using the wizard diagram

— Using the wizard formula

— Using the wizard function

— Using the wizard master

/\ MS Access.How we print out documents in the program MS Excel?

+ Using the options Page Setup

— Using the options Page Start

— Using the wizard function

— Using the options wizard

— Using the wizard master

/\

MS Access. To create relationships between tables, click on the button:

+ Data scheme

— Communication, create

— Open the table

— Table connection

— Designer

/\ MS Access is used to change the structure of the database mode?

+ Designer View

— Forms

— Master

— Editing keys

— table

/\ Filters are used in MS Access:

+ To display only certain records

— Searching for the information in the table

— To sort the records

— Replacement of data in the database

— To create relationships between tables

/\The field is used for insertion of the long text in the database.

+ MEMO

— logical

— text

— numeric

— field OLE

/\Access. What field is used for store photos and picture?

+ field OLE

— MEMO

— logical

— text

— numeric

/\Objects for store date in the database form.

+ Tables and requests

— field OLE

— reports

— reports and macros

— reports and other forms

/\What field is used to communication table in the database:

+ Key field

— MEMO field

— logical field

— text field

— numeric field

/\Access. What create the table by means of master?

+ Table, create, master of the table

-Date, enter, master of the forms

— Date, master of the forms

— Date, create, means of master

— Form, means of master

/\Access. Command for real to performing the request.

+Request-Start

— Request-Paste

— Start – Paste- Request

— Start – Paste

— Start — Performing the request

/\The Database expansion:

+ mdb

-xls

-doc

-txt

-ddm

/\One of type DMS

+MS Access

-MS PowerPoint 

-WinRar,

-WinZip

-MS Excel

/\ Microsoft Access. Which objects analyze the dates and printing the dates?

+Reports

-Forms

-Queries

-Forms Pages



Страницы: 1 | 2 | 3 | ... | | Весь текст




sitemap
sitemap