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!

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.