Steps are as follows:

Tools/Raw Materials

EXCEL2016 version, computer.

1, open the computer to find and click EXCEL2016 software.

2, after opening the EXCEL software, for a better demonstration of the first in the blank form of a new good form content.

3, edit the form content, in the upper toolbar to find and click on the "View" command.

4, click on the View command, in the interface below to find and click on the "display ratio" command.

5, click on the display ratio, in the pop-up dialog box, select "Custom" and set the parameters can be completed.

Use:

1, form processing?

One of the outstanding features of Excel is the use of forms to manage data, all the data, information in the form of two-dimensional tables (worksheets) management, cell data interrelationships at a glance.

This makes data processing and management more intuitive, more convenient, and easier to understand. For daily work in the form of common processing operations, for example, add lines, delete columns, merge cells, tables transpose operations, in Excel are simply through the menu or tool buttons can be completed.

2, data analysis

In addition to a variety of forms can be easily processed, Excel has a general spreadsheet software does not have a powerful data processing and data analysis capabilities.

It provides, including financial, date and time, math and trigonometric functions, statistics, find and reference, databases, text, logic and information, such as nine categories of hundreds of built-in functions to meet the requirements of many areas of data processing and analysis.