{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
Excel function of mathematics and the application of trigonometric functions Detailed tutorial (with examples)
Finishing by: Date:2009-04-11 13:10:48 Popularity: Tags:tutorial



Second, with the function of the function of the application of image

I think we must also remember that we students of secondary school students often need to draw images of various functions. That time is a little bit of paper with coordinates depicting, often because of the negligence of the calculation, not a smooth depiction of the function curve. Now, we already know Excel is almost what we need to include a variety of math and trigonometric functions, then is it possible to use Excel functions and Excel chart features images portray it function? Certainly.

Here, the author sine function and a cosine function as an example method of image description.


Figure 2 Function Image

1, input data - as shown, the first entry in the table data, since the B1 to N1 cells to 30 กใ increments from 0-360 recorded figures, a total of 13 digits.

2, and function - in the No. 2 line and the third line of input SIN and COS, respectively, function, It should be noted that: As the SIN in Excel, such as the definition of trigonometric function is to radian value, it is necessary to first point of value radian value. Written for the specific formula (for example D2 in): = SIN (D1 * PI () / 180)

3, select the image types - in the first image selected by the needs of the production function of the table data, use Excel toolbar Chart Wizard button (also can use the "Insert" / "chart"), the "Chart Type" select " XY scatter ", and then in the right side of the" sub-chart type "select" line smoothing scatter numerous positions ", click [Next], the" Chart Data Source "window without any operation, a direct single - hit [Next].

4, operation chart options - options to operate the chart curve function is to produce an important step, in the "Chart Options" window (Figure 3), in order to operate the project:

Title - to take the title of the chart, this case is known as "sine and cosine function of the image"; to take the title of horizontal and vertical axis.

Coordinate axis - can not take any action;

Grid - can make a similar coordinate grid paper online, you can cancel grid;

Legend - Legend on this case to choose the right image, this may be the case with the specific choice;

Data signs - in this case is not marked in the image data, mainly due to the impact of aesthetics. If there are special requirements for the exception. 5, complete the image - click to operate after the end of [complete], to insert an image of the working area of the Excel.

6, edit the image - the image generated, the font, image size, location are not necessarily appropriate. Choose the appropriate option to edit. All of these operations can first select the relevant parts of the mouse, then right-click pop-up menu shortcut, through the shortcut menu of the project can operate.

At this point, a sine and cosine function of the image produced. The same way, but also the production of the second curve, the number of images and so on.
there isArticle InformationsComment Information
Category column

Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1