Microsoft Excel: Functions

Hello! I am back. Now I am going to discuss about excel. Maybe you already know and maybe you don’t know about what I am going to discuss but just read and maybe you can increase your knowledge.

Functions:

First, let’s start with  the easy ones.

1.Sum

Sum is a function to add numbers in a range of cell. For example, you are going to add the numbers in cell A1 up to cell A4. You can write the function like:

=SUM(A1:A4)

2.Minimal and Maximal Value

This function is to find the minimal value out of the list of cells. While maximal value is to find the result of the maximum value of the cells.

=MIN(A1:A4)

=MAX(A1:A4)

3.Count

Count is to count the total number of datas in a range of cells.

=COUNT(A1:A4)

4.If

This function is for deciding. For example: You are a teacher and you have a list of data of scores of your students. You want excel to decide easily which student passed and which student failed. The passing score is 70, so you type the function like this:

=if(logical test;”value if true”;”value if false”)

so if the cell address is A1, then

=if(A1>70;”Pass”;”Fail”)

Either the sign is a semi colon or a come is according to your PC, so check it first or the function will not work.

These are several functions I learnt at school.

Here’s my creation:

bandicam-2016-11-19-17-00-04-171

 

That’s one of my creations which is a Sudoku game. You can search on how to make it online.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s