Functions of Excel: how to build

Today we will look at how to build a schedule for the function, Excel will help us in this. Also, let's have a short overview of some other useful features of the spreadsheet editor.

Application

So, let's move to the solution of the question, how to build a function in Excel. This spreadsheet editor is an excellent tool for working in the office and at home. Excel is perfect for calculating your spending or making serious financial conclusions about the work of a large company. The spreadsheet editor has many possibilities, but today it will be one of the most popular.

Drawing a graph

We can construct a graph of a function in the "Excel" of the usual type or refer to the most complicated mathematical operations. To do this, perform several steps. Open a blank Excel sheet or start a new project. Create two columns. Further in the first we write down the argument. Directly the functions in "Excel" are added to the second column. Proceed to the next stage. In the first column, we specify the X values required for the calculation, as well as the plotting of the graph. Define the segment within which the function will be created.

Calculation

Go to the next column. In it it is necessary to write down the formula of the function "Excel". The schedule will be built on its basis. All formulas of the table editor begin with the sign "=". The features of the application greatly simplify the process of creating a graph. For example, you do not need to enter the selected formula in all rows. Excel developers took into account that it would not be very convenient. So, just stretch the formula, and it will be built in each of the cells. Just click on the corresponding area.

Details on stretching

We continue the process of constructing the function in "Excel". After completing the above steps, a small square appears in the lower right corner of the cell. We point the cursor at it so that its pointer changes. Now hold down the right mouse button and stretch the formula to the required number of cells. As a result, such actions will help create a schedule for the Excel function.

Instructions

We proceed directly to the construction. In the "Menu" select the "Insert" tab. In the list of proposed options we use the item "Diagram". We choose any of the available point diagrams. Click "Next". We need a point diagram. Now we will tell you why. Other diagrams will not allow you to create a single function and argument. The value type uses a reference to the desired group of cells. As a result of the done actions a new dialog box will appear, in it we press the button "Row".

Proceed to the next stage. Create a series using the "Add" button. The following window will appear, in which we set the search path for the required values to construct the required graph. To select the desired cells, click on the thumbnail of the Excel spreadsheet. Specify the necessary cells in the table. Soon the required function appears on the sheet, the value in "Excel" is already set, and it only remains to press "Done". The graph is built. If desired, it can be of any size and of varying complexity.

Other features

With the question of constructing functions and graphs for them, we sorted out, but the spreadsheet editor has a number of other features that you should also know about to make it easier to work with. Speaking about the mathematical possibilities of Excel, you can not pass by the subtraction function. To calculate the difference between two numbers, click on the cell in which the result will be displayed. We introduce the equal sign. If the content starts with this notation, Excel thinks that the cell contains a specific mathematical operation or formula. After the equality sign, without using a space, we type the decremented number, put a minus and enter the subtrahend. After that press Enter. The difference between the two numbers appears in the cell.

Consider the option in which the source data should be taken from other table cells. For example, in order for cell B5 to show the number reduced by 55, located in cell D1, click on B5. We introduce the equal sign. After that press the cell D1. The sign of equality will be followed by a reference to the cell chosen by us. You can also type the address manually, without using the mouse. After this, we introduce the subtraction sign. Specify the number 55. Press Enter. Then Excel automatically calculates and displays the result.

In order to subtract the value of one cell from the other, we use a similar algorithm. We introduce the equal sign. We type the address or we press the cursor on a cell in which there is a reduced value. After that, put a minus. Enter or click on the cell in which the subtracted value is located. Use the Enter key. Action completed.

It has already been noted above that formulas are used to construct a function in Excel, so it is necessary to get acquainted with the features of their creation. There are a number of rules for this. Among other things, formulas allow you to automate the process of calculating values entered into cells. Let's start from the very beginning. Run Excel. Carefully take a look at the familiar interface. The string of formulas is denoted by the letters fx. That's exactly what we need.

To enter a simple formula, we specify the required value in the cell by writing an equal sign before it. After pressing Enter, we will see the result. You can use several methods of data entry. Click on the empty cell A1. We insert a certain value into it, preceded by the symbol "equal". We pass to the next cell B1. We specify another element of the formula in it. We continue the similar actions until all the parameters provided in the task are entered into the table. The equals sign is placed in the last empty cell.

Proceed to the next stage. We select cell A1. We insert in it an arithmetic sign (division, multiplication, addition). We choose another cell, for example, B2. Press Enter. Create the original expression by double clicking on the cell and pressing Ctrl and "Apostrophe".

So we figured out how to build a graph of the Excel function, and also learned how to work with formulas and algorithms that might be required for this.