1. Getting to know Excel

2 Topics | 1 Quiz
2. Working with Cells

3 Topics | 1 Quiz
3. Modifying Columns, Rows, and Cells

2 Topics | 1 Quiz
4. Formatting Cell

5 Topics | 1 Quiz
5. Understanding Number format in Excel

5 Topics | 1 Quiz
6. Using Find & Replace

2 Topics | 1 Quiz
7. Formulas and Functions

6 Topics | 1 Quiz
Every function has the same structure. For example, SUM(A1:A4). The name of this function is SUM. The part between the brackets (arguments) means we give Excel the range A1:A4 as input. This function adds the values in cells A1, A2, A3 and A4. It’s not easy to remember which function and which arguments to use for each task. Fortunately, the Insert Function feature in Excel helps you with this.

To insert a function, execute the following steps.

1. Select a cell.

2. Click the Insert Function button.

The ‘Insert Function’ dialog box appears.

3. Search for a function or select a function from a category. For example, choose COUNTIF from the Statistical category.

4. Click OK.

The ‘Function Arguments’ dialog box appears.

5. Click in the Range box and select the range A1:C2.

6. Click in the Criteria box and type >5.

7. Click OK.

Result. The COUNTIF funct

ion counts the number of cells that are greater than 5.

Note: instead of using the Insert Function feature, simply type =COUNTIF(A1:C2,”>5″). When you arrive at: =COUNTIF( instead of typing A1:C2, simply select the range A1:C2.