Functions must always be preceded by a Quote b Equal sign

Functions must always be preceded by:

a. Quote (\")

b. Equal sign (=)

c. At sign (@)

d. Question mark (?)

The mathematical operation =8.9*4 yields what result?

a. 12.9

b. 8.94

c. 2.225

d. 35.6

Which of the following will the formula =(45*8/(9+27) result in an error message?

a. The formula is not preceded by \'

b. * is not a mathematical operator

c. The formula is not preceded by +

d. There are two left parentheses and only one right parenthese

The Order of Precedence (priority) for a formula that does NOT include parentheses is:

a. addition or subtraction, then multiplication or division, then exponentiation

b. multiplication or division, then addition or subtraction, then exponentiation

c. exponentiation, then multiplication or division, then addition or subtraction

d. exponentiation, then addtion or substration, then multiplication or division

The values of cells C1, C2, and C3 are 3,6 and 9, respectively. What is the result of the formula =C1*C2/C3-1?

a. 0

b. 1

c. 2.25

d. An error message

Solution

Functions must always be preceded by:
a. Quote (\")
b. Equal sign (=)
c. At sign (@)
d. Question mark (?)

Ans: In which language friend ?

The mathematical operation =8.9*4 yields what result?
a. 12.9
b. 8.94
c. 2.225
d. 35.6

Ans: 35.6 : just multiply both number

Which of the following will the formula =(45*8/(9+27) result in an error message?
a. The formula is not preceded by \'
b. * is not a mathematical operator
c. The formula is not preceded by +
d. There are two left parentheses and only one right parenthese

Ans:
   There are two left parentheses and only one right parenthese

The Order of Precedence (priority) for a formula that does NOT include parentheses is:
a. addition or subtraction, then multiplication or division, then exponentiation
b. multiplication or division, then addition or subtraction, then exponentiation
c. exponentiation, then multiplication or division, then addition or subtraction
d. exponentiation, then addtion or substration, then multiplication or division

Ans: c. exponentiation, then multiplication or division, then addition or subtraction

The values of cells C1, C2, and C3 are 3,6 and 9, respectively. What is the result of the formula =C1*C2/C3-1?
a. 0
b. 1
c. 2.25
d. An error message

Ans: b. 1

   C1*C2/C3-1

   C1*C2 = 18
   C1*C2/C3 = 18/9 = 2
   C1*C2/C3-1 = 2-1 = 1