Test. Information Technology. Computer science test "information technology" Tests for information technology engineer

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 satisfaction of human spiritual needs;
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. 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 pre-processed information;
4 messages located in data stores.

Test 4. Information is

1 messages located in the computer memory;
2 messages located in data stores;
3 pre-processed data suitable for making management decisions;
4 messages recorded on machine media.

Test 5. An economic indicator consists of

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

Test 6. Specify the correct characteristics of the basis of the economic indicator

1. The basis props determine the qualitative side of an object or process.
2. The basis requisite determines the quantitative aspect of an object or process.
3. The basis attribute determines the time characteristics of an object or process.
4. The basis attribute determines the connection between processes.

Test 7. Specify the correct characteristics of the attribute of an economic indicator

1. A props-attribute determines the qualitative side of an object or process.
2. Attribute-attribute determines the quantitative aspect of an object or process.
3. Attribute-attribute determines the temporal characteristics of an object or process.
4. The base props determine the constituent elements of the object.

Test 8. What dictated the need to isolate economic indicators from management documents in the process of setting a problem?

1 to identify structural units generating management documents;
2 the desire to correctly formalize calculations and perform logical operations;
3 the need to protect information.

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

1.Individual outfit for piece work.
2. Brigade outfit for piece work.
3. Tariffs for the manufacture of parts.
4. Directory of parts.
5. Calendar of working days.

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

1. Nomenclature-price tag.
2. Detailed operational standards for material consumption.
3. Invoice for the arrival of materials at the warehouse.
4. Invoice for the release 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. unclear.

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

1. An information system is a closed information loop, consisting of direct 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 the use of computer technology and communications, that implement 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. Specify the correct definition of information business

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

Test 14. Specify the correct definition of the information market

1. The information market refers to many manufacturers offering infocommunication services.
2. The information market refers to many entities supplying computer equipment.
3. The information market is understood as a network of trading enterprises that sell 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 maintenance of hardware and software.

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

1. Planning the implementation and modernization of the information system, its search in the software market.
2. Assessment of the software market using marketing tools.
3. Development of application programs.
4. Acquisition of information technologies with the necessary functions and properties.
5. Development of operating systems.
6. Organization of implementation of the information system and personnel 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-based;
5 process.

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

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

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

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

Test 4. Business process is

1 a variety 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 during the production process.

Test 5. Which information system corresponds to the following definition: a hardware and software complex capable of uniting into one whole enterprises with different functional areas (manufacturing, trading, credit, etc. organizations)

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

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

1. Local LAN (Local Area Net).
2. Regional city scale 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, evaluation and selection of information systems

Test 1. System analysis assumes:

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

Test 2: Give the correct definition of the system

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. A system is elements that are not interconnected.
4. A 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 created on the basis of international standards.
4. A system focused on rapid data processing.
5. A system designed to issue analytical reports.

Test 4. What international standards in information systems regulate

1. Interaction of information systems of various classes and levels.
2. The number of technical means in the information system.
3. Interaction of application programs within the information system.
4. The number of personnel providing information support to the management system.

Test 5. Indicate the capabilities provided by open information systems

1. Data mobility, which consists in the ability of information systems to interact.
2. Mobility of programs, which consists of the possibility of transferring application programs and replacing hardware.
3. User mobility, which consists in providing a user-friendly interface.
4. Extensibility - the ability to add (increase) new functions that the information system did not previously possess.
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 management functions served 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 an information system used in the process of its creation and operation

1. Basic production processes.
2. Basic life cycle processes.
3. Supporting life cycle processes.
4. Supporting marketing processes.
5. Organizational life cycle processes.
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. Provide the correct definition of an ERP system

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

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

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

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 means.
4. Lots of information resources.
5. A set of operations for collecting, processing, transmitting and storing data using automation methods and tools.

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

1. Word processors.
2. Table processors.
3. Transaction systems.
4. Database management systems.
5. Control software systems.
6. Multimedia and Web technologies.
7. Systems for forming decisions.
8. Expert systems.
9. Graphics processors.

Test 3. Indicate which of the listed methods for controlling the input of initial information uses compliance with the range of correct values ​​of the attribute

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

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

1. For data entry.
2. For data transfer.
3. To obtain the results of various levels.
4. For data control.

Topic 5. Information resources of enterprises and organizations

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

1. Information resources of society are information of various types, materialized in the form of documents, databases and knowledge bases.
2. Information resources of society are individual documents and individual 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 constituent entities of the Russian Federation.
3. Information resources of society are a variety of websites available on the Internet.
Test 2. Indicate existing information resources in the enterprise
1. Own.
2. External.
3. Technical.
4. Software.
5. Organizational.

Test 3. Off-machine information resources of an enterprise are

1.Management documents.
2. Databases.
3. Knowledge bases.
4. Files.
5. Data storage.

Test 4. Intra-machine information resources of an enterprise are

1. Databases.
2. Websites.
3. Knowledge bases.
4. Design documents.
5. Data storage.
6. Accounting and financial documents.

Test 5. The enterprise's own information resources are

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

Test 6. External information resources of an enterprise are

1. Information purchased externally.
2. Information received from third parties.
3. Information received from the Internet.
4. Information generated using OLAP technologies.
5. Orders for employment.

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

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

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

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

Test 9. For what purpose is information encoding carried out?

1. Reducing labor costs when entering information.
2. Simplification of computational 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 of electronic documents in the archive.
3. Search for electronic documents in the archive.
4. Organization of solving transactional problems.
5. Routing and transmission of documents to structural units.
6. Monitoring the implementation of orders.
7. Organization of solving analytical problems.

Test 11. Indicate common forms of in-machine representation of structured information resources

1. Databases.
2. Traditional paper management documents.
3. Knowledge bases.
4. Texts of orders entered into the computer.
5. Data storage.
6. Websites.

Test 12. Indicate the main feature of databases

1. Focus on data transfer.
2. Focus on rapid data processing and work with the end user.
3. Focus on intelligent data processing.
4. Focus on providing analytical information.

Test 13. Indicate the main feature of data warehouses

1. Focus on rapid data processing.
2. Focus on analytical data processing.
3. Focus on interactive data processing.
4. Focus on integrated data processing.

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

1. Table name (relationship).
2. File.
3. Attribute.
4. Cortege.
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 coding.
4. Data transfer.
5. Data archiving

Test 16. A centralized database is characterized by

1. Optimal size.
2. Minimum costs for data correction.
3. Maximum costs for data transfer.
4. Rational structure.

Test 17. A distributed database is characterized by

1. Optimal size.
2. Minimum data transfer costs.
3. Maximum costs for 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 diagram.

Test 19. The semantic network of the subject area is

1 model for data presentation;
2 model for knowledge representation;
3 means for online 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 under conditions of uncertainty;
3 obtaining new knowledge under risk conditions;
4 gaining new knowledge in confidentiality.

Test 21. The membership function is used for

1 solving equations;
2 information search;
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

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

Test 2. Indicate the directions in the development of infocommunication technologies

1. Electronic business.
2. Solving economic problems.
3. Banking network payments.
4. Decision making 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 on electronic communications of several traditional enterprises specializing in various fields of activity.
4. Defunct enterprise.
5. Machine-building enterprise.

Test 4. How do costs change as a result of the use of information and communication technologies?

1. They increase.
2. Distributed.
3. Disappear.
4. They accumulate.
5. Declining.

Topic 7. Solving economic problems based on basic software

Test 1. Information models are designed to

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 reflection of the quality characteristics of processes.

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

1. Network models.
2. Hierarchical models.
3. Relational models.
4. Data flow diagrams.
5. Graph models.

Test 3: Identify the elements that make up data flow diagrams

1. Object.
2. Distributor.
3. Process.
4. Storage.
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. A set of points over which relations are specified.
6. Scheme.

Test 5. The direct economic problem is characterized by

1. Parallel computing.
2. Calculations from the particular to the general.
3. Sequential 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. Sequential calculations.
3. Calculations from general to specific.
4. Issuance of operational certificates.
5. Generating information for management decisions.

Test 7. Indicate the contents of the section “Description of the algorithm for solving the problem” of the problem statement

1. Description of methods for generating the resulting
information.
2. Sources and methods of receiving information.
3. Calculation formulas.
4. Block diagram.

Test 8. Point out the erroneous description of the data in the table describing the structure of the input or result documents

1. The workshop code is symbolic.
2. Supplier code – numeric.
3. Quantity delivered actually – numerical.

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. Indicate the information included in the “Description of input information” section

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. Under what conditions is a decision tree used in the decision making process?

1. In conditions of risk.
2. In conditions of uncertainty.
3. In conditions of complete certainty and information.
4. In conditions 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. Reliability coefficient for condition C3.
4. Reliability coefficient for condition C4.
5. Reliability coefficient for condition E12.

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

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

Test 14. What types of neural network training 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 generating a solution:

1. Specify the withdrawal rules.
2. Provide formulas for calculations.
3. Teach with examples.
4. Enter information about the situation.

Test 16. What tools are used to form a decision under 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 decision under 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 under risk conditions?

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

1. Does a personal computer include?

A) Scanner, printer, monitor

B) Video card, system bus, uninterruptible power supply device

B) Monitor, system unit, keyboard, mouse *

D) Hard drive, mouse, monitor, keyboard

2. Are all computer files recorded on?

A) Winchester *

B) Modulator

B) Floppy disk

D) Generator

3. How to enable all capital letters on the keyboard?

B) Shift + Ctrl

D) Shift + Ctrl + Alt

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

A) Loading window

B) Table with labels

B) Desk*

D) Monitor image

5. What sequence of actions must be performed to launch the calculator in Windows?

A) Standard → Calculator

B) Start → Programs → Accessories → Calculator *

B) Start → Accessories → Calculator

D) Start → Calculator

6. What is the name of the file manager program that is part of the Windows operating environment?

A) Conductor *

B) Accompanying

B) File Manager

D) Windows commander

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

8. To delete a file in the Windows commander program, should you press the button on the keyboard?

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

B) Program shortcut*

B) Program start button

D) Desk

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

A) The sign of a shortcut is a knot in the lower left corner of the icon with which it is “attached” to the object

B) The shortcut icon is larger than all other icons

C) The shortcut icon has the letter “I” written on it.

D) The shortcut sign is a small arrow in the lower left corner of the icon *

11. In order to find a file on your computer, you need to press?

A) Start → Find → Files and folders*

B) Start → Files and folders

B) Find → File

D) Start → File → Find

12. To configure mouse operation parameters, you need to click?

A) Settings → control panel → mouse

B) Start → control panel → mouse

B) Start → settings → mouse

D) Start → settings → control panel → mouse*

13. How to set the time after which the screensaver will appear on the Windows desktop?

A) Properties: Screen → Screen Saver → Interval *

B) Screensaver → Time period

B) 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 have been worked with over the last 15 days. Clicking on a document's name or icon launches the application that created it 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 recently opened documents. Clicking on a document's title or icon launches the application that created it and opens the document*

15. What is the purpose of selecting objects?

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

B) For the purpose of subsequently changing their appearance (changing the size, type of icon, etc.

B) 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 select the command "Context menu"

B) Right-click on the object *

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

17. In what program can you create a text document (research report)?

A) Windows Word

B) Microsoft Word *

B) Microsoft Excel

D) Microsoft Power Point

18. Which of the images corresponds to the Microsoft Word logo?

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

A) Only one

B) No more than three

B) How much is needed

D) Depends on the user’s tasks and computer resources *

20. Is it possible to open or create a new document in the Microsoft Word editor using the panel?

A) Standard *

B) Formatting

B) Structure

D) Controls

21. To turn toolbars on or off in Microsoft Word, click?

A) View → toolbar

B) Tools → settings → toolbars

B) 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

B) File → reports → standard report

D) File → create → standard report

23. To configure Word page settings, do you need to press the sequence?

A) File → page parameters *

B) File → properties → page options

B) Page settings → properties

D) Edit → page options

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

25. Which button should you press to paste copied text into Microsoft Word?

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

A) Call up quick menu → font → size

B) Format → font → size

C) In the Formatting panel, change the font size

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

28. How to find the required word in the text of a Microsoft Word document?

B) Edit → find *

B) Service → find

D) All points a, b and c are suitable

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

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

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

C) This means that these words need to change the case of their spelling

D) This means that, in Word’s opinion, there were mistakes in these words *

Tests in the discipline of information technology

30. Which button should you click to automatically insert the current date into a Microsoft Word document?

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

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

B) Cut out 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, place 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, do you need to click?

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

A) Editing → table of contents and indexes

B) 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 → parameters → hyphenation

B) Service → language → hyphenation → automatic hyphenation *

D) Insertion → automatic transfers

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

A) Service → parameters → language

B) Settings → language → install

B) Service → settings → language

D) Service → language → select language *

36. What button do you need to press in Microsoft Word to create a table?

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

38. Which button should you click to enable all borders in a Microsoft Word table?

39. Which button should you press to insert a WordArt object into the text of a Microsoft Word document?

40. To create a multi-column Word document (such as a newspaper), do you need to click a button?

B) File → rtf

B) Options → text → rtf

D) Service → parameters → rtf

42. Which button should you click to preview a Microsoft Word document before printing it?

43. How can I 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 document viewing scale to "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 → parameters → from next page

B) Insert → break → from next page *

D) Service → break → from next page

45. Which of the images corresponds to the Microsoft Excel logo?

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

A) Formatting panel

B) Standard panel

B) Menu bar *

D) Header line

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

A) Standard, formatting

B) External data, forms

C) Pivot tables, controls

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

48. Using which button can you create a new Microsoft Excel workbook?

49. Which button can you close a Microsoft Excel workbook?

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

A) Insert → header and footer

B) View → footers *

B) Service → footers

D) Options → footers

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

A) Service → create a new sheet

B) View → add new sheet

B) Insert → sheet *

D) All points a, b and c are suitable

52. Using which keyboard button can you select non-adjacent cells in a Microsoft Excel worksheet?

53. To format Microsoft Excel cells, do you need to click?

A) Service → cell format

B) Format → contents → cells

B) Edit → cells

D) Format → cells *

54. What is an Excel spreadsheet processor and 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 is a software tool designed for editing observational data

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

55. How to rename an Excel workbook sheet?

A) Execute the command Edit → Rename Sheet

B) Right-click on the sheet label and select the “Rename” command from the context menu *

C) You cannot rename Excel sheets. They always have the name "Sheet1, Sheet2........"

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

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

A) The selected cell width does not allow calculation results to be placed in it *

B) Invalid information has been entered into the cell

C) There was a calculation error using the formula

D) The actions taken resulted in the computer not working properly

57. How can I make numbers entered into an Excel cell appear as text?

A) Numbers entered into a cell are always treated by Excel as numbers only

B) Execute the command Format → Cells... and on the “Format Cells – Number” tab select “Text” *

B) Service → parameters → text

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

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

A) Execute the command “View → Background” and select the required color

B) Right-click on the selection and in the window that opens, select the “Color Fill” command

C) Execute the command Edit → Background and select the required color

D) Execute the command Format → Cells... and in the dialog box that opens, 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 you to do in Excel?

A) This means that you can enter information into this cell (text, number, formula...)

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

B) Allows you to edit the contents of a cell

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

INFORMATION TECHNOLOGY, TEST 1, correct options.

A list of questions:

1.The key is... 3

2. General software is... 3

3.Designed for 3 data storage

4.Types of software platforms are defined 3

5.UI standard provides 4 functions

6.Examples of supporting subject technologies - 4

7.The “copy” action is… 4

8. Information technology includes 4

9.Batch technology is… 5

10. The first information revolution was caused by ... 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.The application panel is (points 1 out of 1) 6

16.The system operation diagram shows the order (points 1 out of 1) 6

17.Data schema displays (points 1 of 1) 7

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

19.Types of technical platform are determined (points 1 out of 1) 7

20.The user interface provides user... (points 1 of 1) 7

21. An automated workplace is ... (points 1 out of 1) 8

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

23.Navigation through the application means actions (points 1 out of 1) 8

24. Software tools are (points 1 out of 1) 8

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

26. Electronic document management performs functions (points 1 out of 1) 9

27.Providing subject information technologies... (points 1 of 1) 9

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

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

30. The term “computer science” is a hybrid of words... (points 1 out of 1) 10

31.Open education became possible after the advent of... (points 1 of 1) 10

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

33. Maintenance programs are used ... (points 1 of 1) 11

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

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

36. Examples of programming systems (points 1 of 1) 12

37. Information technologies (IT) differ from applications... (points 1 of 1) 12

38. Information technologies by area of ​​application dividing... (points 1 out of 1) 12

39.Working in a time-sharing mode differs from work... (points 1 of 1) 13

40. The criterion for selecting file records can be (points 1 out of 1) 13

41.Designed for data storage (1 out of 1 points) 13

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

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

45.Numerical data can be processed using the following... (1 out of 1 points) 14

46. ​​Varieties of information technologies determine... (points 1 out of 1) 14

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

1. The key is...

1. General software is...

	Answer options
	operating systems, 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
	a set of universal application software packages

1. Designed for data storage

	Answer options
	database management system
	information repository
	distributed data processing system
	GPU

1. Types of software platforms are defined

	Answer options
	user
	network operating system
	operating system
	drivers
	mail server

1. The user interface standard provides features

	Answer options
	– communication between an application on one computer and an application on another computer
	communication between the application and the user
	user communication with the application
	rules for using the application
	Language of communication

1. Examples of supporting 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
	Technologies for communicating with a computer
	computer data processing technologies
	data input and transmission technologies
	information description technologies

1. Batch technology is...

	Answer options
	work in real time
	time sharing operation
	execution of the program without user intervention
	interactive technology
	way to combine data into a package

1. The first information revolution is caused by...

		Answer options
		the advent of machine tools and steam engines
		possibility of knowledge replication
		the need for accounting in industry
		the advent of computers
		combining computers and communications into network technology
Technical means are Answer options computer network equipment operating system drivers input/output devices

1. Examples of programming systems

	Answer options
Application Control Tests 7. In what case is it presented? correct increasing order of volume units... IV. SOFTWARE INFORMATIONAL TECHNOLOGY Tests on the topic “Mastering... when editing text Specify correct header and footer design option: A) ... Information technology in biology lessons Lesson Works for demonstration purposes correct results and mistakes made. ... training problem solving, tests, direct implementation of control... skills and abilities to use information technologies (technologies text information processing, ... Document And certification according to informational technologies Online testing by informational technologies Tests in computer science and informational technologies/wwwexam/ Ural... attention to ensuring that students Right they named what was being studied, presented it correctly and... Information technology (2) Guidelines Why informational technologies are called " informational"? Let's remember what it is technologies– this is a way... various simulators; test tests. Teacher's story... marks. The main criterion is correct performing operations. 2. Check... Advanced training program and methodological recommendations Contents Information technologies in the activities of subject teachers 1 Contents 1 Program Qualifications and guidelines Contents Information technologies in the activities of a subject teacher 1 ... 2. Techniques for creating interactive tests. Using tools to check... tasks, be sure to check right work. Give it time...

1. The following number of revolutions have occurred in the development of information technology:
□ 2
□ 3
□ 4
□ 5

2. Infection with computer viruses can occur in the process of:
□ working with files
□ formatting a floppy disk
□ turn off the computer
□ printing on a printer

3. To check your hard drive for a virus, you must have:
□ protected program
□ boot program
□ file with antivirus program
□ write-protected floppy disk with anti-virus program

4. A program that is not an antivirus:
□ AVP
□Defrag
□ Norton Antivirus
□ Dr Web

5. Class of programs not related to antivirus:
□ phage programs
□ scanning programs
□ audit programs
□ detector programs

6. How a virus appears on a computer:
□ moving from a floppy disk
□ when solving a mathematical problem
□ when connecting a modem to a computer
□ spontaneously

7. The following may be infected with computer viruses:
□ graphic files
□ programs and documents
□ sound files
□ video files

8. Basic principles of operation of new information technology:
□ interactive mode of working with the user
□ integration with other programs
□ relationship between the user and the computer
□ flexibility in the processes of changing data and setting tasks
□ use of expert support
9. Classification of information technologies (IT) according to the method of application of data processing tools and methods includes:
□ basic IT
□ general IT
□ specific IT
□ special IT
□ global IT

10. Classification of information technologies (IT) according to the problem being solved includes:
□ IT office automation
□ IT data processing
□ IT expert systems
□ IT support for entrepreneurs
□ IT decision support

11. Information technology tools include:
□ computer
□ computer desk
□ software product
□ several interrelated software products
□ books

12. Examples of information technology tools:
□ text editor
□ table editor
□ graphic editor
□ video editing system
□ database management system

13. The word processor is included in:
□ system software
□ programming systems
□ operating system
□ application software

14. A word processor is a program designed to:
□ working with images
□ PC resource management when creating documents
□ entering, editing and formatting text data
□ automatic translation from symbolic languages ​​to machine codes

15. The basic structure of a text document is determined by:
□ footer
□ note
□ template
□ hyperlink

16. To create a form template with complex formatting, you need to insert into the document:
□ drawing
□ frame
□ headers and footers
□ table

17. Areas located in the top and bottom margins of each page of a document that typically contain repeated information:
□ footnote
□ footer
□ epigraph
□ fragment

18. A set of formatting options that is applied to text, tables and lists to quickly change their appearance by applying an entire group of formatting attributes at once in one action - this is:
□ style
□ format
□ template
□ service

19. The Format menu commands in the MS Word word processor allow you to:
□ saving the document
□ table insertion
□ insertion of a picture
□ selection of paragraph and font parameters

20. The Edit menu commands in the MS Word word processor allow you to:
□ pasting objects from the clipboard
□ saving the document
□ table insertion
□ selection of paragraph and font parameters

21. The distance between the baselines of adjacent rows of the table is called:
□ leading
□ headset
□ point
□ kerning

22. An object that allows you to create formulas in a MS Word document is called:
□ Microsoft Excel
□Microsoft Equation
□ Microsoft Graph
□ Microsoft Access

23. When closing the “Configuration” window, the 1C program issued the request “Save metadata?” It means:
□ changes were made to the configuration in the current session; if the answer to the request is yes, these changes will be saved
□ this request is always issued; if the answer is yes, a backup copy of the database is created
□ this request is always issued; if the answer is yes, a backup copy of the database and current configuration is created
24. Let the currency directory for some currency X set the current rate equal to 2 and the multiple equal to 100. Then the ruble coverage of 250 units of currency X will be equal to:
□ 5 rub.
□ 500 rub.
□ 50,000 rub.
□ 125 rub.

25. When setting up system parameters, the “Year of the beginning of the working century” field is set to “1998”. In this case, the date “02.12.97” entered in the format of a two-digit year representation will be perceived by the program as:
□December 2, 1997
□December 2, 1998
□ December 2, 2097
□ February 12, 1997
□ February 12, 1997

26. Each account in the chart of accounts window has an icon at the beginning of the line. The pictogram is marked with a red “tick”, this means that:
□ the account is marked for deletion
□ the account can only be edited in configuration mode
□ account cannot be edited
□ “kryzha” indicating that the account is included in the working chart of accounts
□ the “Switch off postings” command was executed in relation to transactions using this account

27. When entering a transaction in the “Debit Account” column, an account number is entered that is not in the chart of accounts. In this case:
□ when recording a transaction, an error message will be displayed
□ when recording the operation an error message will be displayed
□ the chart of accounts will open to select an account
□ an auxiliary (fictitious) invoice with code “00” will be automatically entered

28. Creating tables in the MS Word word processor is possible in the following mode:
□ usual
□ markings
□ structures
□ Web document
□ document diagrams

29. Creating requisite design elements for printed pages in the MS Word word processor is possible in the following mode:
□ usual
□ markings
□ structures
□ Web document
□ document diagrams

30. Basic techniques for working with texts in the MS Word word processor include:
□ creating, saving and printing a document
□ sending a document by email
□ text input and editing
□ text review
□ text formatting

31. Special text input tools in the MS Word word processor include:
□ means of canceling and returning actions
□ extended clipboard
□ autotext
□ auto summation
□ auto-correct

32. Special text editing tools in the MS Word word processor include:
□ symbol insertion mode
□ character replacement mode
□ review
□ thesaurus
□ automation of spell checking

33. You can insert into a MS Word document:
□ formulas
□ programs
□ tables
□ diagrams
□ drawings

34. A new macro can be created in the following ways:
□ automatically record the sequence of actions
□ manually write the corresponding program in VBA
□ import an existing macro from another file
□ import an existing macro from another file and change it
□ change to an already created macro and save under a different name

36. For calculations in MS Word tables, formulas containing:
□ mathematical functions
□ constants
□ built-in functions
□ signs of mathematical operations
□ links to blocks of text

37. When merging, the following documents are used:
□ final document
□ main document
□ data recipient
□ data source
□ original document

38. The data source for a merger can be:
□ MS Word document
□ MS Excel document
□ MS WordPad document
□ MS Access document
□ MS Graph document

40. A MS Excel table cell can contain:
□ drawing
□ text
□ number
□ formula
□ date and time

41. Operating modes of the MS Excel spreadsheet processor:
□ readiness
□ data entry
□ command
□ regular
□ editing

42. Restricting access to spreadsheets can be done at the level:
□ workbooks
□ groups of documents
□ formulas
□ worksheets
□ individual cells

43. The MS Excel spreadsheet data menu item allows you to:
□ carry out data protection
□ create macros
□ sort data
□ filter data
□ check spelling

44. To run a macro you can use:
□ keyboard key combination
□ combination of keyboard keys and on-screen buttons
□ created screen buttons
□ created toolbar buttons
□ text command

45. When formatting a chart in the MS Excel spreadsheet processor, you can change:
□ chart type
□ initial data
□ legend format
□ diagram location
□ format of the construction area

46. ​​In the chart of accounts for a certain account, analytical accounting is established in the context of two types of sub-accounts - “Materials” and “Warehouses”. Then in the 1C program the accounting results for this account can be obtained:
□ separately for materials
□ separately for warehouses
□ by warehouses by materials and warehouses
□ by materials by warehouse
□ by warehouse by material

47. In the standard operation template, for some posting attribute, the “Copying” parameter is set to the name of the same attribute. This mode in the 1C program provides the user with the opportunity to:
□ force copying of the values ​​of the specified details from the same transaction
□ force copying of the values ​​of the specified details from subsequent transactions
□ force copying of the values ​​of the specified details of previous transactions
□ forcefully copy the values ​​of the specified attribute from the operation log
□ force copying of the values ​​of the specified transaction journal attribute

48. This method of connecting to the Internet provides the greatest opportunities for access to information resources:
□ permanent connection via fiber optic channel
□ remote access via dial-up telephone channel
□ permanent connection via a dedicated telephone channel
□ terminal connection via dial-up telephone channel

49. A modem transmitting information at a speed of 28,800 bps can transmit two pages of text (3,600 bytes) within...
□ 1 minute
□ 1 hour
□ 1 second
□ 1 day

50. Electronic mail (e-mail) allows you to send…
□ messages only
□ files only
□ messages and attached files
□ video images

51. The basic protocol stack on the Internet is:
□ HTTP
□ HTML
□ TCP
□ TCP/IP

52. A computer connected to the Internet must have:
□ IP address
□ Web server
□ home web page
□ domain name

53. Hyperlinks on a web page can provide a transition:
□ only within this web page
□ only on the web pages of this server
□ to any web page of a given region
□ to any web page of any Internet server

54. An Internet email address has been set: [email protected]. "Name" of the owner of the email address:
□ int.glasnet.ru
□ user_name
□ glasnet.ru
□ en

55. Browsers are:
□ Internet servers
□ antivirus programs
□ programming language translators
□ web browser

56. Web pages have the extension:
□ *.txt
□ *.htm
□ *.doc
□ *.exe

57. A modem is a device designed for:
□ printing information
□ information storage
□ processing information at a given time
□ transfer of information via communication channels

58. You can use the following as hypertext links:
□ just a word
□ picture only
□ any word or any picture
□ a word, group of words or picture

59. A web page is...
□ a special format document published on the Internet
□ a document in which all information on the network is stored
□ document in which user information is stored
□ software menu summary

60. The speed of information transmission over a backbone fiber optic line is usually no less than...
□ 28.8 bps
□ 56.6 Kbps
□ 100 Kbps
□ 1 Mbit/s

61. A domain is...
□ unit of information
□ part of the address that determines the address of the user’s computer on the network
□ name of the program for communication between computers
□ name of the device that communicates between computers

62. Internet email address has been set: [email protected]. “Name” of the computer on which the mail is stored:
□ mtu-net.ru
□ en
□ mtu-net
□ user_name

63. A modem transmitting information at a speed of 28800 bps can transmit in 1 s:
□ two pages of text (3600 bytes)
□ drawing (36 KB)
□ audio file (360 KB)
□ video file (3.6 MB)

64. Hypertext is...
□ very large text
□ text typed on a computer
□ text that uses a large font size
□ structured text in which navigation can be made using selected tags

65. HTML is:
□ Web browser
□ programming language translator
□ Internet server
□ a tool for creating Web pages

66. Internet servers containing file archives allow you to:
□ conduct video conferences
□ create archives
□ participate in teleconferences
□ “download” the necessary files

67. The maximum speed of information transfer over a high-quality dial-up telephone line can reach:
□ 56.6 Kbps
□ 100 Kbps
□ 1 KB/s
□ 1 Mbit/s
68. To transmit web pages over the network, the following protocol is used:
□ www
□ http
□ ftp
□ dns

69. Classification of computer networks by area occupied includes:
□ corporate
□ local
□ regional
□ global

70. The characteristics of a computer network include the following statements:
□ several computers used for similar operations
□ a group of computers connected using special equipment +
□ mandatory presence of a server
□ data exchange between any computers is possible
□ computers must connect directly to each other

71. Local network topologies include:
□ "star"
□ “ring”
□ "tire"
□ "circle"
□ mixed

72. The advantages of the ring topology include:
□ the shortest total length of the physical medium
□ ease of organization and implementation

□ workstations can be inexpensive

73. The advantages of the bus topology include:
□ the shortest total length of the physical medium
□ ease of organization and implementation
□ highest throughput

□ failure of one computer does not affect the operation of the network

74. The advantages of the ring topology include:
□ short total length of the physical medium
□ ease of organizing confirmation of receipt of a message
□ highest throughput
□ workstations can be inexpensive
□ failure of one computer does not affect the operation of the network

75. The following services exist on the Internet:
□ teleconferencing service
□ electronic magazine
□ email
□ ICQ
□ IRC

76. The following addressing systems are accepted on the Internet:
□ system of Russian names
□ domain name system
□ IP addressing
□ UP addressing
□ Greek name system

77. To search for information on the WWW, the following types of search engines are used:
□ search directories
□ search indexes
□ individual search engines
□ ranking search engines
□ general search engines

78. Every search engine contains:
□ search server
□ information server
□ administrator
□ database
□ workstation

79. A graphic editor is a program designed for:
□ creating a graphic image of text
□ editing the type and style of the font
□ work with graphic images
□ diagramming

80. The minimum object used in a raster graphics editor is:
□ screen point (pixel)
□ object (rectangle, circle, etc.)
□ color palette
□ familiar place (symbol)

81. Image deformation when changing the size of the picture is one of the disadvantages:
□ vector graphics
□ raster graphics
□ three-dimensional graphics

82. Using the Paint graphic editor you can:
□ create and edit graphic images
□ edit the type and style of the font
□ customize the animation of graphic objects
□ build graphs

83. Primitives in a graphic editor are called:
□ line, circle, rectangle
□ pencil, brush, eraser

□ sets of colors (palette)

84. The tools in the graphic editor are:
□ line, circle, rectangle
□ pencil, brush, eraser
□ selection, copy, paste
□ sets of colors (palette)

85. The minimum object used in a vector graphics editor is:
□ screen point (pixel)
□ object (line, circle, etc.)
□ color palette
□ familiar place (symbol)

86. The main operations possible in the graphic editor include:
□ line, circle, rectangle
□ pencil, brush, eraser
□ selection, copy, paste
□ sets of colors (palette)

87. Palettes in the graphic editor are:
□ line, circle, rectangle
□ pencil, brush, eraser
□ selection, copy, paste
□ color sets

88. A vector graphic editor is:
□ ACDSee
□Adobe Photoshop
□ Corel Draw
□Paint

89. The 3D studio program is intended for:
□ creating presentations
□ creating hand-drawn films
□ printouts of text documents
□ promotion of sites on the network

90. PhotoShop is intended for:
□ creating presentations
□ creating hand-drawn films
□ photo processing
□ promotion of sites on the network

91. Modern multimedia information is most often distributed:
□ on floppy disks
□ on CD
□ on DVD
□ via network

92. A multimedia program usually requires:
□ having a weak computer
□ having a powerful computer
□ availability of a network of computers
□ availability of additional equipment

93. About the MS Power Point program we can say that it:
□ designed for creating graphic files
□ designed for creating presentations
□ is a multimedia application
□ included with Windows
□ included in MS Office

94. In MS Power Point, there are the following document display modes:
□ regular
□ structures
□ slides
□ slide sorter
□ pages of notes

95. In MS Power Point, there are the following modes for demonstrating a presentation:
□ automatic display by time
□ change slides by mouse click
□ cyclic display until pressing the Esc key
□ cyclic display with changing slides at the click of a mouse
□ production and display of real 35 mm slides

96. You can insert into each slide:
□ text
□ sound
□ program
□ diagram
□ table

97. The “Slide Master” element in MS Power Point is used for:
□ creating a slide master
□ creating a sample presentation
□ font changes
□ background changes
□ insert and display dates

98. In the MS Power Point program, animation is used:
□ when changing slides
□ for text construction
□ at the entrance of the object
□ at the output of the object
□ before the start of the presentation

99. The following types of blocks exist in an organizational chart:
□ manager
□ subordinate
□ colleague
□ assistant
□ co-worker

100. Well-structured problems are solved by information technology:
□ office automation
□ data processing
□ expert systems
□ new

DEPARTMENT OF EDUCATION, SCIENCE AND YOUTH POLICY

VORONEZH REGION

state budget professionaleducational institution of the Voronezh region

"Liskinsky Agricultural and Technological College"

Final test in the discipline “Information technologies in professional activities”

Compiled by:

Filatova Yulia Alexandrovna,

Teacher

1. Information technology is...

2. A computer is -

a) an electronic computing device for processing numbers;

b) a device for storing information of any kind;

c) multifunctional electronic device for working with

information;

d) a device for processing analog signals.

3. A personal computer is used for:

a) Collection of informationb) Transfer of information

C) Classification of information d) Storage of information

4. Information input devices include:

a) keyboard b) monitor c) printer

d) scanner e) modem f) mouse

5. Information output devices include:

a) printer b) modem c) monitor

d) mouse e) hard drivee) sound speakers

6. Specify the device to connect your computer to the network:

a) Modem. b) Mouse. c) Scanner. d) Monitor.

7. Specify which devices are storage devices

Information:

a) Hard magnetic disk b) Modem

c) Printer d) Scanner

8. Indicate which of the following is the “brain” of the computer

a) Microprocessorb) RAM

c) Keyboard d) Operating system e) Hard drive

1. RAM is intended:

a) For long-term storage of information

b) To store immutable information

c) For short-term storage of information

d) For long-term storage of immutable information

10. For long-term storage of information the following is used:

A) RAM; b) processor;

c) magnetic disk; d) disk drive.

11. The main characteristic of the microprocessor is

a) speed;b) sweep frequency;

B) compactness; d) resolution;

D) capacity (size);

12. What function do peripheral devices perform?

A) information storage b) information processing

c) input-output of informationd) computer control

13. Server is:

a) a computer that provides users with access to any

resources;

b) a computer with an Internet connection;

c) laptop computer;d) workstation;

e) a computer with a modem connected to a telephone line.

14. Indicate which class (type) of software (software)

Operating systems include:

A) System software. c) Programming systems.

b) Application software. d) Unique software.

15. The basis of the operating system is:

a) operating system kernelc) RAM

b) driver d) user

16. The executable file of the program has the extension:

a) exe b) dll c) txt d) doc

17. A set of programs that are designed to manage

Computer resources and computing processes, as well as for

The organization of user interaction with equipment is called....

A) operating system c) processor

B) file system d) hard drive

18. The file is:

A) a program or data on disk that has a name;

b) unit of measurement of information; c) program;

19. The file system is:

a) a system of units of information measurement;

b) a system of programs for displaying information;

c) a program or data on disk that has a name;

G) information storage system;

20. What program is a word processor?

A) Excel b) Paint c) Access d) Word

21. Which program is a table processor?

A) Word b) Paint c) Access d) Excel

22. Which program is a graphic editor?

A) Excel b) Word c) Access d) Paint

23. Microsoft Word is designed to:

a) only for creating text documents;

b) to create text documents with graphic elements;

c) only for creating graphic images;

d) only for creating graphic images with elements

Text;

24. Using the clipboard you can:

a) insert pictures from a graphic editor into a text editor

Editor;

b) duplicate fragments of text or graphics;

c) copy or move files and folders;

d) carry out all of the above actions;

25. The elementary object of a spreadsheet is...

A) sheet b) cell c) row d) column

26. A spreadsheet is:

a) an application program for processing code tables;

b) a personal computer device that manages its resources;

c) an application program designed to process

structured in the form of a table of data;

d) a system program that manages personal resources

Computer when processing tables.

27. The spreadsheet is intended for:

a) processing predominantly numerical data, structured

using tables;

b) orderly storage and processing of large arrays

Data;

c) visualization of structural relationships between data,

Presented in tables;

d) editing large graphical representations

Information.

28. Graphics formed from objects of graphic primitives and

The mathematical formulas describing them:

a) vector b) raster c) pixel d) dot

29. Any image in video memory is represented in... form.

a) raster b) vector c) combined d) linear

30. Indicate the name of the software package designed for

Database creation and maintenance:

a) DBMS. b) ACS. c) IS. d) SU.

31. Files created in MS Access have the extension:

A) .doc; b) .xls; c) .dbf; d) .mdb; d) . mрЗ.

32. The MS Access program is intended for:

a) processing graphic information;

b) processing text information;

c) making payments;

d) for storing large amounts of data and outputting the necessary

information;

e) computer resource management.

33. A network in which computers in different countries are connected, on

Various continents.

a) Global networkb) Local networkc) Regional network

34. A network that connects computers in a room or adjacent rooms.

A) Global networkb) Local networkc) Regional network

35. A network connecting computers within a certain region.

A) Global network b) Local networkc) Regional network

36. Server location address in Internet. This is often called the whole

Web collection -pages located on the server.

A) Website b) Server c) Puncture d) Browser

37. Network node containing data and providing services to others

Computers; a computer connected to a network and used for

Information storage.

A) Website b) Server c) Puncture d) Browser

38. Electronic mail (e-mail) allows you to transmit:

A) messages only; b) files only;

c) messages and attached files;d) video image only;

39. A computer connected to the Internet must have:

a) IP address; b) WEB - server;

B) home WEB page; d) domain name;

40. A computer virus is:

a) any program created in low-level languages;

b) a program for checking and treating disks;

c) a program copied from a poorly formatted floppy disk;

d) a special small program that can

attribute itself to other programs, it has

the ability to “reproduce”;