Operator
An operator is a symbol used in a formula to specify the nature of the calculation, and on the basis of which the function or formula is implemented. There are four different types of operators used in Excel.
Arithmatic Operators
Mathematical operators are used to perform mathematical operations such as addition, subtraction, multiplication, division, percentage.
Comparison Operators
This operator compares between two values and returns true or false as the result.
Reference Operator
The reference operator adds the range of the cell to be counted.
Text concatenation operator
This operator joins two text strings together.
Autosum
Autosum is used as a shortcut to find the total of all colors. It can be selected from the Standard toolbar. Using Autosum, you can automatically enter the sum of a range of cells, where you have to enter the sum. By selecting the cell, Microsoft sums the values of the range according to a formula.
