Question 23(3 points)

Saved

Assuming the following statement is correct without any error, the statement will print "Yes" when the MATCH function succeeds (i.e., returns a valid value).

=IF(ISNA(MATCH(...)), "Yes", "No")

Question 23 options:

TrueFalse

Question 24(2 points)

Saved

It is possible to define an IF statement inside another one.

Question 24 options:

TrueFalse

Question 25(3 points)

Saved

If B5 stores "hello world", the following statement extracts "hello ". (Note there is a space after "hello" in "hello ".)

=LEFT(B5, FIND(" ", B5)-1)

Question 25 options:

1) True2) False

Question 26(3 points)

Saved

The following statement replaces every space in cell B5 with @ sign.

=SUBSTITUTE(B5, " ", "@")

Question 26 options:

1) True2) False

Question 27(3 points)

Saved

One difference between SUBSTITUTE and REPLACE is that the REPLACE function requires you to specify number of characters to replace.

Question 27 options:

1) True2) False

Question 28(3 points)

Saved

The following MID function returns a string containing the 3rd character to the 6th character from cell B5.

=mid(B5, 3, 6)

Question 28 options:

1) True2) False