Lesson # 3: Rank() Function in MS Excel

RANK() formula in MS Excel:

This function is available for compatibility with Excel 2007 and earlier.

Now, what it does? And how are we going to use it in a spreadsheet?

Let us look how it works:

RANK = Returns a rank of number in a list of numbers.

Syntax or sequence of command:

=RANK(number, ref)

                Let’s look at our example below:

               

Figure 1

Lesson # 2: CONCATENATE Function in MS Excel

CONCATENATE() formula in MS Excel:

Now, what it does? And how are we going to use it in a spreadsheet?

Let us look how it works:

CONCATENATE = Joins several text strings into one text string.

Syntax or sequence of command:

=CONCATENATE(text1, text2, text3, text4)

and so on.

                Let’s look at our example below:

               

Figure 1

Lesson # 1: Average Function in MS Excel

AVERAGE() formula in MS Excel:

Now, what it does? And how are we going to use it in a spreadsheet?

Let us look how it works:

Average = Returns the average (arithmetic mean) of the arguments.

Syntax or sequence of command:

=AVERAGE(number1; number2; number3; number4)

and so on.

                Let’s look at our example below:

               

Figure 1