Every formula or function in Excel starts with the following symbol:单项选择题

题目图片
A

a. ,

B

b. (

C

c. :

D

d. =

登录即可查看完整答案

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

类似问题

Read: To be eligible for a scholarship, students must have income less than $40,000 and GPA of 3.75 or higher. What is the formula in E5 that determines if Darrell Hannah is eligible for a scholarship?   This is the correct answer given the information above ...True or False?  =IF(OR(B5<$F$1,D5>$F$2),"Yes","No")

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.  

Which of the following functions should be in C14 in order to calculate the total payments made to level 3 staff?

Every formula or function in Excel starts with the following symbol:

更多留学生实用工具

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