The least common multiple of the operation steps of mathematical calculation using common functions in Excel version 20 10: LCM function.
Open the Excel spreadsheet, select a cell (as shown in the figure) as the output location of the final result, and click? f(x)？ , or click? Formula? Insert a function under the menu.
Are you online? All of them? In the function category, locate and select the LCM function. You will see its function below, and then click OK.
Drag the mouse to select all the data that need the least common multiple. Number 1? The selected data range will be displayed in the box. Click OK to evaluate.
(The final result is shown in the figure below)
Greatest common divisor: GCD function
The method of using GCD function is the same as the method of finding the least common multiple above. Just find and use the GCD function, select the data and directly determine the output result.
Sum-sum function
In fact, the operation steps of the function are basically the same, and there are many ways to sum. I will briefly introduce those two common ones.
Type 1: Select the data to be accumulated and summed, and open? Formula? On the menu bar, click automatic summation, and you will see the following? SUM？ Function formula and data evaluation range.
And press it directly? Enter? Key can directly output the sum of data.
Secondly, select any cell (as shown in the figure) as the output location of the final result, and click? f(x)？ , or click? Formula? Insert a function under the menu.
Are you online? All of them? In the function category, locate and select the SUM function. You will see its function below, and then click OK.
After confirmation, the range of data summation will appear. Drag the mouse directly to select data, as above. After confirmation, you can see the sum result in the selected cell.
end
Rank-rank function
The Rank function is most commonly used to find the ranking of a value in a certain area.
Select a cell (as shown in the figure, preferably on the right side of the data) as the output position of the final ranking number, and click? f(x)？ , or click? Formula? Insert a function under the menu.
Are you online? All of them? In the function category, find and select the ranking function. You will see its function below, and then click OK.
Tip: Will the used functions remain in? Common functions? Here, just look here. It's very convenient.
Next, you need to select the relevant data on the page that appears, click OK, and output the ranking figures directly in the result cell.
Data introduction:? Number? This is the data that needs sorting; ? Referee? Is the data area of an array or cell; ? Order? The selected values for are 0 and 1. By default, you don't need to enter them, and you get the sort from big to small (if you want to find the data of the last number, you need to enter the value of Order as 1).
Other common functions
First, average: average function.
Use the same method as summation. Select the function and data range, and then click OK.
Max/Min: Max/Min function
In fact, the simplest operation steps of the function are the same, as long as you know the application method of the function, you can operate anything.
Finally, introduce a little trick, using the formula in the menu bar? Automatic summation? , you can calculate sum, mean, maximum and minimum, and you can also calculate the number of data.
As long as you select a function below it, all data will be automatically selected. News? Enter? Key will automatically output the results in the cell.