Excel (Program Features and Functions)

LogicalNOT / AND / OR

100

What does =NOT(4<2) return?

TRUE, because 4<2 is false.

200

=AND(A1<10,B1>3) with A1=8, B1=2 → result?

FALSE, because B1>3 is false.

300

=OR(A1>100,B1<0,C1=50) with A1=90, B1=5, C1=50 → result?

TRUE, because C1=50 is true.

400

=AND(OR(A1=1,B1=2),NOT(C1=3)) with A1=1, B1=5, C1=3 → result?

FALSE, because NOT(C1=3) is false.

IF function

100

IF(7>10,"Yes","No") → result?

No, because 7>10 is false.

200

=IF(B1<50,"Low","High") with B1=75 → result?

High, because B1<50 is false.

300

=IF(OR(A1>10,B1<5),"Pass","Fail") with A1=8, B1=3 → result?

Pass, because B1<5 is true.

400

=IF(AND(A1>5,B1<10),IF(C1=100,"Yes","No"),"Fail") with A1=6, B1=9, C1=50 → result?

No, because AND is true but C1=100 is false.

Math Operators

100

What is =10/2?

5, because 10 divided by 2 is 5.

200

What is =MOD(17,5)?

2, because 17 ÷ 5 leaves remainder 2.

300

What is =5^3+MOD(20,6)?

125+2 = 127.

400

What is =(10^2)/(5*2)?

100 ÷ 10 = 10.

Rounding Functions

100

What is =ROUND(2.718,2)?

2.72, rounded to 2 decimal places.

200

=ROUNDUP(4.321,1) → result?

4.4, rounded up to 1 decimal place.

300

=ROUNDDOWN(9.876,2) → result?

9.87, rounded down to 2 decimals.

400

=ROUND(123.456,-1) → result?

120, because rounding to -1 digits rounds to nearest 10.