Some well known Functions in Excel and their uses

Asked By 20 points N/A Posted on -
qa-featured

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 ?

SHARE
Best Answer by Neil Auso
Answered By 0 points N/A #152209

Some well known Functions in Excel and their uses

qa-featured

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.

Best Answer
Best Answer
Answered By 0 points N/A #152208

Some well known Functions in Excel and their uses

qa-featured

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.

Login/Register to Answer

Related Questions