exercises 3 and 4

Exercise 3:
In this exercise, you will have the knowledge about using 'SUM', 'Average' functions and 'IF' function in multiple times in one line as well as you can enhance your knowledge on different logic or ideology. I hope that you  will be happy to write more exercises after seen and understood these exercises.

Note: If you need to understand to find the total of the marks, please visit to functions menu, and there is sections for 'SUM' function will give you the right direction to find the total for multiple numbers in one cell.

Okay, lets got to exercises: 

The first exercise will teach you how to find the average of the certain numbers:
In the below exercise has found the average for the marks such as Science, Maths, Philosophy and Language.

The First Exercise: Average function

In the below exercise has found the result for the averaged marks such as Science, Maths, Philosophy and Language.

The below exercise will teach you how to find the results as required under conditions.

The Second Exercise: 'IF' function

To giving correct answers to the question in the above exercise, there must be understood about the logic behind the question and once you understood the logic of the theory then you can write the functions to find the correct answer: have a look at the example has given the above. Here you can observe the way of functions have used to find the results by dragging.

The above functions method call 'at once' because when you write the functions to find the results under many conditions that there you have to use your skills to write the functions to find the result not only for one row it should work for rest of the below rows as well when you use the dragging method. That's how the "IF' functions have written in the above exercise.


Exercise 4:

​In these exercises, you will have the knowledge about combinations of functions using in one line such as 'MID', 'LEFT', 'TEXTJOIN', 'MONTH' and ''DAY' as well as you can enhance your knowledge on different logic or ideology. I hope that you  will be happy to write more exercises after seen and understood these exercises.

The First Exercise:
In this exercise, you will be enhanced your skills on find the year of the birth from the 'IDENTITY'  card number which is using in Sri Lankan Identity card.

Note: when you try to write the function to find the year of the birth from a NIC number, you gotta think about the people who born after or in the year 2000yrs. Because the department for registration of person in Sri Lanka has been adequate to adding only two digits for the year of birth in the NIC, so here is the issue that's when we try to provide full year of the birth, we should find the first two digits only who born before 2000yrs and add '19' in the function like the below example. Or if people who born after or in 2000yrs, the department for registration of person in SL has added full year (all four digits) of the birth. So it's easy to retrieve the year of the birth from those identity cards number and you have already learnt about creating functions if there is a condition to find the exact answers. 

The Second Exercise:
In this exercise, you can understand about finding the month of the birth from the NIC number which is using in Sri Lanka.
​

The Third Exercise:
In this exercise, you can understand about finding the month of the birth from the NIC number which is using in Sri Lanka.
​

​Should you have questions, please state them all through comments section.