7. Suppose A1=2, B3 = 4 , what is the value in A9 if typed a. = B3*2/A1/2 + (B3/

Question

7. Suppose A1=2, B3 = 4 , what is the value in A9 if typed

a.   = B3*2/A1/2 + (B3/A1/A1) + A1^2                   (^ is for exponentiation operator)

b. = = IF(B3 < A1, "greater" , if(B3>3, "It is greater than 3" , "It is less than 3" ))

            (hint: write the pseudocode)

8. a. You want to compare the values in A1 with A2, if A1 is larger, you want to say A1 is larger; otherwise, you want to say A1 is smaller. What do you type in A3 to do that?

b. In A9, you want to display " PASS” whenever the value in cell A2 is more than 75, otherwise, "FAIL"

Explanation / Answer

7a.
A9=16

7b.
A9=It is greater than 3

8a.
A3=A1>A2?"A1 is larger":"A1 is smaller"

b.
A9=A2>75?"PASS":"FAIL"

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.