HOW TO USE EXCEL S CALCULATION FUNCTION?

excl is a very powerful software for calculation, not a how to calculate can be said clearly, if you just do some simple calculations, then you can enter cells + cells in the cells you need to get the answer (the "+" can be any operator), if it is just sum, then there is a " " button in the common toolbar of **, that is, automatic sum; If you want to do more advanced calculations, then you can only use functions, in which case it is best to find a related bookbox and learn it systematically.

Here's an example. Hypothesis.

a1=3a2=5

a3=10In a4, enter = sign.

Dots A1 cell.

Enter the + sign.

Click on cell A2 again.

Enter the + sign again.

Click on cell A3 again.

In this case, A4 shows =A1+A2+A3

Press enter, this formula in A4 is calculated, and immediately it will be displayed in A4 18 and you click back to A4

Notice that 18 is displayed in a4, while a1+a2+a3 is still displayed in the formula bar

I hope to add some emotional understanding to you.

Open Excel and click Insert Menu --> Functions. There are a lot of functions in it. You know how to play.

with an operator"+ -/"It can be calculated directly, and it can also be calculated with functions. Input"="After that, you can use it directly.

First, when using formulas in excel, you need to enter "=" in the column first

Then enter the English name of the formula after =, such as sum, etc.

Please click Enter a description.

After the second input =sum, use the mouse to select the cell data to be calculated.

It is to start with =sum(), and in parentheses is the position of the cell to be counted.

Then press the enter key to confirm, and the result of the sum can be calculated.

Please click Enter a description.

Thirdly, if you want to count the data of a relatively large cell area.

When you write the formula, you need to press the mouse to select that area.

Then press enter to confirm it.

Please click Enter a description.

Fourth, if you don't know how to select an area with the mouse.

You can use the ":" operator to select the area.

For example, C2:C10 refers to the area between C2 and C10.

Please click Enter a description.

Fifth, if you want to calculate a cell and a cell range.

The comma operator is used, combined with the operator ":".

For example, (c1, c3: c10), which is an operation between c1 and c3 to c10.

Please click Enter a description.

Some of the operators for the sixth calculation are relatively unfamiliar.

For example, the multiplication "*" and the multiplication use "".

As for the rest of the operators, they are pretty much the same as math.

Please click Enter a description.

As follows:

Equipment: Dell computer.

Operation skillful cracking system: win10

Operating software: excel**2017

1. Open the excel** that needs to be operated, enter the total function =sum(() in the cells that need to be summed, and then manually select the summing area.

2. Continue to enter ")" in the function box to complete the function and press enter. Pin filial piety.

3. Fill in the cell function below by dropping down, return excel**, and find that the calculation of the sum is completed.

In Excel**, move the mouse to the bottom of the column cell, press the alt and equal keys to vertical the hall pin to summarize the data, move the mouse to the right side of the row data, and press the alt and equal keys to summarize the data horizontally.

Tools Raw Materials:

Mechanical Revolution S3 Pro

windows10

excel2019

1. Open**.

Open Excel and enter data vertically.

2. Vertical sink hermitage.

Move the mouse to the bottom of the cell data, press "alt+=" on the keyboard to display the summary function, press enter, and find the number.

3. Input data horizontally.

Enter data horizontally within a cell.

4. Horizontal summarization.

Move the mouse to the right of the cell data, press "alt+=" on the keyboard to display the summary function, press enter, and find the number.

Make a **, sue me mailbox, and send it to you.

The table is as follows

a | b | c | d | e | f | g |

1 |Name |Gross Weight (kg)|Tare Weight (kg) |Miscellaneous |Net weight |Unit price |Total price |

2 |Zhang San | 1000 | 500 | d2 | e2 | g2 |

The formula is as follows:

d2=e2=b2-c2-d2

g2= e2*f2

Ha, I do this job a lot.

Contact me. Also, have you already singled out the duplicates, or do you need to recheck? If you use a formula, it is slow, and it is estimated that it will take 40 minutes to complete with the formula 30,000.

If the data is standardized, it is estimated that it can be solved within half an hour without formulas and comparison algorithms.

According to the description of the title, to remove miscellaneous (100 catties to half catties), then 1000 kg is 2000 catties, and 20* catties should be removed instead of 25 catties.

b2*2/100*

That is: gross weight multiplied by 2 to convert kilograms into catties, divided by 100 and then multiplied by catties to remove half a catty).

E2 cell input formula: =b2-c2-d2

G2 cell input formula: =E2*F2

Start by opening the excel document.

Here I first made a simple **, convenient to talk about the calculation process, we first calculate the total score of "Zhang San", in the total score - Zhang Sanyi column, the left mouse button is determined here, enter the "=" number, and then click on Zhang San's Chinese, mathematics, English scores, click on a number when remembering to use the "+" sign to add these numbers, and then enter"="b2+c2+d2=), you can calculate the result, please see the circle in the figure for details, through simple data we can test that this set of summation calculation method is correct.

Avoid tedious calculations and summation results, move the mouse to the bottom right corner of the number "292" border and wait for the mouse to turn into a cross.

Then drag the border until the last sum's **, you can instantly calculate the total score of everyone, and then explain the summing method of the list horizontally, in fact, it is also very simple, like step 3, first enter "=" in b6** and then click b2, b3, b3**, add up in turn and finally enter to calculate the total score of the language.

Then move the mouse to the lower right corner of B6**, and then drag the mouse horizontally to calculate the total score of all people in each subject and the total score of everyone.

In this kind of **, generally we have to rank second, so find the data in the cell, there are ascending and descending order to choose from, here I use the descending order, you can see in the icon that everyone because of the level of performance, from low to high intelligent sorting. Simple excel is done. Is it simple?

1.How to set up automatic calculation and manual calculation of formulas in Excel.

2.Various methods of excel calculations.

3.How to do division calculations in Excel.

First, enter a formula on the August 2 Balance cell. However, when I enter 150+10000=, the cell shows yes"150+10000="It's not the sum of things. That's because, when you perform a calculation in Excel, your formula must start with =.

Then, when you press the Enter key, the result will be displayed automatically. Oh, got it. You should enter =150+10000 and press the Enter key.

That's right. It's amazing! The cells can finally show the results"10150"Finish.

On the cell for the next August 3 balance, enter =10150-9850 and press Enter to ......

As a result, it was"300"。

Cell number"Represents a combination of columns and rows. For example, the cell number at the intersection of column A and row 5 is "A5".

Sounds complicated. Do not worry! Knowing the cell number is simple. Just follow my method to do it.

First, type 100 in the blank cell of the expense column, 0 in the cell of the Income column, and formula =e7-c8+d8 in the cell of the balance, and then click Enter.

e7 represents the previous balance. c8 is the expense, so it is subtracted from the calculation. d8 is income, so use addition in the calculation.

After subtracting $100 from the previous balance"179167"It's the result of the calculation!

This works well because when you change the value of the relevant cell in the formula, the result is automatically recalculated.

The expense cell retains its value unchanged and then changes to 50 in the income cell.

Balances"179167"It will be automatically updated to "179217", which is the result after adding 50 yuan.

If I use cell numbers in a formula, Excel will automatically do the calculations for me. So far, you've used subtraction or addition. use"+ and"- If your calculations include division, just use it"If it's multiplication, then use it"* It's that simple.

2"It's the result of the calculation!

50"It's the result of the calculation!

1. Excel four operations.

Taking the range of cells A1 to A5 and cell B6 as examples, A1 to A5 are 1, 2, 3, 4, 5, and B6 is 6, respectively

Addition. sum(a1:a5,b6)

a1+a2+a3+a4+a5+b6

A1 to A5 and B6 add up to 21

Subtraction. sum(a1:a5)-b6

a1+a2+a3+a4+a5-b6

The addition of A1 to A5 minus B6 is 9

Multiplication. product(a1:a5,b6)

a1*a2*a3*a4*a5*b6

The multiplication of A1 to A5 and B6 is 720

Division. product(a1:a5)/b6

a1*a2*a3*a4*a5/b6

Multiply a1 to a5 and subtract b6 to 20

The cells written to the formula cannot be the cells that have been referenced in the formula, so as not to form a circular calculation.

** is topped by a row of letters a, b, c, ,..This is the label;

To the left is a vertical column of numbers 1, 2, 3 ,..This is the line number;

The column label plus the row number is the name of the cell, and the cell name is also called the cell address, such as the third row of column A, which is cell A3, the 18th row of column C is cell C18, and the seventh row of column C is cell E7, so that the coordinates are formed one by one, indicating the position of each cell.