Excel Basics Tutorial-Statistical functions

Sometimes need to do some data statistics, such as counting the number of passing, each fraction of the paragraph, and so on, let's look at an exercise;

1. Start Excel

1 Click "Start-All Programs-microsoft-microsoft Office Excel 2003";

2 There is a blank window full of grid, this is a spreadsheet, the first grid look at the border to be thicker, in the selected state;

2, Excel window

1 point Menu "file-open" command, open the last "score sheet" file;

2 Enter the "pass number" below the name, and then move the cursor to the next grid;

3 Click on the formula bar next to "FX", in the list of functions to find "statistics", found below "COUNTIF", click "OK" button;

4 Next is the data area panel, from "78" down to "68", Box selected three people's language results;

5 Switch to the English input method, in the function panel of the second text box input ">=60", and then click "OK", that is, 60 points or more passed;

After the point "OK", the statistic results appear in the cell.

6) Drag the fill handle, the next two grids are also filled, so that the number of passing the subject of the statistics well;

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join