Select the new tab in the opened object dialog box, find "microsoft Formula 3.0" from the object type, and click OK to open the formula editor.
A formula editing box and a formula editing toolbar will appear in the editing area of the document. Select the formula type we want to enter, and then enter the content to create the formula.
As shown in the figure:
How to use formulas to draw in excel The following are the ways to use formulas to draw in excel:
1. Open the excel document to be processed.
2, excel drawing, only accept data. -The formula must also have a specific value.
3. Write X and Y into two columns with a certain number of grids.
Column a: x, column b -x 2
4. Select these data, insert the chart, and then select the scatter chart.
5. See the parameters in the detailed options.
How to draw a function image of a mathematical formula with excel? First, open the operation window of the spreadsheet, then use the mouse to select the "New" command in the menu bar, and a blank spreadsheet will appear on the screen.
B, then enter "x=" in a 1 cell of column A, indicating that this is an independent variable, and then enter the value of the independent variable from small to large in a2 and subsequent cells of column A; In actual input, arithmetic progression input method is usually adopted. First, enter the first three values to determine the distance between the number and the number of independent variables. Then, click on box a2, hold down the mouse and drag to box a4 to select these three items, so that these three items become a black rectangle. Then, use the mouse to point to the small square in the lower right corner of this black rectangle. When the cursor changes to "+",hold down the mouse and drag it to the appropriate position to complete the input of independent variables.
C, and then enter a general function expression of the function formula y=f(x) in the b 1 cell of column B, such as y =1/x; You can also click the function icon "fx" on the toolbar and select the required one from the list of different functions that appear; After the input is finished, click the tick next to the function input dialog box, and the calculation result will be immediately obtained in the b2 box. At this time, select the b2 box again, and let the cursor point to the box in the lower right corner of the b2 rectangle. When the cursor changes to "+",hold down the cursor and drag it to the appropriate position along column B to complete the calculation of the function value. Note that the position of the independent variable X in this function must be entered into the grid of the absolute position a2 of the independent variable in the previous column A, so that different independent variables will be calculated in the later calculation;
D finally, click the chart wizard icon on the toolbar, select "X, Y scatter chart" from various chart format icons that appear, and then select "Scatter chart with smooth lines of countless data points" from the type of "X, Y scatter chart" that appears; At this time, you can hold down the mouse to see the function image to be drawn. In addition, for functions whose independent variables are only positive values, they can also be drawn in "line chart" format in the chart wizard.