My Excel Lab 3 - IF/Nested IF/OR/AND

=IF(B9>=18,"Adult",IF(B9>12,"Teen","Child")) is a formula used in excel sheet. B12 Cell has value 14, then what formula will enter in that cell

• Teen

• Child

• Adult

• None of the above

AND function will check out for all the conditions applied, if all are true then only the true value of formula will reflect

• True

• False

OR function will check out for all the conditions applied, if all are true then only the true value of formula will reflect

• True

• False

In Nested IF, multiple conditions can be applied.

• True

• False

If function is a logical formula which checks the condition and basis that it returns true or false value

• True

• False