Question

operator is used to calculate percent ​

Answer 1

Answer:

The percentage sign (%) is the modulo operator. It divides two numbers and calculates the remainder left over, if any. It's commonly used to find out if a number is odd or even.

Answer 2

The formula

Produces

Explanation

= "1"+"2"

3

When you use a plus sign (+), Excel expects numbers in the formula. Even though the quotation marks mean that "1" and "2" are text values, Excel automatically converts the text values to numbers.

= 1+"$4.00"

5

When a formula expects a number, Excel converts text if it is in a format that would usually be accepted for a number.

= "6/1/2001"-"5/1/2001"

31

Excel interprets the text as a date in the mm/dd/yyyy format, converts the dates to serial numbers, and then calculates the difference between them.

=SQRT ("8+1")

#VALUE!

Excel cannot convert the text to a number because the text "8+1" cannot be converted to a number. You can use "9" or "8"+"1" instead of "8+1" to convert the text to a number and return the result of 3.

= "A"&TRUE

ATRUE

When text is expected, Excel converts numbers and logical values such as TRUE and FALSE to text.Answer:

Explanation: