Question

"long answer question" Define operators and their different categories in excel.

Answer 1

heya friend..
.
here is your answer ..
.
An operator, in computer programing, is a symbol that usually represents an action or process. These symbols were adapted from mathematics and logic. An operator is capable of manipulating a certain value or operand. 

Operators are the backbone of any program and they are used for everything from very simple functions like counting to complex algorithms like security encryption.



THE TYPES OF OPERATORS ARE :

*Arithematical Operators (Binary): The operators that can perform simple arithematical calculation such as addition(+), substraction(-), multiplication(*) etc are known as arithematical operator.

*Relational Operator: The operators that are used to compare the expression are called relational operation. less than(<), greater than(>), less than or equal to(<=), not equal to(!=) are some of the examples of relational operator. *Logical Operator: The operators that are used to give logical value either true or false are called logical operator. logical AND(&&), logical NOT(!) are the example of logical operator.

*Unary Operator: The operators that are used to increase or decrease the value by one is called unary operator. ++, -- are the example of this operator

*Assignment Operator: It is used to assign the value of expression into variable. This operator is denoted by =.

*Short Hand Operator: It is the Combination of Arithematic and Assignment operators. At first it perform arithematic operator then assignment operator. example: +=, -=, *= etc.

*Conditional: It is written is the form, exp1?statement1:statement2; where, the value of exp1 is evaluated. If it is true statement1 is executed other statement2 is exicuted.

*Bitwise Operator: It is used to Perform operation in bit level, that is used for logical operations in bit level.

*Comma Operator: This operator is used to join two expression. This operator is denoted by (,)
.
.
plzz mark me as the brainliest..
.
follow me for more help !!!
.

;-)