Suppose you had the following two formulas in two different cells other than cell A1: =FIND("bee",A1) =SEARCH("bee",A1) Without knowing what is the content of cell A1, which of the following statements is/are TRUE? FOR THIS QUESTION ONLY, there may be MORE THAN ONE correct option. You MUST SELECT ALL correct options. Please note that this question asks you to indicate WHICH of the five options are correct. 多项选择题

A

It is possible that each function will return a different non-error value.

B

It is possible that both functions will return the same non-error value.

C

It is possible that both functions will return an error value.

D

It is possible that the SEARCH function will return a non-error value, while the FIND function will return an error value.

E

It is possible that the FIND function will return a non-error value, while the SEARCH function will return an error value.

登录即可查看完整答案

我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。

类似问题

What is the difference between SUBSTITUTE and REPLACE?

Which of the following best describes what the =RAND() function in Excel returns?

SUMIFS and COUNTIFS can return logical outputs.

A 1 Phrase 2 Darren Dahl is the Dean of the Sauder School of Business. Which formula below will return a number (i.e., not #VALUE! or #NAME?)

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！