Scribd
Upload
4 views4 pages

Da Prac2 Rajendra

This document outlines various Excel functions including ISBLANK, COUNTBLANK, UNIQUE, and IF for identifying outliers. It provides formula syntax and examples for each function, demonstrating their applications in managing employee data. Additionally, it explains the steps to use the REMOVE DUPLICATES command to eliminate repeated entries in a dataset.

Uploaded by

Prasad Chauke
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views4 pages

Da Prac2 Rajendra

This document outlines various Excel functions including ISBLANK, COUNTBLANK, UNIQUE, and IF for identifying outliers. It provides formula syntax and examples for each function, demonstrating their applications in managing employee data. Additionally, it explains the steps to use the REMOVE DUPLICATES command to eliminate repeated entries in a dataset.

Uploaded by

Prasad Chauke
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Module 2 : Excel Functions Rajendra…(05)

1. ISBLANK

Used to check whether a cell is empty or not.

Formula Syntax:

=ISBLANK(cell)

Example:
In the table below, we check whether a particular employee’s Rating cell is blank. If the cell is empty, the function
returns TRUE; otherwise, FALSE.

Input : it checks whether H11 cell


is empty returns TRUE; or
otherwise, FALSE
OUTPUT

2. COUNTBLANK

Used to count the number of empty (blank) cells in a given range.

Formula Syntax:

=COUNTBLANK(range)

Example:
In the table below, we count how many employee records have missing values in the Rating column.

Input : it checks whether how


many cell are unfilled from Rating OUTPUT
column
Module 2 : Excel Functions Rajendra…(05)

3. UNIQUE

Used to extract unique (non-repeated) values from a list.

Formula Syntax:

=UNIQUE(range)

Example:
In the table below, we use this function to get a list of unique departments from the employee data.

get a list of unique


departments OUTPUT

4. Identifying / Heading / Labeling Outlier


An outlier is a value that is significantly higher or lower than other values in the dataset Method (using IF
condition):
We compare values with a limit (for example, salary > 100000).

Formula Syntax:

=IF(condition, "Outlier", "Normal")

Example:
In the table below, we identify employees whose salary is greater than 100000 and mark them as ‘Outlier’;
otherwise, ‘Normal

If G2 salary is greater than 100000 and


mark them as Outlier, otherwise OUTPUT
Normal.
Module 2 : Excel Functions Rajendra…(05)

5. REMOVE DUPLICATES COMMAND

Used to delete repeated data entries.

Steps:

1. Select the data range

2. Go to Data Tab

3. Click Remove Duplicates

4. Choose columns

5. Click OK

Example:
If employee records appear twice, this command keeps only one record. In this case, EmpID 101 was duplicated,
so one entry was removed.

OUTPUT :
Module 2 : Excel Functions Rajendra…(05)

You might also like