Question

Which of the following data is considered as "Formula" in Microsoft Excel?

#(50+180)

*( 50+180)

= (50+180)

$(50+1`80)​

Answer 1

Answer:

Enlist and describe different formulas available in Microsoft Excel

Using arithmetic operators in Excel formulas

Operator Meaning Formula example

+ (plus sign) Addition =A2+B2

- (minus sign) Subtraction Negation (reversing the sign) =A2-B2 =-A2 (changes the sign of the value in A2)

* (asterisk) Multiplication =A2*B2

/ (forward slash) Division =A2/B2