EXCEL
ASSALAMUALAIKUM
After entering lab class, now I know there are a lot of function in excel to make our work more easier and save time. There are some functions that I learn, SUM Function, IF Function, VLOOKUP Function, COUNTIF Function, AVERAGE Function and MEDIAN Function, actually there are more.
https://support.office.com/en-us/article/Excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb
Here is the link to figure out more function and it use.
So, while doing on my assignment, I realised there is some function that Dr. did not taught in the class, she only taught the basic of it. When you using IF function it will come out like this :
we can only enter one logical test. What if, for example, a teacher want to key in her students achievement that required 2 logical test? You can check this link for the answer :)
https://www.ablebits.com/office-addins-blog/2014/12/03/excel-if-function-iferrror-ifna/
[OFF TOPIC]
By the way, what I have learnt since enter university is we are no longer a child that need to feed all the time. To be honest, when we solved the problem by ourselves that are more satisfied.
After entering lab class, now I know there are a lot of function in excel to make our work more easier and save time. There are some functions that I learn, SUM Function, IF Function, VLOOKUP Function, COUNTIF Function, AVERAGE Function and MEDIAN Function, actually there are more.
https://support.office.com/en-us/article/Excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb
Here is the link to figure out more function and it use.
So, while doing on my assignment, I realised there is some function that Dr. did not taught in the class, she only taught the basic of it. When you using IF function it will come out like this :
OR
we can only enter one logical test. What if, for example, a teacher want to key in her students achievement that required 2 logical test? You can check this link for the answer :)
https://www.ablebits.com/office-addins-blog/2014/12/03/excel-if-function-iferrror-ifna/
[OFF TOPIC]
By the way, what I have learnt since enter university is we are no longer a child that need to feed all the time. To be honest, when we solved the problem by ourselves that are more satisfied.
Comments
Post a Comment