Questions for testing the department of informatization. Information technology test in professional activities. The computer drawing system is designed for

Details Computer Science Tests with Answers 15 October 2015 Views: 34476

Topic 1. Informatization of society, basic concepts and definitions

Test 1. The goal of informatization of society is

1 fair distribution of material wealth;
2 meeting the spiritual needs of a person;
3 maximum satisfaction of the information needs of individual citizens, their groups, enterprises, organizations, etc. through the widespread introduction of computers and communications.

Test 2. Which law reflects the objectivity of the process of informatization of society

1. The law of diminishing returns.
2. The law of cyclical development of society.
3. The law of “necessary diversity”.
4. The law of unity and struggle of opposites.

Test 3. Data about objects, events and processes is

1 content of knowledge bases;
2 unprocessed messages reflecting individual facts, processes, events;
3 preprocessed information;
4 messages in data stores.

Test 4. Information is

1 messages in the computer's memory;
2 messages located in data storages;
3 preprocessed data suitable for making management decisions;
4 messages recorded on machine media.

Test 5. The economic indicator consists of

1 attribute-attribute;
2 graphic elements;
3 arithmetic expressions;
4 requisites-base and props-signs;
5 props-bases;
6 of one base attribute and related attribute attributes.

Test 6. Indicate the correct characteristic of the basic element of the economic indicator

1. Props-base determines the quality side of the object or process.
2. Props-base determines the quantitative aspect of an object or process.
3. Props-base determines the temporal characteristics of an object or process.
4. The base attribute defines the connection between the processes.

Test 7. Indicate the correct characteristic of the attribute-attribute of the economic indicator

1. The attribute-attribute determines the quality side of the object or process.
2. The attribute-attribute defines the quantitative aspect of an object or process.
3. The attribute-attribute determines the temporal characteristics of an object or process.
4. The base attribute defines the constituent elements of the object.

Test 8. What dictates the need to separate economic indicators from management documents in the process of setting the task

1 to identify structural units generating management documents;
2 striving for the correct formalization of calculations and execution logical operations;
3 the need to protect information.

Test 9. To solve the problem, the following documents are used:

1.Individual outfit for piecework.
2. Brigade outfit for piecework.
3. Tariffs for the manufacture of parts.
4. Reference book of details.
5. Calendar of working days.

Test 10. To solve the problem, the following documents are used:

1. Nomenclature-price tag.
2. Detail-by-operation rates of material consumption.
3. Invoice for the arrival of materials to the warehouse.
4. Invoice for the delivery of materials from the warehouse to the workshop.

Test 11. What human knowledge is modeled and processed using a computer

1 declarative;
2 procedural;
3 unconscious;
4 intuitive;
5 associative
6. fuzzy.

Test 12. What is the definition of an information system given in the Federal Law "On Information, Informatization and Information Protection"

1. An information system is a closed information circuit consisting of a straight line and feedback, in which, according to information technology, management documents and other messages circulate in paper, electronic and other forms.
2. An information system is an organizationally ordered set of documents (an array of documents) and information technologies, including using the means computing technology and communication implementing information processes(the process of collecting, processing, accumulating, storing, searching and distributing information).
3. Information system - an organizational and technical system designed to perform information and computing work or provide information and computing services;
4. An information system is a set of external and internal direct and reverse information flows, the management apparatus of an organization with its methods and means of information processing.

Test 13. What is the correct definition of the information business

1. Information business is the production and sale of computers.
2. Information business is the provision of infocommunication services.
3. Information business is the production, trade and provision of information products and services.
4. Information business is trade in software products.

Test 14. Indicate the correct definition of the information market

1. The information market is understood as a set of manufacturers offering infocommunication services.
2. The information market is understood as a set of entities that supply computer technology.
3. The information market is understood as a network of trade enterprises that implement software.
4. The information market is understood as a set of business entities offering customers computers, communications, software, information and consulting services, as well as service maintenance hardware and software.

Test 15. Specify the functions performed by the information manager of the enterprise

1. Planning the implementation and modernization of the information system, its search in the market software products.
2. Assessment of the software market using marketing tools.
3. Development of applied programs.
4. Acquisition of information technology from the necessary functions and properties.
5. Development of operating systems.
6. Organization of the implementation of the information system and staff training.
7. Ensuring the operation of the information system: administration, testing, adaptation, security organization, etc.
8. Updating the existing information system, introducing new versions.
9. Decommissioning of the information system.

Topic 2. Information systems, their structure and organization

Test 1. Indicate the principle according to which a functional task information system can be created

1 efficiency;
2 block;
3 integrated;
4 task by task;
5 process.

Test 2. Indicate the principle according to which an integrated information system is created

1 efficiency;
2 block;
3 integrated;
4 task-by-task;
5 process.

Test 3. Indicate the enterprise management functions that support modern information systems

1 planning;
2 bonuses;
3 accounting;
4 analysis;
5 distribution;
6 regulation.

Test 4. Business process is

1 set of management procedures and operations;
2 many actions of management personnel;
3 a set of actions linked into a single whole, the implementation of which allows you to obtain the final result (product or service);
4 a set of works performed in the production process.

Test 5. What information system does the following definition correspond to: a software and hardware complex capable of uniting into one whole enterprises with different functional focus (production, trade, credit and other organizations)

1. Information system of an industrial enterprise.
2. Information system of a commercial enterprise.
3. Corporate information system.
4. Information system of the credit institution.

Test 6. What information networks are used in corporate information networks

1. Local LANs ( Local Area Net).
2. Regional scale of the city MAN (Metropolitan Area Network);
3. Global (Wide Area Network).
4. Trading networks - ETNs (Electronic Trading Networks).
5. Automated trading networks ECN (Electronic Communication Network).
6. Railway networks.
7. Road networks.

Topic 3. Creation, implementation, assessment and selection of information systems

Test 1. System analysis assumes:

1 object description using mathematical model;
2 description of the object using the information model;
3 consideration of the object as a whole, consisting of parts and
separated from environment;
4 description of the object using a simulation model.

Test 2. Specify the correct system definition

1. A system is a set of objects.
2. A system is a set of interconnected elements or
subsystems that work together to achieve a common goal.
3. The system is not interconnected elements.
4. The system is a set of processes.

Test 3. An open information system is

1. A system that includes a large number of software products.
2. A system that includes various information networks.
3. A system based on international standards.
4. A system focused on operational data processing.
5. A system designed to issue analytical reports.

Test 4. What are regulated by international standards in information systems

1. Interaction information systems of different class and level.
2. The number of technical means in the information system.
3. Interaction of applied programs within the information system.
4. The number of personnel providing information support to the control system.

Test 5. Indicate the opportunities provided by open information systems

1. Data mobility, which is the ability of information systems to interact.
2. Mobility of programs, which consists in the possibility of transferring application programs and replacing technical means.
3. User mobility, which consists in providing a friendly interface to the user.
4. Extensibility - the ability to add (increase) new functions that the information system did not have before.
5. Efficiency of input of initial data.
6. Intelligent data processing.

Test 6. The standards profile is intended for

1 taking into account the specifics of the served management functions at a particular enterprise in the information system;
2 organizing the supply of software products;
3 organization of work of management personnel;
4 meeting the requirements for building open systems.

Test 7. Indicate the standard life cycle processes of the information system used in the process of its creation and functioning

1. Basic production processes.
2. Basic processes life cycle.
3. Supporting life cycle processes.
4. Ancillary marketing processes.
5. Organizational processes of the life cycle.
6. Organizational cycles of logistics.
7. Planning processes.
8. Accounting processes.

Test 8. Business reengineering is

1. Radical revision of accounting methods.
2. Radical revision of planning methods.
3. Radical revision of methods of analysis and regulation.
4. Radical redesign of the information network.
5. Radical redesign of existing business processes.

Test 9. Specify the correct definition of an ERP system

1. Information system providing customer relationship management.
2. An information system that provides planning of production capacity requirements.
3. An integrated system that provides planning and management of all resources of the enterprise, its supply, sales, personnel and wages, production, research and development.
4. Information system for supply management.

Test 10. Indicate the characteristics of the information system that can be used to assess and select

1. Functionality.
2. Quantity software modules.
3. Data formats.
4. Reliability and safety.
5. Practicality and convenience.
6. Database structure.
7. Efficiency.
8. Maintenance.

Topic 4. Information technologies and their basic software

Test 1. Information technology is

1. A set of technical means.
2. A set of software tools.
3. A set of organizational tools.
4. Lots of information resources.
5. A set of operations for collecting, processing, transferring and storing data using methods and automation tools.

Test 2. Specify information technologies that can be classified as basic:

1. Word processors.
2. Tabular processors.
3. Transactional systems.
4. Database management systems.
5. Control software systems.
6. Multimedia and Web-technologies.
7. Decision making systems.
8. Expert systems.
9. Graphics processors.

Test 3. Indicate which of the listed methods of control over the input of initial information uses the correspondence to the range of correct values ​​of the variable

1. Method of checking boundaries ("fork" method).
2. Reference method.
3. Method for checking the structure of the code.
4. Checksum method.

Test 4. For what purpose is the data sorting procedure used?

1. To enter data.
2. For data transmission.
3. To get the results of different levels.
4. For data control.

Topic 5. Information resources of enterprises and organizations

Test 1. What definition of information resources of the society corresponds to the Federal Law "On Information, Informatization and Protection of Information"

1. Information resources of society are information of various nature, materialized in the form of documents, databases and knowledge bases.
2. Information resources of the society are individual documents and separate arrays of documents, documents and arrays in information systems (libraries, archives, funds, data banks and other systems), created, acquired at the expense of the federal budget, budgets of the constituent entities of the Russian Federation.
3. Society's information resources are the many websites available on the Internet.
Test 2. Indicate the existing information resources in the enterprise
1. Own.
2. External.
3. Technical.
4. Software.
5. Organizational.

Test 3. Out-of-machine information resources of the enterprise are

1. Management documents.
2. Databases.
3. Knowledge base.
4. Files.
5. Data warehouses.

Test 4. Internal machine information resources of the enterprise are

1. Databases.
2. Web sites.
3. Knowledge base.
4. Design documents.
5. Data warehouses.
6. Accounting and financial documents.

Test 5. Own information resources of the enterprise are

1. Information from suppliers.
2. Information generated within the enterprise.
3. Information from clients.
4. Information coming from the Internet.

Test 6. External information resources of the enterprise are

1. Information acquired externally.
2. Information received from third parties.
3. Information received from the Internet.
4. Information generated using OLAP technologies.
5. Orders for admission to work.

Test 7. Choose the correct definition of the process of coding economic information

1. Encoding is encryption.
2. Coding is assignment symbol nomenclature objects.
3. Coding is a search for classification features.
4. Coding is the assignment of classification characteristics.

Test 8. Choose the correct characteristic of the positional coding system of economic information

1. Reflects the serial numbers of the encoded item.
2. Reflects the hierarchical subordination of classification features
3. Reflects the numbers of the series of the coded item.
4. Reflects the mnemonics of the encoded item.

Test 9.What is the purpose of encoding information

1. Reducing labor costs when entering information.
2. Simplification of computing operations.
3. Simplification of data sorting procedures.
4. Convenience of procedures for processing management documents.
5. Simplification of data transfer procedures.

Test 10. Specify the functions of electronic document management

1. Solving applied problems.
2. Storage electronic documents in the archive.
3. Search for electronic documents in the archive.
4. Organization of the solution of transactional problems.
5. Routing and transfer of documents to structural units.
6. Monitoring the execution of orders.
7. Organization of the solution of analytical problems.

Test 11. Indicate the common forms of intramachine presentation of structured information resources

1. Databases.
2. Traditional paper management documents.
3. Knowledge base.
4. Texts of orders entered into the computer.
5. Data warehouses.
6. Web sites.

Test 12. Indicate the main feature of databases

1. Orientation to data transmission.
2. Orientation to operational data processing and work with the end user.
3. Orientation to data mining.
4. Orientation on providing analytical information.

Test 13. Indicate the main feature of data warehouses

1. Orientation to operational data processing.
2. Orientation to analytical data processing.
3. Orientation to interactive data processing.
4. Focus on integrated data processing.

Test 14. Indicate the concepts that characterize the relational database model

1. The name of the table (relationship).
2. File.
3. Attribute.
4. Tuple.
5. Vector.
6. Matrix.
7. Domain.

Test 15. For what purpose are database management systems created?

1. Creation and processing of databases.
2. Ensuring data integrity.
3. Data encoding.
4. Data transmission.
5. Data archiving

Test 16. The centralized database is characterized by

1. Optimal size.
2. Minimal cost to correct data.
3. Maximum cost of data transmission.
4. Rational structure.

Test 17. The distributed database is characterized by

1. Optimal size.
2. The minimum cost of data transmission.
3. Maximum cost of data correction.
4. Hierarchical structure.
5. Data confidentiality.

Test 18. Data in data warehouses is in the form

1. Hierarchical structures.
2. Network structures.
3. Multidimensional databases (hypercubes).
4. Data charts.

Test 19. The semantic network of the domain is

1 model for data presentation;
2 a model for representing knowledge;
3 means for on-line data processing;
4 tool for solving computational problems.

Test 20. The inference tree is used to

1 obtaining new knowledge in conditions of certainty;
2 obtaining new knowledge in conditions of uncertainty;
3 gaining new knowledge in conditions of risk;
4 gaining new knowledge in confidentiality.

Test 21. The membership function is used for

1 solving equations;
2 information retrieval;
3 reflections of fuzzy information;
4 calculations of economic indicators.

Topic 6. Infocommunication technologies of control systems

Test 1. Infocommunication technologies operate on the basis of

1. Means of access to databases.
2. Information technology.
3. Networks and telecommunications equipment.
4. Data warehouses.

Test 2. Indicate directions in the development of infocommunication technologies

1. Electronic business.
2. Solving economic problems.
3. Banking network settlements.
4. Making decisions using expert systems.
5. Distance learning and work execution.

Test 3. A virtual enterprise is

1. Hierarchical association of various enterprises.
2. Corporate association of various enterprises.
3. Networking based electronic means communication of several traditional enterprises specializing in various fields of activity.
4. Non-existent enterprise.
5. Machine-building enterprise.

Test 4. How costs change as a result of the use of infocommunication technologies

1. Increase.
2. Distributed.
3. Disappear.
4. Accumulate.
5. Decrease.

Topic 7. Solving economic problems on the basis of basic software tools

Test 1. Information models are designed for

1 mathematical reflection of objects;
2 mathematical reflection of the structure of phenomena;
3 reflections of information flows between objects and
relations between them;
4 meaningful reflection of relationships between objects;
5 reflections of the qualitative characteristics of the processes.

Test 2. Indicate information models, the development of which is governed by agreements adopted in the practice of creating information systems

1. Network models.
2. Hierarchical models.
3. Relational models.
4. Diagrams of data flows.
5. Graph models.

Test 3. Specify the elements that make up data flow diagrams

1. Object.
2. Distributor.
3. Process.
4. Storage device.
5. Data flow.
6. Adder.
7. Integrator.

Test 4. The graph is

1. Drawing.
2. Many unconnected points.
3. Lots of relationships.
4. Lots of connections.
5. The set of points over which the relationship is set.
6. Scheme.

Test 5. The direct economic problem is characterized by

1. Parallel computing.
2. Calculations from private to general.
3. Consecutive calculations.
4. Calculations from general to specific.
5. Formation of information about the actual state of the enterprise.

Test 6. The inverse problem is characterized by

1. Distributed computing.
2. Consecutive calculations.
3. Calculations from the general to the particular.
4. Issuance of operational information.
5. Formation of information for management decisions.

Test 7. Indicate the content of the section "Description of the algorithm for solving the problem" of the problem statement

1. Description of the methods of forming the resultant
information.
2. Sources and ways of receiving information.
3. Calculation formulas.
4. Block diagram.

Test 8. Indicate the erroneous description of the data in the table describing the structure of input or output documents

1. Shop code - symbolic.
2. Supplier code - numeric.
3. The quantity delivered is actually numeric.

Test 9. What information is not included in the section "Organizational and economic essence of the task"

1. Name of the task.
2. The purpose of solving the problem.
3. Frequency of solving the problem.
4. Methods for controlling the input of initial information.
5. Description of the structure of the document.

Test 10. Specify the information that is included in the "Description of input information"

1. List of input documents.
2. Description of the structure of primary documents.
3. Formalized description of the algorithm.
4. Methods for controlling the input of input information.
5. Frequency of solving the problem.

Test 11. In what conditions is a decision tree used in the process of forming decisions

1. In conditions of risk.
2. In the face of uncertainty.
3. In conditions of complete certainty and awareness.
4. In terms of confidentiality.

Test 12. What is not specified for the goal tree

1. Confidence factor for rule 1.
2. Confidence factor for rule 2.
3. Coefficient of reliability for condition C3.
4. Coefficient of reliability for condition C4.
5. Coefficient of reliability for condition E12.

Test 13. What is the difference between neural network technologies and conventional expert systems

1. Do not require analytical processing data.
2. Does not require specifying priorities and restrictions.
3. They do not require programming, as they are customizable to the needs of the user.

Test 14. What types of training of neural networks do you know

1. "With a teacher."
2. "Without a teacher."
3. "With a student."
4. "Without a student."

Test 15. What needs to be done so that the neural network can help in forming a solution:

1. Specify the rules of withdrawal.
2. Indicate formulas for calculations.
3. Teach by example.
4. Enter information about the situation.

Test 16. What tools are used to form a solution in conditions of uncertainty

1. Inference tree.
2. Decision tree.
3. Tree of goals.
4. Fuzzy sets.

Test 17. What tools are used to form a solution in conditions of certainty

1. Inference tree.
2. Decision tree.
3. Tree of goals.
4. Fuzzy sets.

Test 18. What tools are used to form a decision in conditions of risk

1. Inference tree.
2. Decision tree.
3. Tree of goals.
4. Fuzzy sets.

Test in the discipline "Information technology in professional activity»

What is the purpose of the specified button in Word 2007?

Change the spacing between lines of text b. Center align text

v. Decrease or increase font size

Sort selected text

What is the name of the software or hardware that prevents unauthorized access to the computer?

b. Browser

Firewall, Archiver

The World Wide Web is an Internet service for:

a. Search and view hypertext documents including graphics, sound and video

b. File transfers

v. Transmission e-mails

Real-time communication using the keyboard

Which of the following addresses is the search engine?

http://www.letitbit.net

http://www.vk.com

http://www.narod.yandex.ru g. http://www.google.ru

V spreadsheet Excel formula value = SUM (B1: B2) is 5. What is the value in cell B3 if the formula value = AVERAGE (B1: B3) is 3?

a. 4 b. 2 c. 3 y. 8

Which of the following programs are NOT application programs?

a. Antivirus software

b. Computer-aided design systems

v. Expert systems

Geographic information systems

In an Excel spreadsheet processor, the range of cells looks like this:

a. A1: B1 b. A1 / B1 c. A1 + B1 g. A1-B1

A fragment of the database is presented below in tabular form. How many records satisfy the condition: (Gender = "m") AND (Date of birth = 07/01/1996 AND

What value will appear in cell C2 after cell C1 is copied to cell C2?

The identifier of a certain resource on the Internet has the following form: http://www.olimpiada-profmast.ru/. What part of this identifier indicates the protocol used to transfer the resource?

b. olimpiada-profmast in. http

A snippet of a spreadsheet is given:

Which of the following formulas can be written in cell C2 so that the pie chart constructed after performing the calculations according to the values ​​of the range of cells A2: D2 corresponds to the figure?

g. = (A1 + B1) / 3

Determine the name of the network if computers of one organization are connected by information transmission channels for sharing common resources and peripherals and are located in the same building:

a. The regional

b. Territorial c. Local

of the Global

Choose safeguards that relate to norms of behavior that have traditionally developed or are evolving as information technology spreads in society.

a. Legal (legislative)

b. Organizational (administrative and procedural) c. Technological

d. Moral and ethical

Data types in MS Excel spreadsheets are… a. Text, number and formula

b. Text and number

v. Constants, Formulas and Errors d. Number and Formula

V text editor typed text:

« IT JUST HAS DATE AND TIME PROCEDURES

OF THE DAY, ANALYSIS OF THE CONDITION OF MAGNETIC DISKS, TOOLS OF A ROBOT WITH DIRECTORIES AND SEPARATE FILES ”.

The Find and Replace All command to fix all errors can look like this:

a. Find P, replace with PA

b. Find RO, replace with RA

v. Find RAB, replace with RAB

Find BROB, replace with BRAB

What is the name of a software package that provides control of computer hardware, organizes work with files and execution of application programs, and provides input and output of data?

a. Operating system

b. Software

v. Programming system d. Development environment

In a table processor Microsoft Excel the group of cells D2: E3 is highlighted. How many cells are in this group?

a. 6 b. 4 c. 5 y. 3

The elementary object of raster graphics is: a. What is drawn with one tool

b. Pixel

d. Symbol

Which of the following programs is designed to create brochures, business cards?

a. Microsoft Office Publisher

b. Microsoft Office Word

v. Microsoft Office Access

Microsoft Office Excel

Full name of the copied F.txt file from the C: drive of the KR directory to the D: drive to the SM directory of the TP directory

a. D: \ TP \ SM \ KR \ F.txt b. D: \ TP \ SM \ F.txt

v. D: \ SM \ TP \ KR \ F.txt d. D: \ SM \ KR \ TP \ F.txt

The database contains the fields "Name", "Year of release", "Cost". What will be found when searching by condition : Year of issue 2012 AND Cost

a. Toyota Corolla, 2011, 620,000 b. Mazda 3, 2014, 630000

v. Honda Accord, 2012, 640,000 Skoda Octavia, 2014, 640,000

What fields need to be filled in for the most effective search document FGOS "Maintenance and repair of road transport" in the "Search Card" of the "Consultant-Plus" system?

a. Title of the document and Topic b. Subject and type of document

v. Subject, Document Type and Document Status

d. Title of the document, Subject and Status of the document

In a text editor, the main parameters when setting parameters for a paragraph are:

a. Typeface, size, style b. Indent, spacing

v. Fields, orientation

d. Style, pattern

e. None of the above

a. Doesn't change on autocomplete

b. Changes when autocomplete in any direction

v. Changes when autocomplete down

d. Changes when autocomplete to the right

The regional computer network is ...

a. Communication system connecting subscribers located in different countries

b. Communication system that connects subscribers located at a significant distance from each other

v. Communication system that connects subscribers located within a small area

d. A combination of several types computer networks

The main control program (complex of programs) on a computer is

a. Operating system

b. Application program

v. Graphics editor

G. Word processor

etc. Computing network

A network that brings together computers in different countries, on different continents is ...

a. Global network

b. The local network

v. Regional network

Computing network

In which of the following view modes you cannot add text to the slide: a. Normal

b. Slide Sorter

v. Note Pages d. Slide Show

The PC system unit includes:

a. CPU, RAM, magnetic hard disk b. Monitor, RAM, hard drive in. Keyboard, monitor, system unit

Winchester, keyboard, microprocessor, bois

Device for output from PC graphic information(drawings, graphs, diagrams, diagrams) on paper of various formats (up to JSC) - this is ...

a. a printer

b. Plotter

v. Scanner

Digitizer

unit of measurement clock frequency: a. Megahertz

b. Kilobyte

v. Gigabit

g. Megabyte

To draw a circle in the Paint graphic editor, press the key during construction:

Computer performance depends on: a. Display screen size

b. Processor frequencies

v. Supply voltage

d. Keystroke speed

Control Test - Information Technology

Exercise 1

Question:

Show in the picture graphics editor which is not vector

Specify a place on the image:

Task # 2

Question:

When moving or copying in a spreadsheet, absolute references:

1) are transformed depending on the new position of the formula

2) do not change

3) are converted depending on the rules specified in the formula

4) are transformed regardless of the new provision of the formula

Task # 3

Question:

How many colors will there be in the palette if the color depth is 6 bits?

Write down the number:

___________________________

Task # 4

Question:

Convert the hexadecimal number 5AF to binary using the lookup table and write your answer

Image:

Write down the number:

___________________________

Task # 5

Question:

How to print a character in a text editor that is not on the keyboard?

1) Use an insert special character

2) Paste from special file

3) Use drawing for this

Quest # 6

Question:

How many volume levels will be available with 8-bit audio coding?

Choose one of 5 answer options:

Quest # 7

Question:

Convert binary number 101100011 to octal using the lookup table and write your answer

Image:

Write down the number:

___________________________

Quest # 8

Question:

Within 10 seconds, sound was recorded into a computer at a sampling rate of 10,000 kHz and a quantization bit depth of 8 bits. Determine the information volume of the resulting sound file in bits and write the answer.

Write down the number:

___________________________

Quest # 9

Question:

A picture with a size of 10 by 10 pixels was proportionally enlarged 5 times. What information volume will the resulting image occupy if there are 256 colors in the palette, and the information volume of the original image was 100 bytes.

Choose one of 4 answer options:

3) 2500 bile

4) 5000 bytes

Quest # 10

Question:

Convert binary number 1011011 to decimal number system and write the answer

Write down the number:

___________________________

Quest # 11

Question:

When moving or copying in a spreadsheet, relative links:

Choose one of 4 answer options:

1) are transformed regardless of the new provision of the formula

2) are transformed depending on the new position of the formula

3) do not change

4) are converted depending on the length of the formula

Quest # 12

Question:

There are 256 characters encoded in the Windows-1251 table. Determine the information weight of one character (indicate the answer in bits in one number, without units)

Write down the number:

___________________________

Quest # 13

Question:

The formula from cell D2 was copied to cell D4.

Enter the number that we should see in cell D4

Image:

Write down the number:

___________________________

Quest # 14

Question:

What is the name of the device for converting information from the form printed on paper to digital form on a computer? (see picture)

Image:

Write down the answer:

__________________________________________

Quest # 15

Question:

What is the name of one page of the presentation?

Choose one of 4 answer options:

3) Page

4) Table

Quest # 16

Question:

Specify formulas that use only absolute or mixed, but no relative references

Choose a few of the 5 answer options:

Quest # 17

Question:

How many bits of information will it take to encode this image (see Figure)?

Image:

Write down the number:

___________________________

Quest # 18

Question:

When decreasing the size vector image its quality ...

Choose one of 3 answer options:

1) worsens

2) improves

3) remains unchanged

Quest # 19

Question:

Indicate which of the number systems are positional and which are not

Specify a match for all 2 answer options:

1) Positional

2) Non-positional

The quantitative value of a digit depends on its position in the number

The quantitative value of a digit does not depend on its position in the number

Quest # 20

Question:

How to delete a character to the left of the cursor ...

Choose one of 4 answer options:

1) Press BS

2) Press Alt

3) Press Ctrl + Shift

4) Click Delete

Answers:

1) (1 p.) Correct answers:

2) (1 p.) Correct answers: 2;

3) (1 p.): Correct answer: 64 .;

4) (1 p.): Correct answer: 10110101111 .;

5) (1 p.) Correct answers: 1;

6) (1 p.) Correct answers: 5;

7) (1 p.): Correct answer: 543 .;

8) (1 p.): Correct answer: 800000 .;

9) (1 p.) Correct answers: 3;

10) (1 p.): Correct answer: 91 .;

11) (1 p.) Correct answers: 2;

12) (1 p.): Correct answer: 8 .;

13) (1 p.): Correct answer: 11 .;

14) (1 p.) The correct answer is "Scanner".

15) (1 p.) Correct answers: 1;

16) (1 p.) Correct answers: 1; 2;

17) (1 p.): Correct answer: 360 .;

18) (1 p.) Correct answers: 3;

19) (1 p.) Correct answers.

INFORMATION TECHNOLOGY, TEST 1, correct options.

The list of questions:

1.The key is ... 3

2.General software is ... 3

3.Designed to store data 3

4.Types software platforms determined 3

5.UI standard provides 4 functions

6 Examples of enabling subject technology - 4

7. The "copy" action is ... 4

8.Information technology includes 4

9.Package technology is ... 5

10.First information revolution due to ... 5

11.Technical means are 5

12 Examples of programming systems 5

13. Informatization of society leads to the following consequences: 6

14. Data security control is divided into the following types 6

15.Application panel is (scores 1 out of 1) 6

16. The scheme of work of the system displays the order (points 1 of 1) 6

17.Data schema displays (scores 1 out of 1) 7

18.Calculations can be performed using such information ... (score 1 out of 1) 7

19. Views technical platform determined (scores 1 out of 1) 7

20.User interface provides the user ... (score 1 out of 1) 7

21.Automated workplace- this is ... (points 1 out of 1) 8

22. Information infrastructure includes (score 1 out of 1) 8

23. App Navigation Means Action (1 out of 1 score) 8

24. The software is (scores 1 out of 1) 8

25 Examples of functional information systems - (score 1 out of 1) 9

26. Electronic document flow performs functions (scores 1 out of 1) 9

27. Supporting subject information technology ... (scores 1 out of 1) 9

28.Sorting data performs actions (scores 1 out of 1) 10

29. Examples of information resources are (score 1 out of 1) 10

30. The term "computer science" is a hybrid of words ... (scores 1 out of 1) 10

31. Open education became possible after the emergence of ... (scores 1 out of 1) 10

32 Examples of functional information systems - (score 1 out of 1) 11

33. Programs Maintenance used ... (points 1 out of 1) 11

34. Network technology determines modes (1 out of 1 score) 11

35.Developed at the third stage of the evolution of information ... (points 1 out of 1) 11

36 Examples of programming systems (score 1 out of 1) 12

37. Information technology (IT) is different from app ... (score 1 out of 1) 12

38. Information technology by the scope of the division ... (scores 1 out of 1) 12

39. Working in timesharing mode is different from p ... (scores 1 out of 1) 13

40. The criterion for the selection of file records can be (scores 1 out of 1) 13

41.Designed to store data (1 out of 1 score) 13

43. The user interface standard provides ... (score 1 out of 1) 14

44.Subject information technology is focused on ... (scores 1 out of 1) 14

45. Numerical data can be processed by tracing ... (scores 1 out of 1) 14

46. ​​The types of information technology determine ... (points 1 out of 1) 14

47. Data analysis performs functions (1 out of 1 score) 15

1. The key is ...

1. Common software is ...

	Answer options
	OS, programming systems, maintenance programs
	database management system, expert systems, design automation systems
	Word, Excel, Microsoft Office, etc.
	a set of applications for processing any data
	set of universal software packages

1. Designed for data storage

	Answer options
	database management system
	information storage
	distributed data processing system
	graphics processor

1. The types of software platforms are defined

	Answer options
	user
	network operating system
	operating system
	drivers
	mail server

1. The user interface standard provides functions

	Answer options
	- communication of the application of one computer with the application of another computer
	communication of the application with the user
	communication of the user with the application
	rules for working with the application
	Communication language

1. Examples of enabling subject technologies -

	Answer options
	operating system
	Outlook Express

1. The "copy" action is ...

1. Information technology includes

	Answer options
	a set of methods, production processes and software and hardware for data processing
	Computer communication technologies
	computer data processing technologies
	data input and transmission technologies
	information description technologies

1. Batch technology is ...

	Answer options
	work in real time
	time-sharing
	program execution without user intervention
	interactive technology
	way to bundle data

1. The first information revolution is due to ...

		Answer options
		the advent of machine tools and steam engines
		the ability to replicate knowledge
		the need for accounting in industry
		the advent of computers
		combining computers and communications into network technology
The technical means are Answer options a computer network equipment operating system drivers input-output devices

1. Examples of programming systems

	Answer options
Application control Tests 7. In what case is presented correct ascending order of volume units ... IV. SOFTWARE INFORMATION TECHNOLOGIES Tests on the topic "Mastering ... when editing text Specify correct design option for headers and footers: A) ... Information technology in biology lessons Lesson Demonstration works correct results and mistakes. ... training problem solving, tests, direct implementation of control ... skills and abilities to use information technologies (technologies processing text information, ... Document And certification by information technologies Online software testing information technologies Tests in computer science and information technologies/ wwwexam / Uralic ... attention to the fact that students right named what was being studied, correctly stated and ... Information Technology (2) Guidelines Why information technologies are called " information"? Let's remember what it is technologies- this is a way ... various simulators; verification tests... Your teacher's story ... marks. The main criterion is correct performing operations. 2. Verification ... Professional development program and methodological recommendations Contents Information technologies in the activities of a subject teacher 1 Contents 1 Program Qualifications and guidelines Contents Information technologies in the activity of a subject teacher 1 ... 2. Techniques for creating interactive tests... Using verification tools ... assignments, be sure to check right work. Give me time ...

1. The composition personal computer enters?

A) Scanner, printer, monitor

B) Video card, system bus, uninterruptible power supply

C) Monitor, system unit, keyboard, mouse *

D) Winchester, mouse, monitor, keyboard

2. Are all computer files written to?

A) Winchester *

B) Modulator

C) Floppy disk

D) Generator

3. How do I enable all uppercase letters on the keyboard?

C) Shift + Ctrl

D) Shift + Ctrl + Alt

4. What is the name of the main windows windows that appears on the screen after the operating environment is fully loaded?

A) Download window

B) Table with labels

C) Desktop *

D) Monitor image

5. What are the steps to run the calculator in Windows?

A) Standard → Calculator

B) Start → Programs → Accessories → Calculator *

C) Start → Accessories → Calculator

D) Start → Calculator

6. What is the name of the program file manager included in the Windows operating environment?

A) Explorer *

B) Accompanying person

C) File manager

D) Windows commander

7. To create a new folder in Windows program commander need to press a button on the keyboard?

8. To delete a file in the Windows commander, press the?

9. To run any program, you need to Windows desktop click on the?

B) Program shortcut *

C) Program start button

D) Desktop

10. What is the difference between a folder icon and a shortcut?

A) The sign of the shortcut is a knot in the lower left corner of the icon, with which it "binds" to the object

B) The shortcut icon is larger than all other icons

C) The letter "I" is written on the label icon

D) Label sign - small arrow in the lower left corner of the icon *

11. In order to find a file on the computer, click?

A) Start → Find → Files and Folders *

B) Start → Files and folders

C) Find -> File

D) Start -> File -> Find

12. To configure the parameters of the mouse, click?

A) Settings -> Control Panel -> Mouse

B) Start -> Control Panel -> Mouse

C) Start -> Settings -> Mouse

D) Start -> Settings -> Control Panel -> Mouse *

13. How to set the time after which the splash screen appears on the Windows desktop?

A) Properties: Screen → Screensaver → Interval *

B) Screensaver → Time period

C) Properties: screen → Screensaver → Time

D) Properties: Interval

14. What functions does the Documents item in the Windows Main Menu perform?

A) The Documents item of the Main menu displays a list of currently open documents and allows you to switch between them

B) The Documents item of the Main menu displays a list of documents that you have worked with in the last 15 days. Clicking on the name or icon of a document launches the application with which it was created and opens the document

C) The Documents item of the Main menu displays a list of all created documents and allows you to open any of them

D) The Documents item of the Main menu displays a list of the last opened documents. Clicking on the name or icon of a document launches the application with which it was created and opens the document *

15. What is the purpose of the selection of objects?

A) For the purpose of grouping and creating a thematic group

B) In order to subsequently change them appearance(changing the size, appearance of the icon, etc.)

C) For the purpose of sorting them

D) In ​​order to perform any actions with them (open, copy, move, etc.) *

16. How to bring up the context menu on the screen?

A) Left-click on the object and select the "Context Menu" command in the list that opens

B) Open the menu command "SERVICE" and in it select the command "Context menu"

C) Click on the object with the right mouse button *

D) Double-click the left mouse button on the object

17. In which program can you create Text Document(research report)?

A) Windows Word

B) Microsoft Word *

C) Microsoft Excel

G) Microsoft Power Point

18. Which of the images matches the logo Microsoft programs Word?

19. How many documents can I open in Word at the same time?

A) Only one

B) No more than three

C) How much is needed

D) Depends on user tasks and computer resources *

20. Can I open or create a new document in Microsoft Word using the?

A) Standard *

B) Formatting

C) Structure

D) Control elements

21. To enable or disable toolbars in Microsoft Word, press?

A) View -> toolbars

B) Service -> Settings -> Toolbars

C) By right-clicking on any of the panels

22. How to create a new "Standard Report" document from Microsoft Word templates?

A) File -> create -> general templates -> reports -> standard report *

B) General templates -> reports -> standard report

C) File -> reports -> standard report

D) File -> create -> standard report

23. To configure parameters Word pages do I have to press the sequence?

A) File -> page settings *

B) File -> properties -> page options

C) Page settings -> properties

D) Edit -> page options

24. Which of the following buttons allows you to close an open Word document?

25. What button should I press to paste the copied text into Microsoft Word?

26. What sequence of operations in Microsoft Word should be performed to edit the size of the font size in the selected paragraph?

A) Call the quick menu → font → size

B) Format -> font -> size

C) On the Formatting panel, change the font size

27. What button in Microsoft Word should you press to create a numbered bibliography?

28. How to find in the text Microsoft document Word is the necessary word?

B) Edit → find *

C) Service -> find

D) All items a, b and c are suitable

29. What does it mean if single words are underlined with a red squiggly line in a Word document?

A) This means that the font design of these words differs from those adopted in the document

B) This means that these words are written to the clipboard and can be used when typing

C) This means that in these words it is necessary to change the case of their writing

D) This means that, in the opinion of Word, errors were made in these words *

Information Technology Discipline Tests

30. Which button should be pressed to automatic insertion current date in a Microsoft Word document?

31. How to transfer a piece of text from the beginning to the middle of the document?

A) Erase the old text, and type it in a new place

B) Cut a piece of text by placing it on the clipboard. Then place the cursor in the middle of the document, execute the "Insert" command *

C) Select a piece of text, copy it to the clipboard, position the cursor in the middle of the document, execute the "Paste" command

D) This operation is not available in the Word editor

32. To create a diagram in Microsoft Word, click?

33. How to make the computer independently create a table of contents (table of contents) in a Microsoft Word document?

A) Edit → table of contents and indexes

C) Edit → table of contents

D) Format -> table of contents and indexes

34. How to set automatic hyphenation in a Microsoft Word document?

A) Service → hyphenation

B) Service -> Options -> Hyphenation

C) Service → language → hyphenation → automatic placement *

D) Insert -> automatic hyphenation

35. How to set the spelling language in a Microsoft Word document?

A) Service -> options -> language

B) Options -> language -> install

C) Service -> setting -> language

D) Service → language → select language *

36. What button should I press in Microsoft Word to create a table?

37. What button in Microsoft Word should you press to merge the selected cells?

38. What button should you click to include all borders in a Microsoft Word table?

39. What button should be pressed to insert into the text of a Microsoft document Word object WordArt?

40. To create a multicolumn Word document(eg newspapers) need to press a button?

B) File -> rtf

C) Parameters -> text -> rtf

D) Service -> options -> rtf

42. What button should I click to preview a Microsoft Word document before printing to the printer?

43. How to preview the text of a Word document before printing?

A) Switch to "page layout" mode

B) Switch to the "page layout" mode and select the "whole page" scale

C) Set the scale of viewing the document "full page"

D) Using the "preview" tool *

44. How to insert a break from the next page in a Microsoft Word document?

A) Insert -> break from next page

B) Insert -> options -> from next page

C) Insert -> Break -> From Next Page *

D) Service -> break -> from next page

45. Which image matches the Microsoft Excel logo?

46. ​​What is the name of the button bar located under the heading of the Microsoft Excel document and including: File | Edit | View | Insert etc.?

A) Formatting panel

B) The panel is standard

C) Menu bar *

D) Title bar

47. What toolbars are available in the spreadsheet editor Excel?

A) Standard, formatting

B) External data, forms

C) Pivot tables, controls

D) All items a, b and c are suitable *

48. Which button can be used to create a new Microsoft Excel workbook?

49. Which button can be used to close a Microsoft Excel workbook?

50. How to create headers and footers in a Microsoft Excel workbook?

A) Insert -> Headers and Footers

B) View → headers and footers *

C) Service → headers and footers

D) Options -> Headers and Footers

51. How to add a sheet to a Microsoft Excel workbook?

A) Service -> create a new sheet

B) View -> add new sheet

C) Insert -> sheet *

D) All items a, b and c are suitable

52. Which key on the keyboard can be used to select non-adjacent cells in a Microsoft Excel sheet?

53. To format cells in Microsoft Excel, press?

A) Service -> cell format

B) Format -> content -> cells

C) Edit -> cells

D) Format -> cells *

54. What is an Excel spreadsheet processor, its purpose?

A) Excel is a MS Windows application that allows you to edit text, draw various pictures and perform calculations

B) Excel - designed for data processing (calculations and charting) presented in tabular form *

C) Excel - software tool, intended for editing observational data

D) A processor installed in a computer and designed to process data presented in the form of a table

55. How to rename a sheet of an Excel workbook?

A) Run the command Edit → Rename sheet

B) Right-click on the sheet tab and select the "Rename" command in the context menu *

C) Rename Excel sheets it is forbidden. They always have the name "Sheet1, Sheet2 ........"

D) Right-click in the middle of the worksheet and select the "Rename Sheet" command

56. What does it mean if you see a group of characters ###### in an Excel cell?

A) The selected cell width does not allow placing the calculation results in it *

B) Invalid information entered into the cell

C) There was a calculation error using the formula

D) The actions performed led to incorrect operation of the computer

57. How to make sure that the Excel cell were the numbers perceived as text?

A) Numbers entered in a cell are always perceived by Excel only as numbers

B) Run the command Format → Cells ... and on the "Format Cells - Number" tab select "Text" *

C) Service -> options -> text

D) Just enter a number into a cell. The computer itself will determine whether it is a number or a text

58. How to change the background of the selected area of ​​cells in Excel?

A) Run the command "View → Background" and select the desired color

B) Right-click on the selected one and in the window that opens, select the "Fill with color" command

C) Run the command Edit → Background and select the desired color

D) Run the command Format → Cells ... and in the opened dialog box on the "View" tab select the required color *

59. What does the black square located in the lower right corner of the active cell allow to do in Excel?

A) This suggests that information can be entered into this cell (text, number, formula ...)

B) Allows you to copy the contents of a cell using the mouse *

C) Allows you to edit the contents of the cell

D) After clicking the left mouse button on this square, the contents of the cell will be placed on the clipboard