A Tutorial Website with Real Time Examples
Data Science Data Science is the most challenging field of the 21st generation. Every type of IT industry is looking for candidates with knowledge of data science. We are providing the basic and some advanced concepts related to the operation …
Excel MIN() Function The MIN() function in excel returns the smallest or minimum value from the provided numbers, named range or array. It ignores logical values and text. Syntax MIN(Number1,Number2, …) Parameter Number1(required)– This parameter represents the string for which …
Excel COUNTBLANK() Function The COUNTBLANK() function in excel counts the number of blank cells within a range. Syntax
|
0 1 2 |
COUNTBLANK ([value1], [value [2], ...) |
Parameter value1(required)– This parameter represents the first cell in the range. value2, …(optional)– It represents the second, third, and so on …
Excel COUNTA() Function The COUNTA() function counts the number of cells in a range that are not empty. Syntax
|
0 1 2 |
COUNTA([value1], [value [2], ...) |
Parameter value1(required)– This parameter represents the first cell in the range. value2, …(optional)– It represents the second, third and so …
Excel COUNT() Function The COUNT() function counts the number of cells in a range that contain numbers. Syntax
|
0 1 2 |
COUNT([value1], [value [2], ...) |
Parameter value1(required)– This parameter represents the first cell in the range. value2, …(optional)– It represents the second, third, and so on …
Excel AVERAGE() Function The AVERAGE() function returns the average of its arguments, which can be number or names, arrays, or references that contain numbers. It ignores text values and blank cells. Syntax
|
0 1 2 |
AVERAGE(Number1,Number2, ...) |
Parameter Number1(required)– This parameter represents the string …
Excel ROUNDUP() Function The ROUNDUP() function in excel returns a number rounded up to the nearest possible value and away from zero. Syntax
|
0 1 2 |
ROUNDUP(Number, num_digits) |
Parameter Number(required)– This parameter represents the number which you want to round up. num_digits(required)– This parameter …
Excel ROUND() Function The ROUND() function in excel rounds the numbers to specified digits. Syntax
|
0 1 2 |
ROUND(Number,num_digits) |
Parameter Number(required)– This parameter represents the number which you want to round up. num_digits(required)– This parameter represents the number of decimal places to which …
Excel MOD() Function The MOD() function in excel returns the remainder after a number is divided by a divisor Syntax
|
0 1 2 |
MOD(number, divisor) |
Parameter Number(required)– This parameter represents the number which you want to divide. Divisor(required)– This parameter represents the number to …
Excel INT() Function The INT() function in excel is used to round a number down to the nearest integer. It removes decimal points from any number value & return rounded down number value in the cell. Syntax
|
0 1 2 |
INT(Number) |
Parameter Number(required)– …
Excel MAX() Function The MAX() function in excel returns the largest or maximum number from a range of cells. It ignores logical values and text. Syntax
|
0 1 2 |
MAX(Number1,Number2, ...) |
Parameter Number1(required)– This parameter represents the string for which you want to find …
Introduction to Hierarchical Clustering The other unsupervised learning-based algorithm used to assemble unlabeled samples based on some similarity is the Hierarchical Clustering. There are two types of hierarchical clustering algorithm: 1. Agglomerative Hierarchical Clustering Algorithm It is a bottom-up approach. …
Excel Today() Function The today() function returns the serial number of today’s date as per system number of today’s date as per system’s regional settings. Syntax
|
0 1 2 |
Today() |
Parameter NA Category Date & Time Returns This function returns today’s date in …
Cells and Ranges Each cell is identified by its cell address, which is a combination of the column and row on which that cell is situated. A group of cells together are called ‘Range’. When the group of cells you …
What are the formats? Formats are different options that one uses to change the appearance of data (maybe text, number, etc..) in an excel file. They do not change the value of the cell but change the way it appears. …
Notes in Excel Notes are used to include additional information to the cell and explain formulas calculation, any modification made to the cell, providing necessary information on data that is entered or to provide any guidance on data that a …
Selenium web driver-CSS Selector: Tag and Attribute We will locate the web element with the help of Tag and attribute CSS selector in this section of the tutorial. Where Tag and attribute are used to find the web element by …
Read moreSelenium web driver-CSS Selector: Tag and Attribute
Formatting in Excel Formatting in Excel is used to alter and change the appearance of your data in a standardized form. It also helps you to give a professional look to your reports, worksheets, and workbooks. There are many numbers …
Selenium web driver-CSS Selector: Tag and CLASS We will locate the web element with the help of tag and class CSS selector in this section of the tutorials Where Tag and class are used to find the web element by …
Selenium web driver-CSS Selector: Tag and ID We will locate the web element with the help of tag and id CSS selector in this section of the tutorials Where Tag and id are used to find the web element by …