Life's Pleasure

Wednesday, October 4, 2017

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

The Smartest Way: Running Microsoft Office Application

Shortcuts on running a Microsoft office application when icons are not around.
On an average user, they can’t start an application especially when they do not see icons on the desktop. When the Microsoft windows operating system evolved, some people find it difficult to find icons or start a program. But did you know that there is some kind of shortcuts when running Microsoft office application?

Excel Tips: Control(ctrl) + Enter Keys to fill an entire range with formula

Control(ctrl) + Enter Keys to fill an entire range with formula:

Many times, we have to apply the same formula for a range of cells (see image below).