January 19, 2021

## PROPER function in Excel

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 …

## CHOOSE Function in Excel

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 in Excel

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 …

## MIN function in Excel

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 …

## MAX function in Excel

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 …

## LOWER function in Excel

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 …

## UPPER function in Excel

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 …

## RANDBETWEEN function in Excel

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() …

## CEILING function in Excel

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 …

## FLOOR function in Excel

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 …