你还在为考试焦头烂额?找我们就对了!

我们知道现在是考试月,你正在为了考试复习到焦头烂额。为了让更多留学生在备考与学习季更轻松,我们决定将Gold会员限时免费开放至2025年12月31日!原价£29.99每月,如今登录即享!无门槛领取。

助你高效冲刺备考!

题目

COMM_V 205 101 102 103 2025W1 Exam B1 (Excel) Midterm 2025W1 - Requires Respondus LockDown Browser

多项选择题

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.

查看解析

标准答案

Please login to view

思路分析

Consider the two formulas in two different cells: =FIND("bee",A1) and =SEARCH("bee",A1) We don’t know A1’s content, so we must evaluate what outcomes are possible for these functions. Option 1: It is possible that each function will return a different non-error value. - This can happen if the first occurrence of the substring "bee" appears at different positions for FIND and SEARCH due to case sensitivity. For example, if A1 begins with a capitalized word like "Bee" followed by lowercase "bee" later, FIND (w......Login to view full explanation