Assignment of removing duplicate data and if condition formula

Remove duplicate data

1. Go to data option  in menu bar.
2. Select the data in which you want to remove duplicate items.
3. select the duplicate remove option which is situated next to the columns.
Then dialogue box will appear which is shown following below :-

OUTPUT:-

If condition formula

In Excel, you can use the IF function to perform conditional logic. The basic syntax is:
=IF(logical test, value_if_true, value_if_false)

• logical test: The condition you want to evaluate (e.g., A1 > 10).

• value_if_true: The value that will be returned if the condition is true.

• value_if_false: The value that will be returned if the condition is false.

Example 1:
=IF(A1 > 10, "Yes", "No")
If you want to check if the value in cell A1 is greater than 10, and return "Yes" if it is, or "No" if it isn't:

Example 2:

If you want to check if the value in A1 is greater than 50, and return "High" if true, or "Low" if false, you can do this:
=IF(A1 > 50, "High", "Low")

output