题目
题目

BUSI_V 335 101 102 2025W1 Assignment 2 - More Excel

多项选择题

In cell B2, which of the following formulas would return the position of the “X”?      

选项
A.=FIND(“X”,A2)
B.=SEARCH(“X”,A2)
C.=FIND(“x”,A2)
D.=SEARCH(“x”,A2)
题目图片
查看解析

查看解析

标准答案
Please login to view
思路分析
First, let’s identify what the question asks: which formulas would return the position of the character 'X' in cell A2. Option 1: =FIND(“X”,A2). FIND is a function that returns the position of the first occurrence of a text string within another text string, and it is case-s......Login to view full explanation

登录即可查看完整答案

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

类似问题

True/False: The two formulas =LEFT(RIGHT(A2,5),5) =MID(LEFT(A2,5),1,5) will result in the same answer for any value of cell A2.

You typed TRUE and executed in A1. Then, you typed LOVE and executed in B1. A B 1 TRUE LOVE 2 XXXXXXXXXXX Then, you typed and executed the following formula in A2.  =TRIM(CONCATENATE(TRIM(A1)," ",B1)) where " " is a text with only single blank space. What is the output returned in A2.    

Consider a fictional (and artificial) language called Galitéis. Galitéis and English share many similarities. Every English word that contains "ble" (at the beginning, in the middle, or at the end) will translate to "vel." For example, the English word "doable" will translate to "doavel" in Galitéis. Two other examples: the English word "bleed" will translate to "veled" in Galitéis; the English word "trebled" will translate to "treveld" in Galitéis. You are given the following table and are asked to translate each English word to Galitéis (that is, to complete column B, cells B2:B7). You will type up your formula in cell B2, and then drag the formula down to cell B7. The formula with some redaction looks like this: =XXX(A2, XXX("XXX",A2),3,"XXX")   Complete the following formula for cell B2: Note: Unless absolutely necessary, do NOT leave any spaces in your formula. Do NOT use any additional brackets ( ) in your formula either. =[Fill in the blank], (A2,[Fill in the blank], ("[Fill in the blank], ",A2),3,"[Fill in the blank], ")  

You first wrote the following formula in T2 to indicate if the first game (whose name is in R2) was released earlier than the second game (whose name is in S2): =IF(VLOOKUP(R2,B2:G1301,6,FALSE)<VLOOKUP(S2,B2:G1301,6,FALSE),"YES","NO") When you were testing the formula, you entered the two game names as follows:   Given that Oct 25, 2005 (the released date of Grand Theft Auto: Liberty City Stories) happened before Sep 27, 2016 (the released date of FIFA 17), the T2 should have indicated “YES”, not “NO” as you see above. While you were thinking about it, you realized that the format is MM/DD/YYYY in G column. Therefore, although Oct 25, 2005 (the released date of Grand Theft Auto: Liberty City Stories) is earlier than Sep 27, 2016 (the released date of FIFA 17), ="10/25/2005"<"09/27/2016" would result in FALSE.   Therefore, you cannot use the date format used in G column. You decided to create a new variable called r_date (stored in the L column) by reorganizing characters in the values in column G. You will write a formula in L2 and drag it down to L1301. The formula in L2 that you are asked to complete below will refer to G2 and will produce reorganized released date (i.e., r_data for the game in row 2) that has only 8 characters, each of which can only be 0, 1, 2, 3, 4, 5, 6, 7, 8, or 9. That is, you need to reorganize the existing characters except “/” to create 8-character-long r_date value. =XXX(XXX(G2,XXX),XXX(G2,XXX)&XXX(G2,XXX,XXX)) =[Fill in the blank], ([Fill in the blank], (G2,[Fill in the blank], ),[Fill in the blank], (G2,[Fill in the blank], )&[Fill in the blank], (G2,[Fill in the blank], ,[Fill in the blank], )) With the new column L (remember after typing in L2, you have copied all the way through L1301), if you have also revised the formula in T2 to refer to G column instead of L column as follows: =IF(VLOOKUP(R2,B2:L1301,11,FALSE)<VLOOKUP(S2,B2:L1301,11,FALSE),"YES","NO") You will get the right result for the two games tested previously as shown below: In each blank, you can either use a function name or number.  

更多留学生实用工具

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