MS Excel Function Category

MS Excel has many built-in functions that we can use in formulas. To view all functions by category, select Formulas tab»Insert Function. Then the Insert Function dialog box appears, from which we can select a function.

MS Excel Function

Features by Category:

Let’s take a look at some of the built-in functions in MS Excel.

text function

LOWER – Converts all characters in the provided text string to lowercase

UPPER – Converts all characters in the provided text string to uppercase

TRIM – removes duplicate spaces, as well as spaces at the beginning and end of a text string

CONCATENATE – Concatenates two or more text strings together.

LEFT – Returns the specified number of characters from the beginning of the provided text string.

MID – Returns the specified number of characters from the middle of the provided text string

RIGHT – Returns the specified number of characters from the end of the provided text string.

LEN – Returns the length of the provided text string

FIND – Returns the provided character or the position of the text string from the provided text string (case sensitive).

date time

DATE – Returns the date from the user-supplied year, month, and day.

TIME – Returns the time from the user-supplied hours, minutes, and seconds.

DATEVALUE – Converts a text string showing a date to an integer representing a date in Excel datetime code.

TIMEVALUE – Converts a text string showing time to a decimal representing time in Excel.

NOW – Returns the current date and time.

TODAY – Returns today’s date.

statistics

MAX – Returns the maximum value from the provided list of numbers.

MIN – Returns the minimum value from the provided list of numbers.

AVERAGE – Returns the average of the provided list of numbers.

COUNT – Returns the number of numeric values ​​in the provided set of cells or values.

COUNTIF – Returns the number of cells (in the provided range) that satisfy the given criteria.

SUM – Returns the sum of the provided list of numbers

logical

AND – Tests a number of user-defined conditions and returns TRUE if all conditions evaluate to TRUE, otherwise returns FALSE

OR – Tests a number of user-defined conditions and returns TRUE if any condition evaluates to TRUE, otherwise returns FALSE.

NOT – Returns the logical inverse of the user-supplied logical value or expression, i.e. FALSE if the supplied argument is TRUE and TRUE if the supplied argument is FAL

Math and Trigonometry

ABS – Returns the absolute value (i.e. modulus) of the provided number.

SIGN – Returns the sign (+1, -1 or 0) of the provided number.

SQRT – Returns the positive square root of the given number.

MOD – Returns the remainder from the division between two provided numbers.

Related:

Buy Windows 10 Pro CD Key| buy cheap

Buy Premium US Edu Email Account Outlook

Income and Expenses Excel Sheet Template

Microsoft Office 2019 Home and Business for

Leave a Reply

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