Microsoft Excel是一个功能强大的电子表格,可让您管理和分析大量数据。您可以以最有效的方式进行简单和复杂的计算。Microsoft Excel由包含行和列的单个单元格组成。行编号,而列有字母。在单元格中输入所需的值后,手动或自动执行计算变得非常容易。只需使用 +、-、*、/ 等基本运算符,即可在Microsoft Excel中进行加减乘除。要计算或分析大量数据或数字,可以使用内置函数,如 sum、count、average、max、min 等。
Excel(Excel – Addition)中的基本计算(Calculations)- 加法,减法(Subtraction),乘法(Multiplication),除法(Division)
如前所述,您需要在此处使用 +、-、*、/ 等基本运算符。您需要记住的是,所有(All)公式都需要以 (=) 符号开头。在下面的Excel表中,在第一个表中,您可以看到两个数字 10 和 5,这是我们的数据。在另一个表中,您可以通过应用适当的公式来查看要执行的操作。
如何在 Excel 中插入公式
公式(Formulas)可以包含单元格引用、单元格引用范围、运算符和常量。让我们看看这是如何做到的。
- 要添加(Add),请选择单元格 G3,键入=D3+D4,然后按Enter。答案将自动显示在单元格 G3 中。
- 要减去( Subtract),请选择单元格 G4,键入=D3-D4,然后按Enter。答案将自动显示在单元格 G3 中。
- 要相乘(Multiply),选择单元格 G4,键入=D3*D4,然后按Enter。答案将自动显示在单元格 G4 中。
- 要除法(Divide),请选择单元格 G5,键入=D3/D4,然后按Enter。答案将自动显示在单元格 G5 中。
很简单很容易,对吧?
提示(TIP):如果Excel 公式没有自动更新,这篇文章将为您提供帮助。
如何在Excel中插入和使用(Excel)函数(Functions)
函数(Functions)可帮助您执行各种数学运算、查找值、计算日期和时间等等。浏览(Browse)公式(Formulas)选项卡中的函数库(Function Library)以了解更多信息。现在让我们看几个关于如何插入和使用函数的例子。下表显示了学生的姓名和他们每个人获得的分数。
要计算所有学生的总分,我们需要使用Sum Function。有两种方法。
1) 选择单元格 E7,然后键入=SUM(E2:E6),然后按Enter。答案将自动显示在单元格 E7 中。
2)点击要选择的单元格,即单元格E2到单元格E6。在“公式(Formulas)”选项卡的“函数库(Function Library)”组下,单击“自动求和”(Auto Sum)下拉菜单,然后进一步单击“求和”(Sum)。正确的值将显示在单元格 E7 中。
这是您如何使用Sum 函数(Sum Function)从给定的一组值中计算总值的方法。
同样,您可以根据您的要求执行各种其他功能,例如Average、Count、Min、Max等。(Max)
我希望你发现这个基本教程很有用。(I hope you found this basic tutorial useful.)
现在阅读(Now read):如何在 Excel 中计算中位数(How to calculate the Median in Excel)。
How to Insert and Calculate Formulas and Functions in Excel
Microsoft Excel is a powerful spreadsheet that lets you manage and analyze a large amount of data. You can carry out simple as well as complicated calculations in the most efficient manner. Microsoft Excel is made up of individual cells consisting of rows and columns. Rows are numbered, whereas columns are lettered. Once you have entered the desired values in the cells, it becomes pretty easy to carry out the calculations manually or automatically. You can add, subtract, multiply, and divide in Microsoft Excel by simply using the basic operators such as +, -, *, /. To calculate or analyze a large amount of data or numbers, you can use the built-in functions such as sum, count, average, max, min, and so on.
Basic Calculations in Excel – Addition, Subtraction, Multiplication, Division
As mentioned earlier, you need to make use of the basic operators like +, -, *, / here. All you need to remember is that all the formulas need to start with a (=) sign. In the Excel sheet below, in the first table, you can see two numbers 10 and 5, which is our data. In the other table, you can see the operations to be carried out by applying appropriate formulas.
How to insert Formulas in Excel
Formulas can contain cell references, ranges of cell references, operators, and constants. Let us see how this is done.
- To Add, select cell G3, type =D3+D4, and then press Enter. The answer will automatically be displayed in the cell G3.
- To Subtract, select cell G4, type =D3-D4, and then press Enter. The answer will automatically be displayed in the cell G3.
- To Multiply, select cell G4, type =D3*D4, and then press Enter. The answer will automatically be displayed in the cell G4.
- To Divide, select cell G5, type =D3/D4, and then press Enter. The answer will automatically be displayed in the cell G5.
Quite simple and easy, right?
TIP: This post will help you if Excel Formulas are not updating automatically.
How to insert & use Functions in Excel
Functions help you perform a variety of mathematical operations, lookup values, calculate date and time, and a lot more. Browse through the Function Library in the Formulas tab to learn more. Now let us see a few examples on how to insert and use functions. The table below displays the name of the student and the marks obtained by each one of them.
To calculate the total marks of all the students, we need to use the Sum Function. There are two ways to so.
1) Select the cell E7, and type =SUM(E2:E6) and then press Enter. The answer will be automatically displayed in cell E7.
2) Click on the cells you want to select, that is, cell E2 to cell E6. In the Formulas tab, under the Function Library group, click on Auto Sum dropdown menu, and then further click on Sum. The correct value will be displayed in cell E7.
This is how you can calculate the total value from a given set of values by using the Sum Function.
Similarly, you can perform various other functions such as Average, Count, Min, Max, and so on, depending on your requirement.
I hope you found this basic tutorial useful.
Now read: How to calculate the Median in Excel.