In a spreadsheet, a collection of padding cells. Methodical recommendations on the organization of extracurricular activities in educational institutions of the Tomsk region Dozmorova E.V., Ph.D., Vice-rector for nr toipkro

A spreadsheet is a computer program that allows calculations with data presented in the form of two-dimensional arrays that simulate paper tables. Some programs organize data into “sheets”, thus offering a third dimension. Spreadsheets (ETs) are a handy tool for automating calculations. Many calculations, in particular in the field accounting, are performed in tabular form: balances, payrolls, cost estimates, etc. In addition, it is convenient to solve a number of mathematical problems by numerical methodsexactly in tabular form. Using mathematical formulas in spreadsheets allows you to represent the relationship between various parameters of some real system. Solutions to many computational problems that previously could only be accomplished through programming have become possible through mathematical modeling in a spreadsheet.

Worksheets and books... When working on a computer, the spreadsheet exists in the form worksheet which has a name (e.g. Sheet 1). Worksheets are combined into books, and the user can insert, copy, delete and rename worksheets. When you create, open, or save a document in spreadsheets, it is actually about creating, opening, or saving a workbook.

When working with spreadsheets, you can enter and modify data on multiple worksheets at the same time, and perform calculations based on data from multiple sheets.

Cell range... In the process of working with spreadsheets, it is quite often necessary to select several cells - a range of cells. The range is specified by the cell addresses of the upper and lower limits of the range, separated by colons. You can select several cells in a column (range A2: A4), several cells in a row (range C1: E1) or a rectangular range (range SZ: E4) (Table 1.2).

Appearance tables... You can change the appearance of a table, selected ranges of cells, or individual cells. For cell borders, you can set different types of lines (single, dotted, double, etc.), their thickness and color. The cells themselves can be painted in any color by choosing a color from the color palette.

Editing Sheets... You can remove columns, rows, ranges of cells, and individual cells from a table. In the process of deleting ranges of cells and individual cells, you need to indicate in which direction (left or up) the cells will be shifted.

You can insert columns, rows, and cells into a table. In the process of inserting ranges of cells and individual cells, you need to specify in which direction (to the right or down) the cells will be shifted.

· carrying out calculations of the same type over large data sets;

· automation of final calculations;

· solving problems by selecting parameter values, tabulating formulas;

· processing the results of experiments;

· searching for the optimal values ​​of the parameters;

· preparation of tabular documents;

· building charts and graphs from the available data.

The Excel document is called working book. The workbook is a set worksheets, each of which has a tabular structure and can contain one or more tables. The document window in Excel displays only current the worksheet with which the work is carried out. Each worksheet has title, which is displayed on sheet tab, displayed at the bottom. Using shortcuts, you can switch to other worksheets in the same workbook. To rename a worksheet, double-click on its tab.

Cells and their addressing... At the intersection of columns and rows, table cells. They are the minimum elements for storing data. The designation of a separate cell combines the column and row numbers (in this order) at the intersection of which it is located, for example: A1 or DE234. The cell designation (its number) serves as its address. Cell addresses are used when writing formulas that determine the relationship between values ​​located in different cells.

Range of cells.Data in adjacent cells can be referenced in formulas as a whole. This group of cells is called range. Most often rectangular ranges are used, formed at the intersection of a group of consecutive rows and a group of consecutive columns. A range of cells is indicated by specifying the numbers of cells located in opposite corners of the rectangle separated by colons, for example: A1 :C15 .

A single cell can contain data of one of three types: text, number or formula ,– and also stay empty. Program Excel when saving the workbook, it writes to the file only the rectangular area of ​​the worksheets adjacent to the upper left corner (cell A1 ) and containing all filled cells.

The type of data placed in the cell is determined automatically as you type. If this data can be interpreted as a number, the Exc program el it does so. Otherwise, the data is treated as text. Formula input always starts with the symbol“=” (equal sign).

Enter text and numbers. Data is entered directly into the current cell or into formula bar , located in the upper part of the program window directly below the toolbars. The insertion point is marked with a text cursor. If you start typing by pressing the alphanumeric keys, the data from the current cell is replaced by the text you enter. If you click on the formula bar or double-click on the current cell, the old cell content is not deleted and you can edit it. The entered data is displayed anyway: both in the cell and in the formula bar.

To complete the entry, saving the entered data, use the button Enter in the formula bar or the key Enter ... To cancel the changes made and restore the previous value of the cell, use the button Cancellation in the formula bar or the key Esc ... The easiest way to clear the current cell or selected range is to use the key Delete.

Formatting the contents of cells. Text data is by default aligned to the left of the cell, and numbers–on the right. To change the display format of the data in the current cell or selected range, use the commandFormat> Cells... The tabs of this dialog box allow you to select the data recording format (the number of decimal places, the currency, the way the date is written, etc.), set the direction of the text and the method for aligning it, define the font and style of symbols, control the display and appearance of frames, set the background color.

Formulas. Calculations in program tablesExcelcarried out by formulas. The formula can contain numeric constants, links on cells and functions Excelconnected by signs of mathematical operations. The parentheses allow you to change the standard order of actions. If the cell contains a formula, the worksheet displays the current calculation result for that formula. If you make a cell the current one, then the formula itself is displayed in the formula bar.

The rule of using formulas in a programExcelis that if the cell value really depends on other cells in the table, always a formula should be used, even if the operation can be easily done in the “mind”. This ensures that subsequent editing of the table does not compromise its integrity and the correctness of the calculations performed in it.

To edit a formula, double-click on the corresponding cell. In this case, the cells (ranges) on which the value of the formula depends are highlighted on the worksheet with colored frames, and the links themselves are displayed in the cell and in the formula bar in the same color. This makes it easier to edit and validate formulas..

For example, in the cell V 2 there is a cell reference AZ... In relative terms, you can say that the link points to a cell that is one column to the left and one row below the given one. If the formula is copied to another cell, this relative reference will be preserved. For example, when copying a formula to a cell EA27 the link will continue to point to the cell to the left and below, in this case the cellDZ28.

At absolute addressing the addresses of the links do not change when copied, so the cell that the link points to is treated as non-tabular. To change the addressing method when editing a formula, select a cell reference and press the keyF4. Cell number elements using absolute addressing are preceded by $. For example, with successive presses keys F4 cell number A1 will be written as A1, $ A $ 1, A $ 1 and $ A 1In the last two cases, one of the components of the cell number is considered as absolute, and the other–as relative.

Copying and moving cells in the programExcelcan be done by drag and drop or via the clipboard. When working with a small number of cells, it is convenient to use the first method, when working with large ranges- second.

Clipboard application. The transfer of information through the clipboard has in the programExcelcertain features associated with the complexity of control over this operation. First, you need to select the range to be copied (cut) and give the command to place it on the clipboard:Edit> Copy or Edit > Cut... Pasting data into a worksheet is possible only immediately after it is placed on the clipboard. Any attempt to perform any other operation will result in the cancellation of the started copy or move process. However, no data is lost because the "cut" data is removed from its original location only at the time of the paste.

Search for a solution. This add-in is used to solve optimization problems. Cells for which optimal values ​​are selected and constraints are set are selected in the dialog box Finding a solution , which is opened with the commandService> Finding a solution.

Template wizard for collecting data. This add-in is designed to create templates that serve as forms for entering records into the database. When a workbook is created from a template, the data entered into it is automatically copied to the database associated with the template. The wizard is launched by the commandData> Template Wizard.

Web Forms Wizard. Add-on Designed to create a form to be hosted on a Web site. The form is organized in such a way that the data entered by visitors is automatically added to the database associated with the form. An Excel form for collecting data must be created on a worksheet in advance. Setting up the data collection system is organized using a wizard, which is launched by the commandService> Master> Web form.

In a programme Excelterm diagram is used to refer to all kinds of graphical representations of numerical data. The construction of a graphic image is based on a number of data. This is the name for a group of cells with data within a single row or column. Multiple data series can be displayed in one chart.

To build a diagram, usually use Chart Wizard button clicked Chart Wizard on the standard toolbar. It is often convenient to pre-select the area containing the data that will be displayed in the chart, but you can also specify this information during the wizard.

Chart type... At the first stage of the work, the wizards choose the shape of the diagram. The available forms are listed in the list Type on the Standard tab ... For the selected chart type, several options for presenting data are indicated on the right (the palette View ), from which you should choose the most suitable one. In the tab Non-standard a set of fully formed chart types with ready formatting is displayed. After defining the shape of the diagram, click on the button Further .

Data selection.The second stage of the wizard is used to select the data on which the diagram will be built. If the data range has been previously selected, a rough preview of the future chart will appear in the preview area at the top of the wizard. If the data forms a single rectangular range, then it is convenient to select them using the tab

Data range... If the data does not form a single group, then the information for drawing individual data series is set on the tab Row ... The preview of the chart is automatically refreshed when the set of displayed data changes.

Chart design. The third stage of the wizard (after clicking the button Further ) consists in choosing the design of the diagram. On the tabs of the wizard window, you can set:

· chart title, axis labels (tab Headings);

· display and labeling of coordinate axes (tab Axles);

· displaying a grid of lines parallel to coordinate axes (tab Grid lines);

· description of the plotted graphs (tab Legend);

· display of labels corresponding to individual data items on the chart (tab Data signatures);

· presentation of the data used in the construction of the graph in the form of a table (tab Data table).

Placement of the chart. At the last stage of the wizard (after clicking on the button Further ) specifies whether to use a new worksheet or one of the existing worksheets to place the diagram. Usually, this choice is only important for subsequent printing of a document containing a diagram. After clicking on the button Ready the diagram is built automatically and inserted into the specified worksheet.

Editing the diagram. You can change the finished diagram. It consists of a set of individual elements, such as the graphs themselves (data series), coordinate axes, chart title, plot area, and so on. When you click on a chart element, it is highlighted with markers, and when you hover over it, it is described by a tooltip. You can open a dialog box for formatting a chart element through the menu Format (for the selected item) or through the context menu (command Format ). The various tabs of the dialog box that opens allow you to change the display parameters of the selected data item.

To delete a chart, you can delete the worksheet on which it is located (Edit> Delete Sheet), or select a chart embedded in the data worksheet and press the key Delete.

»[Teacher] [Quizzes] [Spreadsheets]

ELECTRONIC TABLES

TEST

1. A spreadsheet is:

1. an application program designed to process data structured in the form of a table;
2. application program for processing code tables;
3. a PC device that manages its resources in the process of processing data in tabular form;
4. a system program that manages PC resources when processing tables.

2. The spreadsheet is intended for:

1. processing predominantly numerical data structured using tables;
2. orderly storage and processing of significant amounts of data;
3. visualization of structural relationships between data presented in tables;
4. editing graphical representations of large amounts of information.

3. The spreadsheet is:

1. a set of numbered lines and columns named by letters of the Latin alphabet;
2. a set of rows and numbered columns named by letters of the Latin alphabet;
3. a collection of numbered rows and columns;
4. a collection of rows and columns, arbitrarily named by the user.

4. Rows of the spreadsheet:

1. are numbered.

5. In general, the columns of a spreadsheet are:

1. denoted by letters of the Latin alphabet;
2. are numbered;
3. denoted by the letters of the Russian alphabet;
4. are named by users in an arbitrary way;

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

1. by sequentially specifying the name of the column and the row number at the intersection of which the cell is located;
2. the address of the machine word of the RAM allocated for the cell;
3. special code word;
4. a user-definable name.

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

1. in the usual mathematical notation;
2. in a special way using built-in functions and according to the rules adopted for writing expressions in programming languages;
3. according to the rules adopted exclusively for spreadsheets;
4. according to the rules adopted exclusively for databases.

8. Expression 5 (A2 + C3): 3 (2B2-3D3) in the spreadsheet looks like:

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

9. Select the correct formula entry for the spreadsheet:

1. C3 + 4 * D4
2. C3 = C1 + 2 * C2
3. A5B5 + 23
4. = A2 * A3-A4

10. When moving or copying in a spreadsheet, absolute references:

1. do not change;
2. are transformed depending on the new position of the formula;
3. are converted depending on the rules specified in the formula.

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

1. are transformed regardless of the new provision of the formula;
2. converted depending on the length of the formula;
3. do not change;
4. are converted depending on the new position of the formula.

12. Range is:

1. a set of cells that form a rectangular region in the table;
2. all cells in one row;
3. all cells in one column;
4. set of valid values.

13. The active cell is the cell:

1. to record commands;
2. containing a formula including the name of a cell in which data entry is performed;
3. a formula that contains references to the contents of a dependent cell;
4. in which commands are entered.

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

1. = A1 * A2 + B2;
2. = $ A $ 1 * $ A $ 2 + $ B $ 2;
3. = $ A $ 1 * A3 + B3;
4. = $ A $ 2 * A3 + B3;
5. = $ B $ 2 * A3 + B4?

15. What will be the value of cell C1 if you enter the formula = A1 + B1 into it:

16. What will be the value of cell C1, if you enter the formula = SUM (A1: A7) / 2 into it:

KEY

"Test ___ ELECTRONIC TABLES_1 grade 9"

ELECTRONIC TABLES

1. A spreadsheet is:

2. Expression 5 (A2 + C3): 3 (2B2-3D3) in 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)).

3. What will be the value of cell C1, if you enter the formula = A1 + B1 into it:

20; 2. 15; 3. 30; 4. 10?

4. The spreadsheet is intended for:

processing predominantly numerical data structured using tables;

orderly storage and processing of significant amounts of data;

visualization of structural links between data presented in tables;

editing graphical representations of large amounts of information.

5. When moving or copying in a spreadsheet, absolute references:

do not change;

are transformed depending on the new position of the formula;

are converted depending on the rules specified in the formula.

6. The cell address of the spreadsheet is

1. any sequence of characters;
2. number of the byte of RAM allocated for the cell;
3. a name consisting of a column name and a line number;
4. address of the byte of RAM allocated for the cell;
5. the address of the machine word of the random access memory allocated for the cell.

7. What will be the value of cell A8 if you enter the formula = SUM (A1: A7) / 2 into it:

8. In general, the columns of a spreadsheet are:

are numbered;

9. For the user, the cell of the spreadsheet is identified by:

special code word;

10. Select the correct formula entry for the spreadsheet:

11. Before the designation of the number of the column or row in the absolute address of the cell, a sign is placed ...

1. $ 2. = 3. % 4. &

12. The active cell is the cell:

to record commands;

13. What formula will be obtained when copying to cell C3, the formula from cell C2:

3. = $ A $ 1 * $ A $ 2 + $ B $ 2?

14. The main element of ET is:

15. To select several intervals of cells, hold down the key:
1. Alt; 2. Ctrl; 3. Insert; 4. Arrows.

16. The autocomplete marker (black cross) will appear if the cursor is placed:

2. to the lower right corner of the cell;
3. on the gray rectangle at the intersection of the row and column headings;
4. in the middle of the cell.

17. The data contained in the cell can be edited:

1.in the menu;
2. in the formula bar;
3. in a cell;
4. in a special window.

18. In ET, you cannot delete:

19. What Formula will be obtained when copying formulas from E2 to E4?
1. = $ A $ 2 * $ C $ 4;
2. = A2 * $ C $ 2;
3. = $ A $ 2 * C4;
4. = A4 * C4.

View document content
"Test_ELECTRONIC TABLES_2. Grade 9 doc "

ELECTRONIC TABLES

1. A spreadsheet is:

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

application program for processing code tables;

a PC device that manages its resources in the process of processing data in tabular form;

a system program that manages PC resources when processing tables.

2. To select several intervals of cells, hold down the key:

1. Shift; 2. Ctrl; 3. Insert; 4. Arrows.

3. The autocomplete marker (black cross) will appear if the cursor is placed:

1.to the upper left corner of the cell;
2. on the gray rectangle at the intersection of the row and column headings;
3. in the middle of the cell.
4. to the lower right corner of the cell;

4. The spreadsheet is:

a set of numbered lines and columns named by letters of the Latin alphabet;

a set of rows and numbered columns named by letters of the Latin alphabet;

a collection of numbered rows and columns;

a collection of rows and columns, arbitrarily named by the user.

5. The rows of the spreadsheet:

are named by users in an arbitrary way;

denoted by the letters of the Russian alphabet;

denoted by letters of the Latin alphabet;

are numbered.

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

by sequentially specifying the name of the column and the row number at the intersection of which the cell is located;

the address of the machine word of the RAM allocated for the cell;

a user-definable name.

special code word;

7. Expression 5 (A2 + C3): 3 (2B2-3D3) in the spreadsheet looks like:

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

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

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

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

8. Among the above, find the formula for ET:

1. A3B8 + 12;
2. A1 = A3 * B8 + 12;
3. A3 * B8 + 12;
4. = A3 * B8 + 12.

9. The data contained in the cell can be edited:

1.in the menu; 2. in a cell; 3. in the formula bar; 4. in a special window.

10. When moving or copying in a spreadsheet, relative links:

are transformed regardless of the new provision of the formula;

converted depending on the length of the formula;

do not change;

are converted depending on the new position of the formula.

11. The active cell is the cell:

to record commands;

in which commands are entered.

12. What formula will be obtained when copying to cell C3, the formula from cell C2:

= $ A $ 1 * $ A $ 2 + $ B $ 2;

13. What will be the value in cell C1 if you enter the formula in it: = SUM (A1: B1) * 2?

14. What will be the value of cell A8 if you enter the formula = SUM (A1: A7) / 2 into it:

15.What character does a formula begin with in Excel?

1. it doesn't matter which one; 2. +; 3. Space; 4. =.

16. In ET, you cannot delete:

17. Before the designation of the number of the column or row in the absolute address of the cell, a sign is placed ...

1. & 2. = 3. % 4. $

18. What Formula will be obtained when copying formulas from E2 to E4?
1. = A2 * 5;
2. = $ A $ 2 * 4;
3. = A2 * $ C $ 4;
4. = $ A $ 2 * 5.

19. The main element of ET is.

Back forward

Attention! Slide previews are for informational purposes only and may not represent all the presentation options. If you are interested in this work please download the full version.

The purpose of the lesson: develop the skills of creating, editing, formatting and performing the simplest calculations in spreadsheets

Lesson Objectives:

• Educational:
• repetition during the lesson of the basic terms and concepts of the topic "Spreadsheet";
• developing skills in working with a spreadsheet;
• formulation of the concept of settlement operations in a spreadsheet, the purpose and possibilities of using formulas in ET.
• Developing:
• development of skills of individual practical work;
• development of the ability to reason logically, draw conclusions.
• Educational:
• development of cognitive interest, education of information culture.

DURING THE CLASSES

I. Organizational moment

• greeting students;
• mark absent;
• setting goals and objectives of the lesson (actualization and motivation).

II. Theoretical part

(In the course of presenting new material, the teacher uses the presentation, the students take notes). Spreadsheets are reviewed based on OpenOffice.org Calc.

Slide 1. Definitions

Electronic Sheets (ET) Is a program for mathematical, statistical and graphic processing of text and numerical data in rectangular tables. They allow you to automate the execution of the same type of calculations and recalculation with changing source data, as well as process numerical information in an array of databases, analyze finances, income, taxes, and so on.
Currently, a large number of spreadsheets have been developed: Microsoft Excel, Lotus 1-2-3, Corel, Spread32, Calc, Works, QuattroPro, Superplan other.
Among them, a commercial product is distinguished - MicrosoftExcel and open product – OpenOffice.org Calc .

Slide 2. Structure

The structure of a spreadsheet is discussed.

Slide 3. Columns, rows, cells

On the 1st click, the column is selected, on the 2nd - the row, on the 3rd, the cell is selected.

Slide 4. Range of cells

When you click, an image appears with a selected range of cells, students need to name the range, and then click on the correct answer.

Slide 5. Types and formats of data

The basic types and format of data, methods of setting and changing them, as well as an example of writing a formula are considered.

A definition is given and an example is considered first of a relative and then an absolute reference.

A definition is given and examples of mixed links are considered.

III. Exercise for the eyes.

Complex number 1.

1) Blink quickly, close your eyes and sit quietly, slowly counting to 5. Repeat 4-5 times.
2) Close your eyes tightly (count to 3), open your eyes and look into the distance (count to 5). Repeat 4-5 times.
3) Extend your right hand forward. Follow with your eyes, without turning your head, for slow movements of the index finger of an outstretched hand to the left and right, up and down. Repeat 4-5 times.
4) Look at the index finger of an outstretched hand at 1-4, then look into the distance at 1-6. Repeat 4-5 times.
5) At an average pace, do 3-4 circular movements with the eyes to the right side, the same amount to the left. Relaxing the eye muscles, look into the distance at the expense of 1.
6) Repeat 1-2 times.

IV. Practical part

Slide 8. Pinning

Using a hyperlink, open the simulator ( Annex 1 ). Made in Notebook software for the SmartBoard interactive whiteboard.
We consolidate the knowledge gained by means of a frontal survey, completing tasks.

1. Fill in the blank blocks by choosing the correct answer

Answer options: Window Control Buttons, Title Bar, Scroll Bars,
Menu bar, Function wizard, Cell address, Active cell, Input line, Sheet shortcuts, Status bar, Toolbars, Cell

2. Fill in the blank blocks by choosing the correct answer

Answer options:

C4: F4, B2: D2, A2: A11, C2: E2, C4: F11, B2: B6

3. What will be the value of cell B5 if you enter the formula = SUM (B1: B4) / 2 into it. (Move the answer to an empty block)

Answer options: 120, 220 , 110, 200

4. What formula will be obtained when you copy the formula from cell C2 to cell C3. (Move the answer to an empty block)

Answer options:

= $ A $ 1 * A2 + B2,
= $ A $ 1 * $ A $ 2 + $ B $ 2,
= $ A $ 2 * A3 + B3,
= $ A $ 1 + A3 * B3

5. What values ​​will appear in cells D2 and E3 if you copy cell C1 to the cell data? (Move the answer to an empty block)

Answer options:

0.2 and 0.5; 0.4 and 1; 2 and 5; 1.25 and 2.5

After we proceed to the test, the base with questions is attached ( Appendix 2 ). Implemented in the iTest program.

1. A spreadsheet is ...

• code table application applied
• program for processing table-structured data
• a PC device that manages its resources in the process of processing data in tabular form
• system program that manages PC resources when processing tables

2. The spreadsheet is intended for:

• processing predominantly numerical data structured using tables
• orderly storage and processing of significant amounts of data
• visualization of structural relationships between data presented in tables
• editing graphical representations of large amounts of information

3. The spreadsheet is ...

• a set of numbered lines and columns named by letters of the Latin alphabet
• collection of numbered lines
• a set of columns named by letters of the Latin alphabet
• a collection of rows and columns, arbitrarily named by the user

4. Rows of a spreadsheet

• denoted by letters of the Latin alphabet
• are numbered

5. In general, the columns of a spreadsheet

• are numbered
• randomly named by users
• denoted by letters of the Latin alphabet
• denoted by the letters of the Russian alphabet

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

• by sequentially specifying the column name and row number at the intersection of which the cell is located
• special code word
• the address of the machine word of the RAM allocated for the cell

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

• in the usual mathematical notation
• in a special way using built-in functions and according to the rules adopted for writing expressions in programming languages
• according to rules adopted exclusively for spreadsheets
• according to the rules adopted exclusively for databases

8. Expression 5 (A2 + C3): 3 (2B2-3D3) in 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))

9. Select the correct formula entry for the spreadsheet

• C3 + 4 * D4
• C3 = C1 + 2 * C2
• = A2 * A3-A4
• A5B5 + 23

10. What will be the value of cell A8 if you enter the formula = SUM (A1: A7) / 2 into it:

11. What is the address of the active cell?

12. Cell B4 of the spreadsheet contains the formula = $ C3 * 2. How does the formula look after cell B4 is copied to cell B6?

• = $ C5 * 4
• = $ C5 * 2
• = $ C3 * 4
• = $ C1 * 2

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

• = A1 * A2 + B2
• = $ A $ 1 * $ A $ 2 + $ B $ 2
• = $ A $ 1 * A3 + B3
• = $ A $ 2 * A3 + B3

14. What ranges of cells are highlighted in the image?

• B2: B12
• D2: G2
• D2: F10
• D5: F10

15. What values ​​will appear in cells D2 and E3 if you copy cell C1 to the cell data?

• 0.4 and 1.2
• 8 and 12
• 0.8 and 1.2
• 4 and 12

Vi. Homework

Slide 9. Homework

p. 1.5.2 p. 96-99
Practical work 1.14 p. 99

Vii. Lesson summary

Slide 10. Reflection

The guys in a circle express themselves in one sentence, choosing the beginning of the phrase from the reflective screen. Reflective screen

• I found out…
• it was interesting…
• it was difficult…
• I was doing tasks ...
• I realized that ...
• Now I can…
• I felt that ...
• I bought ...
• I learned…
• I managed …
• I was able to ...
• I will try…
• I was surprised ...
• classes gave me for life ...
• I wanted…

Grading a lesson.

Option 1

1. A spreadsheet is:

A) an application program designed to process data structured in the form of a table;

B) an application program for processing code tables;

C) a PC device that manages its resources in the process of processing data in tabular form;

D) a system program that manages PC resources when processing tables.

2. The spreadsheet is intended for:

A) processing predominantly numerical data structured using tables;

B) orderly storage and processing of significant amounts of data;

C) visualization of structural relationships between the data presented in the tables;

3. The spreadsheet is:

A) a set of numbered lines and columns named by letters of the Latin alphabet;

B) a set of rows and numbered columns named by letters of the Latin alphabet;

C) a set of numbered rows and columns;

D) a set of rows and columns, named by the user in an arbitrary way.

4. Rows of the spreadsheet:

A) are named by users in an arbitrary way;

B) are designated by the letters of the Russian alphabet;

B) are designated by letters of the Latin alphabet;

D) are numbered.

5. In general, the columns of a spreadsheet are:

A) are designated by letters of the Latin alphabet;

B) are numbered;

C) are designated by the letters of the Russian alphabet;

D) are named by users in an arbitrary way;

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

A) by sequentially specifying the name of the column and the line number at the intersection of which the cell is located;

B) the address of the machine word of the random access memory allocated for the cell;

B) a special code word;

D) a name arbitrarily assigned by the user.

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

A) in the usual mathematical notation;

B) in a special way using built-in functions and according to the rules adopted

C) for writing expressions in programming languages;

D) according to the rules adopted exclusively for spreadsheets;

E) according to the rules adopted exclusively for databases.

8. Expression 5 (A2 + C3): 3 (2B2-3D3) in the spreadsheet looks like:

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

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

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

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

9. Select the correct formula entry for the spreadsheet:

D) =A2* A3- A4

10. When moving or copying in a spreadsheet, absolute references:

A) do not change;

D) are transformed depending on the length of the formula;

D) are converted depending on the rules specified in the formula.

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

A) are transformed regardless of the new provision of the formula;

B) are transformed depending on the length of the formula;

C) do not change;

D) are transformed depending on the new position of the formula.

12. Range is:

A) a set of cells that form a rectangular region in the table;

B) all cells of one row;

C) all cells of one column;

13. The active cell is the cell:

A) to record commands;

D) in which the commands are entered.

14. What formula will be obtained when copying to cell C3, the formula from cell C2:
A) = A1 * A2 + B2;

B) = $ A $ 1 * $ A $ 2 + $ B $ 2;

V ) = $ A $ 1 * A3 + B3;

D) = $ A $ 2 * A3 + B3;

D) = $ B $ 2 * A3 + B4?

Option 2

5. The main element of ET is:

7.When moving or copying to ET, absolute references:

A) do not change;

B) are transformed regardless of the new provision of the formula;

C) are transformed depending on the new provision of the formula;

D) are transformed depending on the length of the formula.

8. Range is:

A) all cells of one row;

B) a set of cells that form a rectangular region in the table;

C) all cells of one column;

D) a set of valid values.

9. A spreadsheet is:

A) an application program for processing code tables;

B) a personal computer device that controls its resources;

C) an application program designed to process data structured in the form of a table;

D) a system program that manages resources personal computer when processing tables.

D3, formulas from cellD2:

A) = A2 * $ C $ 2;

B) = A 3*$ C $2;

The spreadsheet is:

a) a set of numbered lines and columns named using the letters of the Latin alphabet;

b) a set of rows and numbered columns named using the letters of the Latin alphabet;

c) a set of numbered rows and columns;

d) a set of rows and columns, named by the user in an arbitrary way;

e) a table typed in a text editor.

The spreadsheet is for:

a) orderly storage and processing of significant amounts of data;

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

c) editing graphical representations of large amounts of information;

d) processing of predominantly numerical data, structured using tables, carried out in the process of economic, accounting, engineering calculations;

e) broadcasting files over a computer network.

The fundamental difference between a spreadsheet and a regular spreadsheet is the ability to:

a) automatic recalculation of the values ​​determined by the formulas when the initial data is changed;

b) data processing in the table;

c) visual representation of relationships between data;

d) simultaneous data processing of various types;

e) copying the table.

In the spreadsheet, in cell A1, the number 10 is written, in B1 - the formula = A1 / 2, in C1 - the formula = SUM (A1: B1) * 2. What is the value of C1:

a) 100; b) 150; at 10; d) 30; e) 75.

Option 3

1.Specify the correct cell address:

3. The result of calculations in cell C1 will be:

5.In ET, the cell name is formed:

6.Specify the wrong formula:

7.When moving or copying in ET, relative links:

A) do not change;

B) are transformed regardless of the new provision of the formula;

C) are transformed depending on the new provision of the formula;

D) are transformed depending on the length of the formula.

8. The active cell is the cell:

A) to record commands;

D) in which data entry is performed.

9. The spreadsheet is intended for:

A) processing predominantly numerical data structured using tables;

B) orderly storage and processing of significant amounts of data;

C) visualization of structural relationships between the data presented in the tables;

D) editing graphical representations of large amounts of information.

10. What formula will be obtained when copied into a cellD3, formulas from cellD2:

A ) = A2 * C2;

B) = $ A $2* C 3;

Calculation formulas in the cells of the spreadsheet are written:

a) in the usual mathematical notation;

b) according to the rules adopted in logical programming languages;

c) in a special way using built-in functions and according to the rules adopted for writing expressions in imperative programming languages ;

d) according to the rules adopted exclusively for databases;

e) in an arbitrary way.

In the spreadsheet, in cell A1, the number 5 is written, in B1 - the formula = A1 * 2, in C1 - the formula = A1 + B1. What is the value of C1:

a) 10; b) 15 ; in 20; d) 25; e) 45.

Find the formula for your spreadsheet among the formulas below:

a ) = A3 * B8 + 12;

b) A1 = A3 * B8 + 12;

e) A1 = A3B8 + 12.

A spreadsheet cell is identified by:

a) the address of the machine word of the random access memory allocated for the cell;

b) a special code word;

c) by sequentially specifying the name of the column and the line number at the intersection of which the cell is located;

d) a name arbitrarily assigned by the user;

e) by sequentially specifying the row number and column name at the intersection of which the cell is located.

Test on the topic "Graphs and charts in a spreadsheet environment"

Business graphics are:

a) the schedule of the meeting;

b) graphic illustrations;

c) a set of graphs of functions;

d) a set of software tools that allow you to graphically represent the patterns of changes in numerical data.

The diagram is:

a) a form of graphical representation of numerical values, which makes it easier to interpret numerical data;

b) schedule;

c) nicely designed table;

By informatics developed ...