Program for working with Excel spreadsheets opens up huge opportunities for the processing of digital information.But neither one table will not be able to imagine the process as clearly as it will make schedule function , which he described.In Excel, there is such an opportunity in the menu Insert - Diagram (Microsoft Office 2003).
- software Microsoft Excel 2003
Open a blank sheet of the book Microsoft Excel 2003. Think about what steps you need to calculate the terms postorennie schedule and function table.The more complex the schedule function , the less you need to take a step for more precise construction.In the first column of the table, the designated values of the argument function , fill in the first two values from the smallest range of interest.Then highlight their unit using the "mouse".
Move the cursor "mouse" to the bottom right corner of the selected range, it changes to a black cross.Press the left button and swipe down, stopping th
e cursor at the end of the range of interest.So to get a column function arguments .For example, if you want to receive graph function range (-10; 10) in increments of 0.5, the first two values was -9.5 and -10, a cursor needs to stop after the number displayed in the column10.
To build a column of values in a cell adjacent to the lowest value of the argument to position the cursor and press the "=".Then, type the formula function , instead of an argument (value "x"), constantly clicking "mouse" on the neighboring cell.After the formula is typed, press Enter.The cell shows the value function for the argument of the first column.Place the cursor on the value function .When the cursor of the "mouse" to the bottom right corner of the cell and saw a black cross, drag it to the end of the range, pressing the left mouse button.The column values will appear function , the corresponding argument in the first column.
the menu, select "Insert" - "Chart".In the window that opens, select "Spot".In the right pane, select the chart type "Scatter with values connected smoothed lines without markers."Click "Next".In the window that opens, set a paragraph on "Series in: Columns."Click the check box, which is the right line "Range" and pressing the left button of "mouse" to highlight the full range of arguments and values.Click on the tab of the same window "number" in line "value X" "mouse" specify the range of arguments.Double-click Knop "Next", then "Done."The resulting schedule will vary depending on changes in the formula.In other versions of the algorithm is similar and differ only in details.
- how to build a graph of functions in excel