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. Multiple choice
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.
Log in for full answers
We've collected over 50,000 authentic original questions and detailed explanations from around the globe. Log in now and get instant access to the answers!
Similar Questions
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?)
More Practical Tools for Students Powered by AI Study Helper
Making Your Study Simpler
Join us and instantly unlock extensive past papers & exclusive solutions to get a head start on your studies!