Name some functions in Excel and how I can use them? What is the purpose of the lookup function in EXCEL? What operation does the AND function perform? What is IF function in Excel? How is the “What If “condition used in Excel to give different answers when you change the data ?
Name of Function in Excel:
YEARFRAC function:
Return the years between start dates to end date.
YEAR Function:
Serial number convert into year.
WORKDAY function:
Return the working days.
WEEKDAY function:
Convert a serial number to a day.
VALUE function:
Convert a text in to number.
UPPER function:
Convert text in to uppercase form.
TYPE function:
Return the data type value.
TRUE function;
Return true if logical value is true.
TRIM function:
Remove the spaces from text.
Working of LOOKUP function:
Check the value that is in array or vector form.
Working of AND function:
Return true if given condition is true otherwise return false if given condition is false.
Working of IF function:
Return true if condition met otherwise return false.
The LOOKUP function is used to returns a value either from a one-row or one-column range.  It has to syntax formÂ
1) VectorsÂ
2) Arrays.
These functions can be found on Microsoft website. You can also Google it to get best syntax.
