Being a student friendly software company, Redmond-based Microsoft Inc. has always been of help to the students. In Office Excel, the World reknowned software, Microsoft has provided the best and highly complicated calculating functions, related to mathematical, statistical & other scientific functions. By this action, the students are equipped to solve the highly complex scientific, financial and social sciences problems with the help of the hundreds of functions.
Starting from the simple to the highly technical functions, there are 14 sets of formulas and functions which can be applied in the Excel worksheets to achieve marvelous results and findings of the studies.
We have tried to explore the list of the functions which can be worked upon in the Excel worksheet, with the help of the step by step tutorial.
Tutorial
1: Press / Click the ‘AutoSum’ button in the top-right command ribbon of the Microsoft Excel 2016. It will open up a popup menu.
2: In the popup menu, see; there are 5 following items:
- Sum
- Average
- Count Numbers
- Max
- Min
- More Functions ….
3: In the popup menu, press / click ‘More Functions …’. It will open up a prompt, named; ‘Insert Function’.
4: In the prompt, press / click ‘Or select a category’ to open up a popup of the long list 14 following sets of functions:
- All
- Financial
- Date & Time
- Math & Trig
- Statistical
- Lookup & Reference
- Database
- Text
- Logical
- Information
- Engineering
- Cube
- Compatibility
- Web
5: To see a complete list of all the calculation functions in all the sets, press / click ‘All’ in the popup. Or scroll down to see all the calculating function in the section ‘Select a function:’. Here, are 154 total functions which are available in this popup which can be applied to work with different types of calculations and other functions. 
A Complete List of All Functions, Available in Excel 2016
- ABS
- ACCPRINT
- ACCPRINTM
- ACOS
- ACOSH
- ACOT
- ACOTH
- ADDRESS
- AGGREGATE
- AMORDEGRC
- AMORLINC
- AND
- ARABIC
- AREAS
- ASIN
- ASIMH
- ASTAN
- ATAN2
- ATANH
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- BATHTEXT
- BASE
- BESSELI
- BESSEU
- BESSLK
- BESSELY
- DIST
- INT
- BETADIST
- BETAINV
- BIN2HEC
- BINHEX
- BIN2OCT
- DIST
- DIST.RANGE
- BINOMDIST
- BITAND
- BITLSHIFT
- BITOR
- BITSHIFT
- BITXOR
- CEILING
- MATH
- CELL
- CHAR
- CHIDIST
- CHINV
- DIST
- DIST.TR
- INV
- INV.RT
- TEST
- CHITEST
- CHOOSE
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COMBIN
- COMBINA
- COMPLEX
- CONCATENATE
- CONFIDENCE
- NORM
- T
- CONVERT
- CORREL
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COUNTDAYBS
- COUPDAYS
- COUPDAYSYNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVAR
- P
- S
- CRITBINOM
- CSC
- CUBEKPIMEMBER
- CUBEMEMBER
- CUBEMEMBERRPPERTY
- CUBERANKEDMEMBER
- CUBESET
- CUBESETCOUNT
- CUBEVALUE
- CUMPPMT
- CUMPRINC
- DATE
- DATEVALUE
- DAVERAGE
- DAYS
- DAYS360
- DB
- DCOUNT
- DCOUNTA
- DDB
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DECIMAL
- DEGREES
- DELTA
- DEVSQ
- DGET
- DISC
- DMAX
- DMIN
- DOLLAR
- DOLLARDE
- DOLLARFR
- DRPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DURATION
- DVAR
- DVARP
- EDATE
- EFFECT
- ENFECT
- ENCODEURL
- EOMONTH
- ERF
- PRECISE
- ERFC
- PRECISE
- TYPE
- TYPE
- EVEN
- EXACT
- EXP
- DIST
- EXPONDIST
- DIST
- DIST.RT
- INV
- INV.RT
- TEST
- FACT
- FACTDOUBLE
- FALSE
- FDIST
- FILTERXMIL
- FIND
- FINV
- FISHER
- FISHERINV
- FIXED
- FLOOR
- MATH
- FORECAST
- ETS
- ETS.CONFINT
- ETS.SEASONALITY
- LINEAR
- FORMULATEXT
- FREQUENCY
- FTEST
- FV
- FVSCHEDUL
- GAMMA
- DIST
- INV
- GAMMADIST
- GAMMAINV
- GAMMALN
- PRECISE
- GAUSS
- GCD
- GEOMEAN
- GESTEP
- GETPIVOTDATA
- GROWTH
- HARMEAN
- HAX2BIN
- HEX2DEC
- HEX2OCT
- HLOOLUP
- HOUR
- HYPERLINK
- DIST
- HYPGEOMDIST
- IF
- IFERROR
- IFNA
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLIN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
- INDEX
- INDIRECT
- INFO
- INT
- INTERCEPT
- INTRATE
- IPMT
- IRR
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISFORMULA
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISOWEEKNUM
- ISPMT
- ISREF
- ISTEXT
- KURT
- LARGE
- LCM
- LEFT
- LEN
- LINEST
- LN
- LOG
- LOG10
- LOGEST
- DIST
- INV
- LOGNORMDIST
- LOOKUP
- LOWER
- MATCH
- MAX
- MAXA
- MDETERM
- MDURATION
- MEDIAN
- MID
- MIN
- MINA
- MINUTE
- MINVERSE
- MIRR
- MMULT
- MOD
- MODE
- MULT
- SNGL
- MONTH
- MROUND
- MULTINOMIAL
- MUNIT
- N
- NA
- DIST
- NEGDINOMDIST
- NETWORKDAYS
- INTL
- NOMINAL
- DIST
- INV
- S.DIST
- S.INV
- NORMDIST
- NORMINV
- NOT
- NOW
- NPER
- NPV
- NUMBERVALUE
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ODD
- OFFFPRICE
- ODDFYIELD
- OLDLPRICE
- ODDLYIED
- OFFSET
- OR
- PDURATION
- PEARSON
- PERCENTILE
- EXC
- INV
- PERCENTRANK
- EXC
- INC
- PERMUT
- PERMUTATIONA
- PHI
- PI
- PMT
- POISSON
- DIST
- POWER
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PROB
- PRODUCT
- PROPER
- PV
- QUARTILE
- EXC
- INC
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- RANK
- AVG
- EQ
- RATE
- RECEIVED
- REPLACE
- REPT
- REPT
- RIGHT
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- ROW
- ROWS
- PRI
- RSQ
- RTD
- SEARCH
- SEC
- SECH
- SECOND
- SERIESSUM
- SHEET
- SIGN
- SIN
- SINH
- SKEW
- P
- SLN
- SLOPE
- SMALL
- SQRT
- SQRTPI
- STANDARDIZE
- STDEV
- P
- S
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- SUBSITUTE
- SUTOTAL
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- SYD
- T
- DIST
- DIST.RT
- INV
- INV.2T
- TEST
- TAN
- TANH
- TBILLPRICE
- TBILLYIELD
- TDIST
- TEXT
- TIME
- TIMEVALUE
- TINV
- TODAY
- TRANSPOSE
- TREND
- TRIM
- TRIMMEAN
- TRUE
- TRUCN
- TTEST
- TYPE
- UNICHAR
- UNICODE
- UPPER
- VALUE
- VAR
- P
- S
- VARA
- VARP
- VARPRA
- VDB
- VLOOKUP
- WEBSERVICE
- WEEKDAY
- WEEKNUM
- WEIBULL
- DIST
- WORKDAY
- INTL
- XIRR
- XNPV
- XOR
- YEAR
- YEARFRAC
- YIELD
- YIELDDISC
- YIELDMAT
- ZTEST