The specific steps are as follows:
As shown in the figure, A 1, A2 and A3 are divisors, B 1, B2 and B3 are divisors, and C 1, C2 and C3 list their results respectively.
Method 1: directly express% by function.
Enter the formula = text in C 1 (round (a1/b1,4), "0.00%"), and press enter to get the result of C 1. The steps of C2 and C3 are the same.
Here, the text function is used to convert the values in brackets into% form; The round function is used to round the quotient.
Method 2: Convert to% in cell format.
1. Select the cell where the quotient is located, here are C5, C6 and C7, and right-click to set the cell format.
2. Select "Percentage" and confirm.
3. Enter =A5/B5 in the edit field of C5 to get the result. Steps C6 and C7 are the same.
Extended data
Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. Intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software. 1993, after the release of version 5.0 of Microsoft Office component, Excel began to become the overlord of spreadsheet software on the applicable operating platform.
Microsoft Office is a set of office software developed by Microsoft, which can run on Microsoft Windows, Windows Phone, Mac series, iOS and Android. Like other office applications, it includes federated servers and Internet-based services. Since the 2007 version of Office, it has been called "Office System" instead of "Office Suite", which reflects the fact that they include servers.
Office was originally a promotional name, which appeared in1early 1990s, referring to a collection of software previously sold separately. At that time, the main promotion focus was: buying a collection saved a lot of money than buying it alone. The original versions of Office included Word, Excel and PowerPoint. "Professional Edition" includes Microsoft Access, and Microsoft Outlook did not exist at that time.
With the change of time, Office applications are gradually integrated and enjoy functions such as spelling and grammar checking, OLE data integration and VBA scripting language. At present, Microsoft extends Office as a development platform, and can download third-party software from specialized stores.
Office is often the standard for making document files. It has some functions that other products do not have, but other products also have functions that Office lacks. Since 2007, Microsoft Office System has had a completely different user interface from the previous version. This interface is called Ribbon interface, which is used in Microsoft Office 20 10, Microsoft Office 20 13 and Microsoft Office 20 16.
reference data
Microsoft Office Excel_ Baidu Encyclopedia