Question

What is operator?Mention various types of operators are there in MS-Excel?

Answer 1

Operators in Excel specifies the type of calculation to be performed on a given set of values. obviously not restricted to numeric values only, we can use operators over different data types other than numeric

Basically, there are 4 crude types of operators in Excel, mentioned as below

1. Arithmetic Operators.

2. Logical/Comparison Operators.

3. Text Concatenation Operator.

4. Reference Operators.