Rows of the spreadsheet are numbered. Active Cell is a cell

Test on spreadsheets

Choose all the right answers to test questions.

1. The spreadsheet is:

1) a personal computer device that controls its resources in the data processing process in tabular form;

2) application program for processing code tables;

3) application program designed to handle data structured in the form of a data table;

4) system program, managing a personal computer resources when processing tables.

2. The spreadsheet is designed for:

1) processing predominantly numeric data structured using tables;

2) streamlined storage and processing of significant data arrays;

3) visualization of structural links between the data presented in the tables;

4) editing graphic representations of large amounts of information.

3. The spreadsheet is:

1) a combination of rows and columns called by an arbitrary way.

2) a combination with the letters of the Latin alphabet of rows and numbered columns;

3) a combination of numbered lines and columns;

4) a combination of numbered rows and the column alphabet named Latin alphabet letters.

4. Rows of the spreadsheet:

1) referred to as the user is called an arbitrary manner;

2) denoted by the letters of the Russian alphabet;

E.V. Kovrigina. Creating and editing spreadsheets in OpenOffice.org environment.

3) denoted by the letters of the Latin alphabet;

4) Numbers.

5. In the general case, the columns of the spreadsheet:

1) numbered;

2) denoted by the letters of the Latin alphabet;

3) denoted by the letters of the Russian alphabet;

4) are referred to as an arbitrary manner.

6. For the user of the spreadsheet cell is identified:

1) by the user arbitrarily asked;

2) address of the machine word of RAM, allotted under the cell;

3) special code word;

4) by sequentially specifying the name of the column and the line number, the intersection of which is located a cell.

7. Computational formulas in the cells of the spreadsheet are written:

1) in a conventional mathematical record;

2) special with the use of built-in features and by the rules adopted to record expressions in programming languages;

3) according to the rules adopted exclusively for spreadsheets;

4) according to the rules taken exclusively for databases.

8. Expression 3 (A1 + B1): 5 (2B1-3A2), recorded in accordance with the rules adopted in mathematics, in the electronic table OpenOffice.org Calc is:

10. Photography of the formula in the spreadsheet can not include:

11.Diapace cells is:

1) the set of cells forming the area of \u200b\u200bthe rectangular form in the table;

2) all cells of one line;

3) all cells of one column;

4) many permissible values.

12. Activial cell is a cell:

1) to record commands;

2) containing a formula that includes the name of the cell in which data is input;

3) the formula containing references to the contents of the dependent cell;

4) in which data is executed.

13. What formula will be obtained in OpenOffice.org Calc when copying into the E4 cell, formulas from the E2 cell (in E2: \u003d A2 * C2):

E.V. Kovrigina. Creating and editing spreadsheets in OpenOffice.org environment.

16.What should be changed if an error ### is issued in the cell:

17.The linked letter in the menu bar means:

1) opening a cascade menu;

2) the command is not available;

3) run a command when pressing the Alt key;

4) the team is active.

18.First addressing cells:

1) the cell address is defined relative to the location;

2) the cell address is defined relative to the column name;

3) the cell address is defined relative to the string name.

20.The Cell Word Transfer to OpenOffice.org Calc must be used:

E.V. Kovrigina. Creating and editing spreadsheets in OpenOffice.org environment.

1) format - string;

2) format - column;

3) Format cells.

21. For framing part of the table in OpenOffice.org Calc, you should take advantage of:

1) the corresponding button on the toolbar;

2) Format - cells - framing;

3) format - styles;

4) draw manually.

22. The formula in this begins with:


	function name;		with the necessary operation.

23.Diagram is:

1) visual image;

2) graphic display of table data;

3) schedule;

4) Dependence.

24. What actions correctly do to get the answer to the question: "How many percent is 25 from the number 93?":

1) in the cells to write the formula "25/93";

2) in the cells to write the formula "\u003d 25/93";

3) in the cells to write the formula "\u003d 25 * 100/93";

4) in the cells to write the formula "\u003d 25/93" and choose the percentage format.

25.For writing text vertically necessary:

E.V. Kovrigina. Creating and editing spreadsheets in OpenOffice.org environment.

1) combine cells;

2) put a $ sign;

3) Select the direction of the text in the cell format;

4) Align text in cell format.

26.The table sorting in OpenOffice.org Calc follows:

1) specify the range and select the "Sort by ..." button from the toolbar;

2) use the menu item data - filter;

3) use the menu item Data - Sort;

4) specify the range and use the menu item Data - Sort.

27. In order to build a circular diagram you need to choose:

1) chart variant;

2) the type of chart;

3) range diagram.

28.The preservation of the OpenOffice.org Calc document in another format is necessary:

2) change file extensions after saving;

3) select Tools - Parameters - Open Office Calc;

4) select Tools - Options - Download / Save. 29. What are you using a $ sign:

1) for relative cell addressing;

2) to specify the range of cells;

3) for absolute addressing cells;

4) for writing formulas.

30.What can be done using autofilter:

1) data sorting;

E.V. Kovrigina. Creating and editing spreadsheets in OpenOffice.org environment.

2) selection of data corresponding to request;

3) delete data;

4) Pouring cells.

31.The locomotive autosums in OpenOffice.org Calc use:

	aBS function;		eND function;
	sUM function;		iF function.

32. Diapace cells are written through:

34. The selection of individual cells must be kept key:

35. For a change in the format in OpenOffice.org Calc under a certain condition it is necessary to use:

1) Format - cells;

2) Format - page;

3) Format - conditional formatting;

4) Format - styles.

36. Is it possible to sort over several parameters?

1) Yes;

E.V. Kovrigina. Creating and editing spreadsheets in OpenOffice.org environment.

3) under certain conditions.

37.Faster to remove the grid lines in OpenOffice.org Calc, you must use:

2) Service - Parameters - OpenOffice.org Calc - Mesh;

38. How will the formula "\u003d A1 + B $ 1" change (OpenOffice.org Calc), written in cells A2 in cells A4?

39.How will change the formula "\u003d A1 + B $ 1" (OpenOffice.org Calc), written in cells A2 in cells B4?

40.The Creating a list in OpenOffice.org Calc, used for autofilement, you need:

1) Service - Parameters - OpenOffice.org Calc - View;

2) Service - Parameters - OpenOffice.org Calc - Sort Lists;

3) Service - Parameters - OpenOffice.org Calc - General;

4) Service - Parameters - OpenOffice.org Calc - Changes.

41.stroke, which displays formulas in OpenOffice.org Calc, called:

1) line formulas;

2) input row;

E.V. Kovrigina. Creating and editing spreadsheets in OpenOffice.org environment.

3) String name.

42. On the intersection of the string and column it turns out:

43.In the cells are obtained from:

1) row name and column name;

2) column name and string name;

3) line name;

4) the name of the column.

44.Cax is called a selected object

1) figure;

2) filling;

3) autocomplete marker;

4) Marker.

45.Cax you can change the column width in:

1) drag the boundary between columns A and B;

2) drag the border between columns in and C;

3) drag the boundary between the columns A1 and B1;

4) drag the border between the columns B1 and C1.

46. \u200b\u200bHow can you confirm the input of the text at the same time in all

cells

1) press the Alt keyboard key;

2) press the keyboard keys Ctrl + Enter;

E.V. Kovrigina. Creating and editing spreadsheets in OpenOffice.org environment.

4) Press the "Cross" near the input row.

47. How can you confirm the input of the text to the cell?

1) press one of the keyboard control keys;

2) press the ENTER keyboard keys;

3) press the "tick" near the input row;

4) press the "Cross" near the input row.

48. For what purpose in OpenOffice.org Calc can use the specified

1) to display a monetary unit;

2) for leveling horizontal;

3) to combine cells;

4) to display a numeric format.

49. Is it possible to create several diagrams on one sheet?

1) yes, any quantity;

2) yes, any quantity, only for tables located on this sheet;

3) yes, any quantity, only for tables located in this book;

4) No.

50. What symbol is used as a multiplication sign?

51. Is it possible to use parentheses when entering formulas?

1) yes, always;

2) yes, but only when using absolute links;

3) yes, but only when using references to other sheets;

4) No E.V. Kovrigina. Creating and editing spreadsheets in OpenOffice.org environment.

52. What symbols can be used in formulas as a division sign?

54. What menu can be used for complex data sorting in the table?

55.What can not be used as source data when creating a diagram:

1) two tables located on one sheet;

2) two tables located on different sheets;

3) two tables located in different books;

4) other diagram.

Answers to the test:

Spreadsheets

Tabular processor - Category of software designed to work with spreadsheets. Initially, tabular editors allowed to process exceptionally two-dimensional tables, first of all with numeric data, but then products that have the opportunity to include text, graphic and other multimedia elements beyond the ability to include textual, graphic and other multimedia elements. The spreadsheet of the spreadsheet includes powerful mathematical functions, allowing to maintain complex statistical, financial and other calculations.

Spreadsheets (or tabular processors) are applied programs designed for table calculations. The appearance of spreadsheet historically coincides with the beginning of the distribution of personal computers. The first program for working with spreadsheets is a tabular processor, was created in 1979, it was intended for computers such as Apple II and called VisiCalc. In 1982, the famous Lotus 1-2-3 table processor appears, intended for IBM PC. Lotus combined the computational capabilities of spreadsheets, business graphics and relative DBMS functions. The popularity of table processors grew very quickly. New software products of this class appeared: Multiplan, Quattro Pro, SuperCalc and others. One of the most popular table processors today is MS Excel, which is part of the Microsoft Office package.

What is the spreadsheet? This is a means of information technology that allows you to solve a whole range of tasks: first of all, the execution of calculations. Many calculations have long been implemented in tabular form, especially in the field of office work: numerous calculated statements, tabulars, cost estimates, etc. In addition, the solution with numerical methods of a number of mathematical problems; It is convenient to perform in tabular form. The spreadsheets are a convenient tool for automating such calculations. Solutions of many computational tasks on the computer, which used to be carried out only by programming, it became possible to realize mathematical modeling. The use of mathematical formulas in this allows you to submit a relationship between different parameters of some real system. The main property is an instantaneous recalculation of formulas when changing the values \u200b\u200bof the operands included in them. Thanks to this property, the table is a convenient tool for organizing a numerical experiment:

selection of parameters,
forecast of the behavior of the simulated system,
dependency analysis
planning.

Additional simulation facilities makes it possible to graphically present data (diagrams); Use the spreadsheet as a database. Of course, compared to DBMS, spreadsheets have fewer opportunities in this area. However, some data manipulation operations characterized by relational DBMS are implemented in them. This is a search for information on specified conditions and sorting information.

The spreadsheets also provide graphical mode of operation, which makes it possible to graphically represent (in the form of graphs, diagrams) of numerical information contained in the table.

Main data types: Numbers, both in conventional and exponential format, text - a sequence of symbols consisting of letters, numbers and spaces, formulas. Formulas should begin with a sign of equality, and may include numbers, cell names, functions (mathematical, statistical, financial, text, date and time, etc.) and mathematical operations.

The spreadsheets are easy to use, quickly mastering the non-professional users of the computer and simplify and speed up the work of accountants, economists, scientists.

The main elements of spreadsheets:

Column,
Column headlines,
Line,
Row headlines,
Inactive cell
Active cell.

History

The idea of \u200b\u200bspreadsheet first formulated the American scientist Richard Mattessich, published in the city called "Budgeting Models and System Simulation". The concept was supplemented in Pardo and Landau, submitted an application for the appropriate patent (U.S. Patent 4,398,249 (English)). The Patent Office rejected the application, but the authors through the court achieved the abolition of this decision.

The generally accepted investigator of spreadsheets as a separate class software is Dan Briklin, together with Bean Frankston, who has developed a legendary VisiCalc program in this table editor for the Apple II computer, became a "slaughter application", which turned a personal computer from an exotic toy for technofils into a massive tool for business.

Subsequently, numerous products of this class appeared on the market - SuperCalc, Microsoft Multiplan, Quattro Pro, Lotus 1-2-3, Microsoft Excel, OpenOffice.org Calc, AppleWorks Tables and

List of software products

Links

Wikimedia Foundation. 2010.

Watch what is "spreadsheet" in other dictionaries:

A computer program that supports the presentation of data in the form of tables consisting of rows and graphs, on the intersection of which cells are located (table cells). The value in the numeric cell of the table is either indicated in a clear form, or ... ... Financial vocabulary

Spreadsheets - a computer program in the form of spreadsheets representing digital data on a computer screen, organized into strings and columns, and allow you to analyze financial information, make calculations and make changes to these calculations on ... ... Investment Dictionary

Graphic images and elements of numerous and variety of devices and devices of electronics, automation, radio and computers. Design and development of basic electronic circuits and more complex systems created from them just ... Encyclopedia Color

Opto-electronic detectors - 4.2.2. Optical electronic detectors optical electronic detectors with a linear or surface narrow detection zone (curtain type) are recommended for blocking windows (including double-glazed windows), doors, walls, ceilings, ... ... Dictionary directory terms of regulatory and technical documentation

This is a combination of chemical elements with a similar arrangement of valence electrons in the atom. The similarity is that the valence electrons with the highest energy they occupy an orbital of the same type. The term first appeared in the works ... ... Wikipedia

Category of software designed to work with spreadsheets. Initially, tabular editors allowed to process exceptionally two-dimensional tables, primarily with numerical data, but then products appeared, ... ... Wikipedia

OpenOffice.org Calc spreadsheet computer program that allows you to calculate with data, pre ... Wikipedia

- ... Wikipedia

Type of spreadsheet Text Presentation Processor ... Wikipedia

Survey article on signs (symbols) currencies currency signs about individual signs See articles symbol of the ruble, dollar symbol, symbol of the pound, symbol of drama, dram symbol, symbol of denier, symbol of rial, symbol of rupees, symbol of yen, symbol ... ... Wikipedia

Books

Spreadsheets, functions, databases and interrelations. Charts. Lists. Macros, Svetlana Muratova. This laboratory workshop is used when learning the course "Electronic tables, functions, databases and relationships" (section "Charts. Lists. Macros") is continued ...

Tasks chapters

1. Consider the main features of working with modern electronic documents.
2. Get information about file types.
3. Describe work techniques with spreadsheets as with databases.
4. Examine the technology of creating consolidated tables.
5. Consider the capabilities of MS Excel on data visualization.

Basic concepts

Spreadsheets (tabular processors)- This is a general-purpose application software designed to process various data representable in tabular form.

With the help of spreadsheets, you can solve financial, economic, mathematical and statistical tasks.

ELECTRONIC TABLES Apply to storage of accounts and amendments to them, multivariate prediction of the results of alleged financial transactions, the preparation of various forms, business schedule and the fulfillment of the full balance of firm. With the help of spreadsheets, it is possible to facilitate solving such tasks as processing of orders and planning production, tax calculation and wages, accounting for personnel and costs, sales management, drawing up price lists, etc.

The appearance of spreadsheet historically coincides with the beginning of the distribution of PC. The first program for working with spreadsheets - a tabular processor was created in 1979, intended for computers such as Apple II and called VisiCalc. In 1982, the famous Lotus 1-2-3 tabular processor appears, designed for IBM PC. Lotus combined the computational capabilities of spreadsheets, business graphics and relative DBMS functions. The popularity of table processors grew very quickly. New software products of this class have appeared: Multiplan, Quattro Pro, Supercalc, etc. One of the most popular table processors today is MS Excel, which is part of the Microsoft Office package.

The MS Excel 2007 software product developed by Microsoft is a popular medium to work with spreadsheets. Functionality and MS Excel 2007 computing means allow you to solve many engineering and economic tasks, presenting data not only in tabular, but also in graphical form.

MS Excel allows you to carry out a wide range of calculations in spreadsheets, easily and quickly analyze a large amount of data, to carry out statistical data processing, solve data optimization tasks, create and edit macros to apply them for frequently repetitive operations and automation of routine work.

MS Excel allows you to:

■ build complex formulas for calculations;

■ carry out statistical data processing;

■ Create summary tables;

■ model business situations;

■ Record macros using macrorekoder and edit them;

■ Making requests to external database.

Workbook- This is a regular document or file type in Microsoft Excel for Windows (File Extension - XLS).

Each book may contain several sheets. By default, they are called: sheet 1, sheet 2, etc. These names are displayed on the labels located at the bottom of the working book window (Fig. 12.1).

Fig. 12.1

Work sheetit is a grid of columns and strings (Fig. 12.2).

Each cell is formed by the intersection of the string and column and has its own unique address (link). For example, a cell located at the intersection of a column C and string 4 has a C4 address. Addresses are used when writing formulas or circulation to cells.

Fig. 12.2.

Cell- Minimum information unit (Fig. 12.3). It can contain different types of data (text, numbers, dates, etc.), but inside one cell, only one type of data can be stored. Cells can be in a state: a) active or dedicated cell (cellular block can be highlighted); b) editable cell (can only be one at a certain point

time). In the editing state, you can change the contents of the cell, add or delete data. For an active cell, you can specify the format - height / width, alignment, color, borders, and the like. To go to the cell editing state, you must double click on the left mouse button on the cell or press the F2 key. Not all commands available

Fig. 12.3.

for active cells, are performed for cells in the edit state.

Chart list - a sheet containing only Microsoft Excel chart.

The diagram is a graphical representation of the working sheet data (Fig. 12.4).

Fig. 12.4.

Toolbars allow you to streamline Microsoft Excel commands so that they are easy to find and use. Toolbar You can configure: add and delete menu and buttons, create new toolbar, as well as display, hide and move existing toolbars. Setting the main menu is performed in the same way as any other built-in toolbar, for example, in the main menu, you can add and delete buttons and menus. When the menu is selected, the list is displayed (Fig. 12.5).

Fig. 12.5.

After starting MS Excel, a window appears on the screen (Fig. 12.6), consisting of several elements:

■ header lines containing the name of the program proposed by the file name, standard Windows buttons;

■ menu rows containing the main menu items;

Fig. 12.6.

■ Toolbars (icons), which can determine the user itself using the menu item View / Toolbar;

■ Lines of formula that displays the input information;

■ scroll lines (vertical and horizontal), allowing to work with large tables;

■ Status strings reflecting information about the current state and the results of Excel operations performed.

In addition to the main menu, Excel contains the so-called context menuscontaining the most used commands to work with cells, diagrams or other objects.

The context menu is activated by pressing right Mouse buttons (or SHIFT + F10). To exit the context menu, you need to click the mouse button out or press ESC.

Spreadsheets

TEST

1. The spreadsheet is:

application program designed to handle data structured in the form of a data table;

application program for processing code tables;

a PC device that controls its resources during data processing in tabular form;

system program that controls PC resources when processing tables.

2. The spreadsheet is designed for:

processing predominantly numeric data structured using tables;

streamlined storage and processing of significant data arrays;

visualization of structural links between the data presented in the tables;

editing graphic representations of large amounts of information.

3. The spreadsheet is:

a combination of numbered lines and the column alphabet launched by the letters of the Latin alphabet;

a combination with the letters of the Latin alphabet of rows and numbered columns;

a combination of numbered lines and columns;

a combination of rows and columns called by an arbitrary way.

4. Rows of the spreadsheet:

numbers.

5. In general, the posts of the spreadsheet:

denoted by the letters of the Latin alphabet;

numbers;

denoted by the letters of the Russian alphabet;

referred to as users randomly;

6. For the user, the cell of the spreadsheet is identified:

by sequentially specifying the name of the column and the line number, on the intersection of the cell;

address of the machine word of RAM, allotted under the cell;

special code word;

the name arbitrarily asked by the user.

7. Computational formulas in the cells of the spreadsheet are written:

in a conventional mathematical record;

specially with the use of embedded functions and by the rules adopted to record expressions in programming languages;

according to the rules adopted exclusively for spreadsheets;

according to the rules taken exclusively for databases.

8. Expression 5 (A2 + C3): 3 (2B2-3D3) The spreadsheet is:

5 (A2 + C3) / 3 (2B2-3D3);

5 * (A2 + C3) / 3 * (2 * B2-3 * D3);

5 * (A2 + C3) / (3 * (2 * B2-3 * D3));

5 (A2 + C3) / (3 (2B2-3D3)).

9. Select the correct formula for the formula for the spreadsheet:

C3 + 4 * D4

C3 \u003d C1 + 2 * C2

A5B5 + 23.

A2 * A3-A4

10. When moving or copying, absolute links in the electronic table:

do not change;

are converted depending on the new position of the formula;

converted depending on the rules specified in the formula.

11. When moving or copying in the spreadsheet, relative links:

converted regardless of the new position of the formula;

converted depending on the length of the formula;

do not change;

we are converted depending on the new position of the formula.

12. Range is:

the combination of cells forming the area of \u200b\u200bthe rectangular form in the table;

all cells of one line;

all cells of one column;

many permissible values.

13. Active Cell is a cell:

to record commands;

in which commands are executed.

14. What formula will be obtained when copying to C3 cell, formulas from C2 cell:

A1 * A2 + B2;

\u003d $ A $ 1 * $ A $ 2 + $ B $ 2;

\u003d $ A $ 1 * A3 + B3;

\u003d $ A $ 2 * A3 + B3;

\u003d $ B $ 2 * A3 + B4?

15. What will be the value of the C1 cell, if entering it formula \u003d A1 + B1:

Perhaps it will be useful to read: