Current location - Health Preservation Learning Network - Fitness coach - How to use the Numbers pop-up menu in a mac?
How to use the Numbers pop-up menu in a mac?
Numbers is a spreadsheet application developed by Apple. As a part of the office software suite iWork, the specific usage is as follows:

1. Formula function

In the past, only a few people were proficient in formula function, but Numbers '09 is so simple and easy to use, and everyone can become a master of formula from now on. Contains more than 250 functions, which you can select by clicking. Each function has a detailed description and built-in help function. You can even use visual placeholders as variables in formulas to combine formulas. Just click on the placeholder and select the value you need to add to the formula.

2. Formula list display

Spreadsheets contain many worksheets, tables, numbers and formulas. How can I make everything clear? With the new formula list display, you can display it in a spreadsheet.

3. Formula list

View all calculations at once. Click the formula list button in the toolbar, and then select a specific formula directly. You can also search for references to formulas, functions, or cells. Sometimes spreadsheets contain a lot of data, so it is difficult to understand. At this point, you can click on any column.

4. Table classification

Data in to create different categories of tables. Each category includes a summary row, which makes it easy to open, collapse and arrange data. You can also add functions to the total row to organize your data, including subtotal, average, count, minimum, maximum and so on.

5. Advanced chart function

Numbers'09 comes with better 2D chart, 3D chart and interactive chart options. You can use different polylines, column charts and space charts in a mixed chart at the same time. Create a two-axis chart with different numerical scales. Add trend lines and error lines conveniently. You can add color to your chart by clicking the mouse.

Step 6 be in close contact

Now, Numbers, Pages and Keynote can work together, so you can put all the data on the same page. Create a chart in Numbers, and then copy it to a Pages document or Keynote presentation. These charts are numerically related to the original data. Even if the style, material, color and font of the chart are different, the data is the same. If you make changes to the data, you can click to update the chart associated with it. In Pages and Keynote, you can also easily access the original data in Numbers at any time, or disconnect the data.

7. Template Selector

Need more table inspiration? The professional quality template designed by Apple is a good start. Numbers '09 provides you with 12 new categories and 30 design templates, including check register, savings calculator or retirement savings template, and can also make baby growth memorabilia or garden management diary. Track your weight and fitness progress. More possibilities are waiting for you to explore.

8.* * * More ways to enjoy documents

Enjoy the Numbers spreadsheet with any Mac or PC user.

You can open a Microsoft Excel file in Numbers and save the Numbers file as Microsoft Excel.

Format. Using the powerful graphics processing tools in Numbers, it is very simple to add a lot of colors to Excel files. Numbes can also output files in PDF format. new

The email option allows you to send Numbers, Excel, or PDF directly in Numbers via Mac OS X mail.

Format the file. Commentators can read, annotate and download the format that suits them online.