1. Start Excel and enter data in the first column cell, as shown in figure 1. Select cell B2 and enter the formula "= 2 * A2 2-3 * A2-5" in the edit field, which is the resolution function of the function image to be drawn. Enter to get the calculation result, and drag fill handle to copy the formula to get other calculation results, as shown.
2. Select the cell range where the data is located in the worksheet, click the Scatter Chart button in the Chart group of the Insert tab, and select the Scatter Chart with Smooth Lines option in the open list to get the required function image in the chart, as shown in Figure 3.
Details are as follows:
1, Introduction
EXCEL spreadsheet processing software is an important member of office automation software developed by Microsoft. After many improvements and upgrades, the latest version is EXCEL2000. It can easily make all kinds of spreadsheets and use formulas and functions to perform complex operations on data; Using various charts to represent data is intuitive and clear; Using hyperlink function, users can quickly open files on LAN or Internet and share workbook files with Internet users anywhere in the world.
2. Software
There are a lot of formula functions in Excel to choose from. Using Microsoft Excel, you can calculate, analyze information and manage data information list in spreadsheets or web pages, which can realize many convenient functions and bring convenience to users. It is combined with Word, PowerPoint, Access, InfoPath, Outlook and Publisher.
3. Encyclopedia business card
Microsoft Excel is one of the components of Microsoft office. It is a spreadsheet software written and run by Microsoft for computers with Windows and Apple Macintosh operating systems. Excel is an important part of Microsoft office suite software, which can process all kinds of data, make statistical analysis and assist decision-making, and is widely used in management, statistical finance, finance and many other fields.