Microsoft Excel 2016 – Function Library

Microsoft Excel 2016 – You can use different types of function in Microsoft Excel 2016 – Function Library.

Microsoft Excel 2016

You can also read Microsoft Excel 2016 – Arrange

Function Library

In this tab you see many functions are over there like Insert Function, AutoSum, Financial Function, Logical Function, Text Function, Date & time Function, Lookup and Reference function, Math function and many more function available in this group.

Insert Function

Insert function is working with current cells. Here you can easily pick insert function and use in your spreadsheet. There is some function you can use like SUM (), AVERAGE (), IF (), HYPERLINK (), COUNT (), MAX (), SIN (), SUMIF (), PMT (), STDEV () functions.

AutoSum

AutoSum functions you can automatically add calculation functions in your spreadsheet like SUM (), AVERAGE (), COUNT NUMBERS (), MAX (), MIN () and more function you can use in your spreadsheet.

Recently Used

Here is the recent functions that you are using the latest. You can access your latest functions used in your spreadsheet.

Financial

Add financial functions using financial groups there is many functions available in spreadsheet such as ACCRINT (), ACCRINTM (), AMORDEGRC (), AMORLINC (), COUPDAYBS (), COUPDAYS (), COUPDAYSNC (), COUPNCD (), COUPNUM (), COUPPCD (), CUMIPMT (), CUMPRINC (), DB (), DDB (), DISC (), DOLLARDE (), DOLLARFR (), DURATION (), EFFECT (), FV (), IPMT (), IRR (), ISPMT () and many more functions.

Logical

You can add logical functions using Logical groups like AND (), FALSE (), IF (), IFERROR (), IFNA (), NOT (), OR (), TRUE (), XOR () and many more logical functions in your spreadsheet.

Text

Add text functions using Text groups. In that group many function available such as BHATTEXT (), CHAR (), CLEAN (), CODE (), CONCATENATE (), DOLLAR, EXACT (), FIND (), FIXED (), LEFT (), LEN (), LOWER (), MID (), REPLACE (), REPT (), RIGHT (), SEARCH (), TEXT (), TRIM (), UNICHAR (), UPPER (), VALUE () and many more functions.

Date & Time

In that Date and Time function group you can add date and time function such as DATE (), DATEVALUE(), DAY (), DAYS (), HOUR (), MINUTE (), MONTH (), NOW (), SECOND (), TIME (), TODAY (), WEEKDAY (), WORKDAY (), YEAR () and many more functions.

Lookup and Reference

You can add lookup and reference function using lookup and reference group like that ADDRESS (), AREA (), CHOOSE (), COLUMN (), HYPERLINK (), INDEX (), LOOKUP (), MATCH (), OFFSET (), ROW (), TRANSPOSE (), VLOOKUP () and many more functions.

Math and Trig

Using this functions group you can add math functions such as ABS (), ACOS (), SIN (), COS (), BASE (), ATAN (), COSH (), DECIMAL (), EVEN (), ODD (), FACT () and many more functions you can add.

More Functions

In this group there are many functions available Statistical functions, Engineering functions, Cube functions, Information functions, Compatibility functions, Web Functions, so you can use a function which is you want.

You can also read Microsoft Excel 2016 – Arrange

Suchandra Karle

Suchandra Karle is Sr. Software Engineer. Working in Software Company. He is having more than seven years of experience. Other than work he have hobby to write a blog and trading and playing computer games.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top