Database
A database is set of ordered and related data stored electronically and make it available in convenient forms.
2021
Aggregate in Excel
Aggregate formula in excel used when cells in column contain value error or hidden rows
Str.isupper
Str.isupper returns True when all element in string are uppercase otherwise returns false.
Str.istitle
l return True when first element of given string is upper case and rest are lower case otherwise false
Count and Counta in Excel
Count formula in excel will count the numbers present in the cell of the selected data whereas counta formula will…
Round in Excel
To round the decimal numbers as many digits in excel we can use round formula in excel. example shown in…
MAX,MIN,LARGE,SMALL Function in excel
MAX formula will return the maximum value present in row or column. N formula will return the minimum values present…
Countif and Sumif in Excel
The countif function count cell value by given criteria and sumif function sum the values of cell by mentioned criteria.