Category: Excel Functions

In this lesson we will learn how the PROPER function works in Excel. PROPER function takes a string as the input and returns a string …

In this lesson we will learn how CHOOSE function works in Excel. The CHOOSE Function is used to choose a value from a list based …

ROUND function is used when you want to return a number rounded to a specified number of digits in Excel.  =ROUND(number, num_digits) number – The …

In this lesson we will learn how MIN function works in excel. The MIN function in excel is used to find the minimum value from …

In this lesson we will learn how MAX function works in excel. The MAX function in excel is used to find the maximum value from …

The LOWER function converts the upper case texts to lower case in Excel.  =LOWER(text) text: This is the string in which you want to convert …

The UPPER function converts the lower case texts to upper case in Excel. =UPPER(text) text: This is the string in which you want to convert …

In Excel we can use RANDBETWEEN() function to generate the random number in a specified range. Like here in cell A2 we have used RANDBETWEEN() …

The CEILING function in Excel rounds up any specific number to the nearest multiple of any given number. It works similar to the MROUND function …

The FLOOR function in Excel rounds down any specific number to the nearest multiple of any given number. It works similar to the MROUND function …