How to implement two-digit division in a WPS table

Source: Internet
Author: User

to implement a two-digit division in a WPS table:

First, double hit the Excel table in WPS, create a new table, and rename it to "division. xls",

As shown in the following illustration:

Double-click to open Division. xls, create a data table in the table, and count the student scores table as shown in the following figure:

Next, give the table a few columns to assign a value, student's subject result, as shown in the following figure:

To make the table look clearer, add an outline and an inner border to the table, as shown in the following illustration:

In the last two columns of the table, such as the first line of language/math, enter "=",

As shown in the following illustration:

Then, with the mouse to select the first line of language and math two columns, there will be "=c3:d3",

As shown in the following illustration:

To implement Chinese/maths, change the expression above to "=c3/d3",

As shown in the following illustration:

Find the green hook in the upper left corner, click on it and make sure that division is done, as shown in the following figure:

This is the first line of language/math, with decimals, which indicates that division has been implemented successfully, as shown in the following illustration:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.