Swathy

Select the cell(s) you want to create a rule for.
Select Data >Data Validation .
On the Settings tab, under Allow , select an option: …
Under Data , select a condition.
Set the other required values based on what you chose for Allow and Data .

Excel, functions are always available to solve any operations. In this case, you can use a combination of SUM, IF and COUNTIF functions to count unique values in Excel.

Relational operators often are used with conditional operators to construct more complex decision-making expressions. conditional logical operators execute the second operand only if necessary.

Select Share.
Select permissions and then Apply.
Add people.
Type a message if you like.
Select Send.

charts are used to make a graphical representation of any set of data.

characters that represent actions (bitwise operations) to be performed on single bits.

A dialog which allows your application to get input from the user. UserForms are used throughout all Windows applications. Excel itself has a large number of UserForms.

special kind of data type defined by the user. It consists of constant integrals or integers that are given names by a user. Array, pointers, struct, and union are the derived data types in C.

MS Office is a suite of programs. MS Word is one of the programs included in MS Office. It also includes Excel, Powerpoint and Outlook.

Visual Basic for Applications is a computer programming language developed and owned by Microsoft.
Allows users to access functions beyond what is available in the MS Office applications.