Question

what are the operators used in ms excel to perform following tasks?illustrate the answer with example (a) find a difference between two numbers (b) calculate discount@10% of bill amount (c) to join two words (d) to calculate power e.g. 5^5 (e) perform division of two numbers

Answer 1

Arithmetic - to perform basic mathematical operations.

Comparison (logical) - to compare values.

Concatenation - to join text values into a single string.

Reference - to make rages and separate arguments in Excel functions.

Answer 2

Answer:

The precedence of operators determines which operator is executed first if there is more than one operator in an expression. Let us consider an example: int x = 5 - 17* 6; ... Then the expression involving - is evaluated as the precedence of - is higher than that of = .