题目
题目

MUF0051 ICT Unit 1 - Semester 1, 2025 Data analysis test

单项选择题

Which of the following functions should be in D11 in order to calculate the number of houses that have 2 or more inhabitants?

选项
A.a. COUNTIFS($B$2:$B$7,"House",">=2")
B.b. =COUNTIFS($B$2:$B$7,"House",$C$2:$C$7,">=2")
C.c. =COUNTIF($B$2:$B$7,"House",$C$2:$C$7,">=2")
D.d. COUNTIFS($B$2:$B$7,"House",$C$2:$C$7,">=2")
题目图片
查看解析

查看解析

标准答案
Please login to view
思路分析
We’re asked which function should be in D11 to count how many rows have a House and an Inhabitants value of 2 or more. Option a: COUNTIFS($B$2:$B$7,"House",">=2"). This is missing the second criterion for the inhabitants column (the range for C and the cond......Login to view full explanation

登录即可查看完整答案

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

类似问题

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")

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?

更多留学生实用工具

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