题目
题目

COMM_V 205 101 102 103 2025W1 Assignment B1 (Excel)

多重下拉选择题

PlayStation 4, Xbox One, and Nintendo Switch are the major consoles of 2017. Among 100 game entries from the 2017’s top 100 chart, you want to find the number of games that are designed to work on consoles other than the popular three (i.e., PS4, XOne, and NS). =COUNTIFS(XXXXXXXX"=2017") =COUNTIFS( [ Select ] D2:D1301,"<>PS4&XOne&NS",A2:A1301, D2:D1301,OR("PS4","XOne","NS"),A2:A1301, D2:D1301,AND("PS4","XOne","NS"),A2:A1301, D2:D1301,"OR(PS4,XOne,NS) ",A2:A1301, D2:D1301,"OR(PS4,XOne,NS) ",A2:A1301, IF(D2:D1301<>AND("PS4","XOne","NS"),1,0), A2:A1301, IF(D2:D1301<>OR("PS4","XOne","NS"),1,0), A2:A1301, AND(D2:D1301,"<>PS4",D2:D1301,"<>XOne",D2:D1301,"<>NS"),A2:A1301, OR(D2:D1301,"<>PS4",D2:D1301,"<>XOne",D2:D1301,"<>NS"),A2:A1301, D2:D1301,"<>PS4",D2:D1301,"<>XOne",D2:D1301,"<>NS",A2:A1301, D2:D1301,"<>PS4&<>XOne&<>NS",A2:A1301, D2:D1301,"<>PS4"&"<>XOne"&"<>NS",A2:A1301, "=2017")

查看解析

查看解析

标准答案
Please login to view
思路分析
The question asks: among 100 game entries from 2017's top 100 chart, how many games are designed to work on consoles other than the popular three (PS4, XOne, NS)? This implies a filter on year = 2017 and a criterion that the platform is not PS4, not XOne, and not NS. Option provided: D2:D1301,"<>PS4",D2:D1301,"<>XOne",D2:D1301,"<>NS",A2:A1301, This expression attempts to count rows where the value in D2:D1301 is not equal to PS4, not equal to XOne, and not equal to NS, with A2:A1301 presumably holding the year (2017) filter. Why this could be considered plausible: It uses a three-way non-equality check on the platform field, which matches the intuitive i......Login to view full explanation

登录即可查看完整答案

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

类似问题

You are interested in determining the number of game titles (i.e., entries) that made it to the top 100 list for a specific console (as specified in cell V2) and during a particular year (as indicated in cell W2). Please complete the formula in X2 which would use the data in Alex's excel worksheet.   Again, the formula should return the number of game entries which were designed for a given console (entered in V2) and made it to the top 100 list in a given year (entered in W2). =XXX(XXX,V2,XXX,XXX) In each blank, you can only use a function name, cell reference, or array reference. Don't leave any space in your formula. =[Fill in the blank], ([Fill in the blank], ,V2,[Fill in the blank], ,[Fill in the blank], )

    Steven’s Hardware and Furniture Store is going out of business. He is looking to sell all the remaining items that he still has left. Steven has a way of organizing products in his store, using the letter A to indicate smaller products and B for larger-sized products. Each kind of products can be classified as either type A or type B. There is no other type.             Tony owns a recycling company that processes smaller-sized items. He has contacted Steven looking to purchase Steven’s type-A products, but is only willing to purchase items with a high inventory status. He has set up the Excel table above to list different kinds of products, their types, inventory status, and inventory levels. Each row represents a different kind of products Steven has in his inventory. True or False: Tony can use the following formula to determine the number of different kinds of products he can purchase from Steven.     =COUNTIFS(B2:B8,"<>B",C2:C8,"High")

Study the screen shot above. Aaron wishes to count all the refrigerated items that have now expired as of Today's date as shown in B1. Which of the formulas below would need to be entered into B11 to show this?

Jake has a list of tins of paint that have been sold in his store. There are several different colours of paint. The paint is sold in small, medium and large sized tins. What formula could you use in the shaded cell to show the number of large tins of red paint sold?

更多留学生实用工具

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