Presentation on computer science on the topic of excel. Presentation on the topic "MS Excel"

slide 1

slide 2

slide 3

slide 4

slide 5

slide 6

Slide 7

Slide 8

Slide 9

slide 10

slide 11

slide 12

slide 15

slide 16

slide 1

slide 2

slide 3

slide 4

slide 5

slide 6

Slide 7

Slide 8

Slide 9

slide 10

slide 11

slide 12

slide 13

slide 14

slide 15

slide 16

slide 17

slide 18

slide 19

slide 20

slide 21

slide 22

slide 23

slide 24

slide 25

slide 26

slide 27

slide 28

slide 29

slide 30

slide 31

slide 32

slide 33

slide 34

slide 35

slide 36

Slide 37

slide 38

Slide 39

slide 40

• Size: 8.6 MB
• Number of slides: 20

Presentation description Presentation Practice 5 Microsoft Excel 2010 by slides

Acquaintance with Microsoft Excel 2010 State Enterprise "Kostanay State University them. A. Baitursynova Department of II. M Discipline: Informatics Zhambaeva A.K., teacher

Getting Acquainted with Excel First, let's look at what a table is: A table is a method of presenting textual or numeric information in the form of separate rows and columns containing the same type of information in one row or column. The main task is automatic calculations with data in tables. In addition: storing data in tabular form presenting data in the form of charts analyzing data making forecasts finding optimal solutions preparing and printing reports Examples: Microsoft Excel - files *. xls, *. xlsx open. Office Calc - *. ods - free

Introduction to Excel To rename a sheet, double-click its name or select Rename from the context menu. To create a new sheet, click on the tab highlighted in the figure or select Insert from the context menu, you can also set the color of the tab in the context menu.

Entering data Entering data into a cell: First, select the cell in which you want to insert text or a number by clicking the mouse cursor or moving the active selection with the arrow keys, then enter the text or number, to save the change, press the Enter or Tab button. Pressing Enter will move the selection one line down, and pressing Tab will move it to the right. If you use the Tab key to enter data in multiple cells in a row and then press Enter at the end of that row, the cursor will move to the beginning of the next row. To change the already typed text, select the desired cell and double-click on it with LMB or after selecting the cell, press the F 2 key on the keyboard, you can also enter and edit the content in the formula bar above the table.

Data entry A cell may display ##### characters if it contains information that does not fit in the cell. To see them in full, you need to increase the width of the column. Changing the column width: Option 1 1. Select the cell for which you want to change the column width. 2. On the Home tab, in the Cells group, select Format. 3. On the Cell Size menu, do one of the following: a) To make all the text fit in the cell, select AutoFit Column Width. b) To increase the width of a column, select the Column Width command and enter the desired value in the Column Width field. Option 2 1. Move the mouse cursor over the column border in the header and do one of the following: A) Move the border to the right place, and a text hint with the column size will appear. B) Double-click with the left mouse button and the column will take the most appropriate size for the content. Option 3 From the context menu for a column, select Column Width and set the size.

Data Entry By default, text that does not fit in a cell occupies adjacent cells to the right of it. Using wrapping, you can display multiple lines of text within a cell. To do this: 1. Select the cell in which you want to wrap the text. 2. On the Home tab, in the Alignment group, select the Word Wrap command. If the text consists of one word, it is not wrapped. To make the text fit completely in this case, you can increase the width of the column or reduce the font size. If not all of the text is visible after wrapping, you may need to change the line height. On the tab start page in the Cells group, choose Format, then in the Cell Size group, click AutoFit Height. Row sizes, as well as columns, can be changed with the mouse cursor and by calling the context menu, select the line height item. To start entering data from newline in a cell without automatic hyphenation, set a line break by pressing ALT+ENTER.

Fill marker Often, when editing tables, you need to copy, cut, delete text or other information, for this you can use the same tricks as in Word, but in Excel there is also a fill marker, this is a square located in the corner of the active cell is used for automatic filling cells and makes it easier to work with the program, further along the course you will understand everything, and now we will consider its main features: With one cell selected, holding it and increasing the frame, we will copy the value of this cell to others. With two cells selected, the program will look at their contents, if there is a number, then the program will continue the arithmetic progression of the difference of these numbers, and if the text is, but a certain text, for example, Monday / Tuesday or January / February, then the program will independently add Wednesday, Thursday to the first two etc. and by the second March, April, etc. Thus, you can easily make a multiplication table by filling in only four cells as shown in the figure on the right and drag the marker horizontally, then vertically.

Data formats The program automatically determines what is entered in the cell. Excel uses 13 data formats, but defines three main types: Number - if entered digital information containing no letters except for banknotes, the sign of the negative number, percent and degree. Formula - an instruction in the form of a linear notation, in which, in addition to numbers, addresses of cells (even from other sheets) can be used, as well as special words-commands that work as functions, the only thing that fundamentally specifies that this is a formula equal sign at the very beginning of the line, final The format can be either a number or text. Text is something that is not included in the first two definitions and is a set of letters and numbers. The text also includes the date and an additional format with fill masks, - telephone number, zip code, etc.

Data formats Numeric - any numbers within 16 digits, the rest are rounded off. Monetary - serves for calculations with monetary amounts and their presentation, when choosing a currency, its abbreviated name will automatically appear after the numbers and there is no need to type on the keyboard, for example, 120 rubles. or 10$. Financial - is used to calculate the ratios of various amounts of money and does not have negative values. Percentage - used to calculate fractional values ​​and automatically sets the percent sign, for example, 0, 4 is 40%, and ½ is 50%. Fractional - the number is represented as a fraction with a given divisor. Exponential - used to indicate very large values, for example 160000000000 is 16 * 10 20 Date - indicates a date in various formats, including days of the week. For example: 06/10/2003 or May 17, 1999. Time - designation of time in various types. For example: 21:45:32 or 9:45 PM. Text is just text. Additional - text that has a specific writing pattern. For example, passport number or phone number, postal code, etc.

Data formats To set the data format in a cell, you can do the following: On the main tab, on the "Number" panel, select from the drop-down list desired format, or click on one of the buttons of this panel according to the required format. Select the Format Cell command in the context menu and set the format manually by selecting from the list on the left. additional options, such as the number of decimal places, date and time formats, and so on.

Formulas Formula - calculations containing numbers, mathematical symbols, functions, cell names from which a number is taken for calculations. All formulas entered into the table must begin with an equal sign. Cell name Each cell has its own name, for example U 32 , here U is the column of the cell, 32 is the row number, the name of the active cell is written above the table to the left of the formula bar, and in MSOffice Excel 2010 a cell can be assigned a different name, which can then be used in formulas , you just need to enter a new name in this field. There is a restriction on new names - it must consist only of capital Latin letters. Functions To facilitate calculations, Excel has built-in functions, such as calculating the root, summing the numbers of the required block of cells, etc., to add them special button highlighted in the figure.

Formulas Be sure to insert an equal sign before entering a formula! To make it easier to enter formulas into the table, you need to know the following tricks: To enter the address of the required cell, you can simply click on it with LMB. To insert functions, you can also use the function button located on the "Main tab" in the "Editing" panel or select the desired one in the "Functions" tab. You can use the fill handle or copy to copy functions multiple times. When copying the addresses of the cells in the formula, they will change according to the cell into which the formula is copied. To set an unchanging cell address when copying in any way, you need to put a $ sign in front of it, for example $H $ 45 - the address is unchanged both in columns and in rows.

Formulas List of basic functions: SUM (A 1: A 10; B 2) - summing column A and cell B 2. ROUND (Number; Digit) - Rounding a number to the specified number of numbers behind a comma, similar to the ROUND UP and ROUND DOWN functions. MAX(A 1; B 1: B 10) - returns the maximum value from the list. IF(Expression; Value) - returns "Value" if "Expression" is true. AVERAGE(A 1; B 1) - returns the arithmetic mean. SELECT(Index; Zn 1; Zn 2; ...) - returns the value by the number "Index" DEGREES (Rad), RADIANS (Grad) - inverse functions for converting radians to degrees and vice versa. Full list functions can be seen by clicking on the "Insert function" button and in the drop-down list select the item "Full alphabetical list".

Sorting data Spreadsheets provide the ability to sort data in ascending or descending order, as well as sorting by multiple columns at the same time. To sort one column in ascending or descending order, just select it and select one of the commands on the Data tab: AR means "ascending" RA means "descending" To sort by several columns, click the Sort button, after which you need to add the required number of columns ( levels) and set the sort order:

Data sorting Just like sorting, it is sometimes necessary that only those cells that are needed at that moment are visible; for this, filters are applied that can hide not desired values. To add a filter, select the required column (or row with headers) and click the Filter button on the Data tab. With the help of a filter, you can separate numbers greater than or less than a given number, sort data, hide or show certain data.

Displaying data on a sheet For the convenience of working with a table, sometimes it is necessary that the title or data labels remain visible on the screen, for this you need to select the row (column) below (to the right) of the title (captions) and on the "View" tab click the button "Freeze areas". To view several parts of one sheet, you can use separators (lines hidden near the scroll bars) - they can divide the document into four parts, each of which displays a part of the same sheet.

Charts and graphs serve to present numerical information in a graphical form. Charts are used to compare data of the same type, and graphs are used to compare data over time or at the end of a month or year. To create a chart or graph, you must first create a table with the data that you want to display graphically, then select the chart you like the most in the insert tab.

Charts All internal elements charts can be reconfigured, including chart type. Here is a list of changeable elements: vertical and horizontal axes, grid lines, background, shape volume, title, legend. Each of the elements has its own parameters for customization, such as the font, background color, dimension, position, and so on. By setting these parameters, you can make a very beautiful business chart. The settings of all elements are called up through the context menu only after they are selected.

Page layout In Excel, unlike Word, sheet borders are not initially displayed, so you can easily get out of the sheet. To see the borders of the sheets, on the "View" tab, click the "Page Layout" button. To adjust page orientation, page scale and size, paper margins, and page printing order, use the commands on the Page Layout tab. After applying the page settings in the table, the cells separated by different sheets will be separated by a dotted line. To print only a certain part of the sheet - select the required area and on the "Page Layout" tab, click "Print Area" - "Set"

Conditional formatting (menu on the main tab) - replacement / addition of numeric values graphic objects. Conditional formatting options: 1. Histogram (a chart appears on the background of numbers) 2. Color schemes(values ​​are highlighted in color) 3. Icons (numbers are replaced by a set of icons)

Spreadsheet- this is the computer equivalent of a regular table, consisting of rows and columns, at the intersection of which there are cells containing numerical information, formulas, text.

MICROSOFT EXCEL PROGRAM allows:

• form data in the form of tables;
• calculate the contents of cells using formulas, while using more than 150 built-in functions;
• present data from tables in graphical form;
• organize data into structures similar in capabilities to a database.

STARTING THE PROGRAM

To start the program, you can use the main menu command

Windows Start - All Programs - Microsoft Office - Microsoft Excel

or desktop shortcut

and quick access.

Screen view

NORMAL - the most convenient for most operations.

PAGE LAYOUT - useful for final formatting a table before printing.

PAGE - shows only available pages

To switch between modes, use the corresponding menu items. View or by pressing the corresponding buttons

The main thing– contains functions for formatting and editing table data and the table itself (font, cell format, adding rows ...)

Insert- contains functions for inserting various objects into the book (text, illustration, diagram ...)

Page layout- contains functions for setting page parameters

Formulas- adds formulas to the table and assigns names to cells.

Data– working with data (inserting, sorting, filtering…)

Peer review- contains functions for spell checking, inserting notes and protecting the book

View– setting functions appearance window books

DATA ORGANIZATION IN THE PROGRAM

The program file is a so-called Workbook ,

or working folder.

Each workbook can contain

over 256 Worksheets .

The default version of Excel contains

3 worksheets.

Sheets can contain both interconnected,

and completely independent information.

The worksheet is

table blank.

Column - all cells located in one vertical row of the table. The column headings are given in Latin letters, first from A to Z, then from AA to AZ, from BA to BZ, and so on.

Row - all cells located at the same horizontal level. Row headers are represented as integers ranging from 1 to 65536.

A cell is an elementary spreadsheet object located at the intersection of a column and a row. The address of a cell is determined by its location in the table, and is formed from the column and row headings at the intersection of which it is located. The column header is written first, followed by the row number. For example: A3, D6, A9, etc. A cell is called active when information (text, number, formula) is entered into it.

A range of cells is a group of adjacent cells that can consist of a single cell, a row (or part of it), a column (or part of it), as well as a collection of cells covering a rectangular area of ​​the table. A range of cells is specified by specifying the addresses of the first and last of its cells, separated by a colon. For example: the address of the range formed by part of line 3 is E3:G3; the address of a range that looks like a rectangle with the starting cell F5 and the ending cell G8 - F5:G8.

DATA INPUT

To enter data into a cell, make it active and enter:

number (it is automatically aligned to the right);

text (it is automatically aligned to the left);

formula (in this case, the cell will contain the result of the calculation, and the expression will be displayed in the formula bar, starts with the = sign).

After entering text or a number with the cursor keys, you can go to the next cell, when entering a formula, pressing the key will receive the result of the calculation.

To correct information in an already filled cell, make it current, then press the key or double-click on the cell.

To exit the correction mode, press the key.

MOVEMENTS -

Between cells:

Cursor buttons

• cursor (mouse)
• Enter key

Between sheets:

• click on sheet tab
• horizontal scroll buttons

SELECTING TABLE FRAGMENTS

To perform an action on a group of cells,

they must first be identified.

Wherein background all cells except the first one will be painted over in black color. But the unfilled cell will also be selected.

To highlight ONE LINE, put the mouse pointer on the line number on the coordinate column .

To highlight multiple lines move along the coordinate column, without releasing the left key .

To highlight ONE COLUMN, put the mouse pointer on the letter on the coordinate line.

To highlight multiple columns move along the coordinate line, without releasing the left key .

To select multiple cells, move around the table while holding down the left key.

The selection is removed by clicking anywhere on the screen.

Working with data

Test input:

Cell selection and input

or selecting a cell, positioning the cursor in the formula bar, and typing

cancel input accept input call function wizard

Pinning areas

To fix the upper horizontal area - specify the line above which you want to fix the area.

To freeze the left vertical area - specify the column to the left of which you want to freeze the area.

To pin both areas, select the cell located to the right and below the place where you want to split the sheet.

FONT CHANGE AND ALIGNMENT

Menu MAIN or tab FONT

Don't forget to select the required cells before making changes.

DIVIDING LINES

SETTING THE CELL BACKGROUND COLOR AND FONT

Changes active cell or dedicated area

INSERTING CELLS, ROWS AND COLUMNS

MENU MAIN

Inserting or deleting the selected number of cells, rows, or columns

Worksheet management:

Actions

Execution sequence

Rename Sheet

Double click, enter a name, Enter

Add sheet

Delete Sheet

Insert  Sheet

Delete  Sheet

Move Sheet

Drag with the mouse to the location indicated by the triangle

copy sheet

Drag while pressed ctrl

Change the label color

Format  Arrange Sheet  Label color

CONTEXT MENU Functions

FORMATTING ROWS AND COLUMNS

menu

team

The main thing

Format - Cell - Cell size (width, fit width, hide, show)

The main thing

Alignment - Merge and Center (Width, Fit Width, Hide, Show)

CONTEXT MENU Functions

TRANSPORTATION

Rotate table 90 degrees

Home - Copy - Transport ( Special insert-transportation)

Changing column widths and row heights

WIDTH: cursor in title bar at border of adjacent columns - double-sided arrow - drag

HEIGHT: mouse cursor on the border of adjacent lines - double-sided arrow - drag

(the selected area also changes)

PAGE SETTINGS

MENU: Page Layout

fields

Orientation

The size

Print area

SAVING THE WORKBOOK

In the window that appears, open the folder in which the file will be saved, in

enter file name

(the extension is defined by default as *.xls).

SORTING

Arranging text and data alphabetically:

HIGHLIGHTS - EDITING

PAGE BREAKING

Setting the end of the page:

highlight the intended top left cell of the new page

PAGE SETTINGS - BREAKS

DATA FORMATS

MAIN - Cell - Format - Cell Format

Bit depth change:

Main - Number

copying

Copying the contents of a cell to another cell.

Copies the contents of a cell to a range of cells. However, the contents of the original

cells is copied to each cell of the corresponding range.

Copy the contents of a range to another range. However, both ranges

must have the same dimensions.

When copying a cell, the contents of the cell, formatting attributes and notes (if any) are copied, the formulas are modified.

Removing content

Select a cell or range;

a) Grab the fill handle, drag up or to the left, and release the button

b) press;

c) Editing - Clear.

COPY METHODS

1 . Using the clipboard

Select.

Button on the Toolbar,

Context menu.

Place the table cursor in the upper left corner of the destination range and execute

Paste operation (Button, Context menu)

When pasting from the clipboard, all values ​​in the cells of the destination range are erased without any warning

(if necessary, apply cancellation)

COPY METHODS

2. drag and drop D&D

Select.

Move the mouse pointer to the selection frame, when it turns into an arrow, click (a + sign is added to the pointer), drag to a new location.

If the mouse pointer does not take the form of an arrow when dragging, then Tools - Options - Edit tab - check Drag cells.

MOVING

Moving a range is performed in the same way as copying (without dragging and the Cut command for the clipboard).

It is very convenient to use special drag and drop (with the right mouse button pressed). This gives additional features which can be selected from the menu.

AUTOSUM button

Menu Command

Created formula

Summarize

Purpose

SUM(address_range)

Mean

AVERAGE(address_range)

Sum of all numbers in the range

Number

Maximum

Average

COUNT(address_range)

MAX(address_range)

Amount of numbers

Minimum

Largest number in range

MIN(address_range)

Smallest number in range

Task 1: Create a table according to the sample, calculate using autosum and autocomplete.

Save with a name TRAVEL

Task 2:

• Create a document in MS Excel , name - Task 2
• Make a row of 10 numbers.
• Count:

• Amount The average Number Maximum Minimum
• Amount The average Number Maximum Minimum
• Amount The average Number Maximum Minimum
• Amount The average Number Maximum Minimum
• Amount
• The average
• Number
• Maximum
• Minimum

• Write the solution in the form:
• Save your changes to the document.

You should get these answers.

GOING FORWARD The presentation was made by a teacher of mathematics and computer science at MBOU Secondary School No. 10, Yelabuga RT. Sautina Anna Leonidovna 2010

slide 2

2 GOING FORWARD INTRODUCTION 3 WHAT IS A DIAGRAM? 5 Types Charts: Histograms and schedules 6 Types of charts: graphics and circular 7 types of charts: Spot and with areas 8 Types of charts: Ring and petals 9 Types of charts: Surfaces and bubbles 10 Types of diagrams: stock, cylindrical, non-standard types and custom diagrams 11 Recommendations for constructing diagrams, graphs of functions and surfaces 12 operations that can be produced with diagrams I 13 operations that can be produced with charts II 14 Task number 1: Build a chart 15 Task number 2: Build a chart of function 16 to build a function schedule specified EQUATION IN POLAR COORDINATES 17 TASK №3: CONSTRUCTION OF A SURFACE 18 TASK №4: CONSTRUCTION OF A HYPERBOLIC PARABOLOID 19 GLOSSARY OF TERMS 20 ASSIGNMENTS FOR INDEPENDENT WORK 21 3 5 6 7 8 9 10 11 12 13 18 15

slide 3

3 GOING FORWARD Microsoft Excel is the world's leading spreadsheet program. The first version of MS Excel appeared in 1985 and provided only simple arithmetic operations in a row or column. In 1993, the fifth version of Excel was released, becoming the first Microsoft Office application. Starting with Office 97, Microsoft has included VBA in all applications in the Microsoft Office suite. At present Microsoft time Excel is a fairly powerful development tool information systems, which includes both spreadsheets (with financial and statistical analysis tools, a set of standard mathematical functions available in computer languages high level, a number of additional functions found only in libraries of expensive engineering routines) and visual programming tools. Spreadsheets allow you to manipulate numbers and text, set up formulas and functions to run automatically, predict budgets based on a scenario, present data as charts, and publish worksheets and charts on the web. BACK MENU

slide 4

4 GETTING FORWARD In this book, various examples demonstrate the wide possibilities of Microsoft Excel for solving mathematical problems. The presentation is primarily focused on Microsoft Excel XP, however, you can use the material of the book, starting with Microsoft versions Excel 97, almost unchanged. The material of the book may be useful: as study guide for students of mathematical and economic specialties studying Microsoft Excel in various courses of computer science, information technology and data processing systems; teachers in preparing lectures and conducting practical and laboratory work; users - to expand professional opportunities when using the spreadsheet Microsoft Excel. BACK MENU

slide 5

5 The diagram is graphic representation worksheet data. Data presented in a chart is clearer and therefore easier to compare. To build charts, you must first prepare the range of required data, and then use the Insert-Chart command or the corresponding button of the Chart Wizard on the Standard toolbar. In EXCEL, you can build two types of charts: embedded charts and charts on separate sheets. Embedded charts are created on the worksheet next to tables, data, and text and are used when creating reports. Diagrams on a separate sheet are convenient for preparing slides or for printing. EXCEL offers different types charts and provides a wide range of options for changing them (chart type, labels, legends, etc.) and for formatting all chart objects. The latter is achieved by using the appropriate commands on the Diagrams toolbar or by using context menu corresponding chart object (just click right click click on the desired object and select the Format command from the context menu). EXIT FORWARD BACK MENU

slide 6

6 HISTOGRAM FORWARD Used to compare individual values ​​or their changes over a period of time. Convenient for displaying discrete data. LINEAR Similar to histograms (the difference is rotated 90º clockwise). Used to compare individual values ​​at a particular point in time, do not give an idea of ​​how objects change over time. The horizontal arrangement of the stripes makes it possible to emphasize positive or negative deviations from a certain value. Bar charts can be used to show variances for different budget lines at a given point in time. You can drag points to any position. BACK MENU

Slide 7

7 GO FORWARD GRAPHS Shows the dependence of data (Y-axis) on a value that changes in constant increments (X-axis). Category axis labels must be in ascending or descending order. Graphs are more commonly used for commercial or financial data evenly distributed over time (displaying continuous data), or categories such as sales, prices, etc. . These charts can be used when the components add up to 100%. BACK MENU

Slide 8

8 GOING FORWARD POINT Well demonstrate data trends at unequal time intervals or other measurement intervals plotted along the category axis. Can be used to represent discrete measurements along the x and y axes. Scatter plot divisions on the category axes are plotted evenly between the lowest and highest x value. This type is used to display the process of production or sale of products (with equally spaced intervals). BACK MENU

Slide 9

9 EXIT FORWARD RINGS Compare the contribution of parts to the whole. Compare the contributions of the parts to the whole. Unlike a pie chart, a donut chart can show two or more data series. PETAL They are usually used to show the ratios of individual data series, as well as one specific data series and all other series. Each category of the radar chart has its own coordinate axis (beam). The data points are located along the beam. The lines connecting the data points of one series cover the area characterizing the set of values ​​in this series. On a radar chart, you can display, for example, the dynamics of time spent on a project that includes several tasks. In this case, each category (ray) corresponds to a certain task of the project, and a point on the ray corresponds to the time spent on it by a certain date. BACK MENU

Slide 10

10 EXIT FORWARD SURFACE Shows the low and high points of the surface. These charts are used for a dataset that depends on two variables. The diagram can be rotated and viewed from different points of view. BUBBLE Allows you to display sets of three values ​​on the plane. The first two values ​​are plotted on the x and y axes. The third value is represented by the size of the bubble. BACK MENU

slide 11

11 GO FORWARD EXCHANGE It is used to display changes in information about prices on the exchange. Displays datasets of three values. CYLINDRICAL These are three-dimensional variants of histograms and bar charts. NON-STANDARD CHART TYPES The non-standard types are based on the standard ones, but have some improvements in formatting and display. CUSTOM CHART FORMATS Added to the list of additional chart types. Custom formats are created on the basis of basic formats using various formatting tools. BACK MENU

slide 12

12 GOING FORWARD The work of charting involves the use of the following methodology: 1. Prepare a range of change and a range of values ​​for the chart. 2. Select the prepared range and use the diagramming wizard (called by the Insert-Chart command or by the button of the diagramming wizard on the Standard toolbar). 3. Format the resulting chart. Knowing the equation of the line in polar coordinates, it is easy to build a graph in the Cartesian coordinate system. To do this, you should: 1. Prepare the range of change of the φ coordinate. 2. Calculate the value of the function on this range in polar coordinates ρ=ρ(φ). 3. Calculate the values ​​of x and y in the Cartesian system using the formulas: x=ρCOSφ, y=ρSINφ 4. Select the range of the domain of definition and the scope of the function, i.e. all x and y values ​​on the worksheet, and use the diagramming wizard. To build graphs, it is better to use the Graph and Scatter chart types. 5. Format the resulting graph. Surface construction involves the use of the following technique: 1. Prepare the range of function changes in two coordinates by placing the changes in one coordinate down along a certain column, and the other along the adjacent row to the right. 2. At the intersection of coordinates, enter the necessary formula for constructing the surface and use the autofill marker to copy it to the entire surface construction area. 3. Select the prepared data and use the diagramming wizard (diagram type - Surface). 4. Format the resulting surface. BACK MENU

slide 13

13 EXIT Operations that can be performed with FORWARD charts With charts, you can perform the following operations: 1. Add and remove data series - using the chart wizard or from the context menu of the chart with the Source data command. It is also possible to use the key, drag and drop data onto the constructed chart, etc. 2. Change (edit) the data in the chart and on the worksheet - using the Parameter Selection tool (if the data on which the chart is built is expressed through a formula). 3. Rearrange the data series on the chart - this applies mainly to histogram type charts. 4. Insert text anywhere in the diagram - select the diagram (i.e. click on it with the mouse), and then enter the necessary text in the formula bar, which can be dragged throughout the diagram and formatted as a label. 5. Edit, format and add various chart elements - using the context menu for the desired chart object. 6. Change the spatial orientation of three-dimensional diagrams - select the diagram and use the menu command Diagram Volumetric view, you can also click on the end of any coordinate axis - black crosses will appear, and then, holding the mouse on any of them, change the location of the three-dimensional diagram in space. BACK MENU

Slide 14

14 GO FORWARD 7. Add various graphic objects (for example, arrows, callouts, etc.) - using the buttons on the Drawing toolbar or using the Insert-Picture menu commands. 8. Adjust the axes and select the scale - using the context menu for this axis. 9. Build composite charts (different types of charts in the same coordinate system) - using non-standard chart types. 10. Change chart types - by selecting the Chart Type command from its context menu. 11. Create drawn diagrams (instead of color filling - drawings). In this case, you need to select some data series and use the Format Data Series command from the context menu for it. 12. Associate the text on the diagram with the cells of the worksheet. 13. Create charts based on structured data. 14. Apply charts for data analysis, i.e. build various trend lines and make predictions. BACK MENU

slide 15

15 EXIT To complete the task: GO Enter the data on the worksheet in accordance with fig. Select the range A5:B12 with the mouse and execute the command Insert | Chart, or click the Chart Wizard button on the Standard toolbar. Further, work with the chart wizard is carried out in a step-by-step mode: Selecting a chart type - taking into account the fact that discrete statistical data are proposed in the example, a suitable chart type is a histogram type. By clicking the Next button, go to step 2. On the Series tab, specify which series is selected as the data value (fill in the Series and Values ​​fields). In our case, in the Row field, enter the Volume and in the Values ​​field, the range $v$5-$v$12; which series will serve as signatures along the X axis - in the Signatures along the X axis field, enter the year and indicate the range $A$5:$A$12. Going to the next step of the diagram wizard (using the Next button), we will set the necessary diagram parameters. At the last stage, we will select the location of the future diagram. 4. Format the resulting diagram using the context menu of each of its elements. BACK MENU

19 EXIT FORWARD BACK MENU

Slide 20

20            EXIT absolute reference - specifying the cell address in the absolute coordinate system regardless of the address of the active cell. It looks like: $A$5, $E$24. autocomplete - automatic filling of cells. cell address - determined by the name (name) of the column and the name (row number), at the intersection of which the cell is formed. influencing cell - on which the value of this cell depends. In particular, if a given cell contains a formula with reference to some, then the latter is considered to directly affect the former. tooltip - a small "window" describing the purpose of the object. If the pointer is set "on top" of the object, a tooltip will appear next to it in about a second. dependent cell - on which the value of this cell depends (in particular, a cell containing a link to this cell. protected cell - unavailable for editing after the sheet is protected. icon - a picture (icon), by double-clicking which you can open a document, folder or run a program. context menu - invoked by clicking the right mouse button, the set of commands of the context menu depends on where the screen was clicked legend - a message on the chart containing the labels and names of the data series sheet - a spreadsheet consisting of 65,536 rows and 256 columns and is used for ordering and analyzing data. an indication of the address of a cell, calculated in a relative coordinate system with the origin in the current cell.It looks like: A5, E24, etc. clearing the code Live cell - deleting data from the cell, while the cell itself remains on the sheet. name field - part of the formula bar containing the names of cells, chart elements or graphic objects. drop-down menu - a list of commands that appears on the screen when a menu is selected (highlighted) operating system and/or applications. editing - changing the content of a document. data series - a group of related elements on a chart, the source of which is a single row or a single column on a worksheet. adjacent cells - adjacent cells of the range. formula - a combination of constant values, signs of arithmetic operations, cell addresses, names, functions. A formula is entered into a cell and defines the rules for calculating the cell. A function is a predefined formula that performs operations on given values ​​and calculates new values. a cell is a part of a sheet formed by the intersection of a column and a row. The selected cell is called the active cell. BACK MENU

slide 21

21 EXIT FORWARD BACK MENU

slide 22

EXIT REFERENCES Help: Microsoft Excel