Current location - Trademark Inquiry Complete Network - Tian Tian Fund - Table making excel tutorial addition, subtraction, multiplication and division
Table making excel tutorial addition, subtraction, multiplication and division
Excel tables can be added, subtracted, multiplied and divided according to the following steps:

Open Excel and create a workbook

Open Excel, create a new workbook, or open an existing workbook.

Create table

Create a table in the worksheet, including the data to be calculated and the corresponding operation symbols. You can create a table by using the Table function in the Insert tab of Excel.

input data

Enter the data to be calculated in the table, including addend, subtraction, multiplier, divisor, etc.

Create formula

To create a formula in the cell to be calculated, you can enter the "=" symbol in the cell, and then enter the corresponding calculation formula.

Add style

You can use the Style function in the Start tab of Excel to add styles to the table to make it more beautiful and readable.

Perform calculations

When you enter formulas and data, Excel will automatically perform calculations and display the results.

For example, if you want to calculate the result of A 1+B 1, you can enter the formula "=A 1+B 1" in C 1, and Excel will automatically calculate and display the result in C 1.

Similarly, if you want to calculate the result of A 1-B 1, you can enter the formula "=A 1-B 1" in C 1, and if you want to calculate the result of A 1, you can enter it in c/kloc-kloc. If you want to calculate the result of A 1/B 1, you can enter the formula "=A 1/B 1" in C 1.

I hope the above steps can help you to use Excel tables for addition, subtraction, multiplication and division.