How to use the minimum of Office2007 Excel function? In fact, it is very simple. The following is the Office2007 compiled by Xiaobian An introduction to the minimum usage of Excel functions. Friends in need can learn together!
The first step is to open an Excel document and enter data in it as shown;
In the second step, we left-click to select the cell below 90;
The third step is to click the lower icon arrow of automatic summation, and then select the minimum value;
The fourth step is to pop up the interface as shown in the figure; then we click the Enter key (Enter key);
The fifth step is to get the result. The minimum value of this column is 11.
In actual work, there are many times when it is necessary to use the minimum value of multiple columns of values. Let’s continue to demonstrate. Continue to click the drop-down arrow of automatic summation above, and then click the minimum value, and the interface will pop up as shown in the figure;
The sixth step is to select the cell of 22. At this time, please note: do not let go of the left click, and then drag to the cell with the last value;
The seventh step is to hold down the Ctrl key and select the two values next to it, as shown in the figure;
In the eighth step, we can get the minimum value of multiple columns of values by pressing the Enter key.
The above is the minimal usage introduction of office2007 Excel functions brought by the editor. I hope it can help friends in need.
