To teach you to use "Excel form automatic plot formula"

Source: Internet
Author: User

Use a table to avoid calculating some subtraction (+ 、-、 *,/), the number of small points we can use mental arithmetic, but the number is big, it is best to think of some other way, such as today to say for you "Excel automatic quadrature formula." Whether you use Excel form or not, believe that after reading this tutorial, you will certainly be able to find the product.

Excel Automatic Quadrature method:

Step one, mouse point to C1 cell, and then enter the formula "=A1*B1";

Step two, at this point, start typing in the second row of cells you need the number of product, the following figure

Step three, OK, the most critical moment is here. We will select the mouse "C1", and then when the cursor into the shape of the cross has been the net pull down, the following figure;

Let go of the mouse, you will find that all automatic calculation of the product has been completed, do not believe you look at the next figure, to see the calculation of the right!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: and provide relevant evidence. A staff member will contact you within 5 working days.