题目
题目

FNDN Computing for Business 2025 STD O1

单项选择题

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?

选项
A.a. =COUNTIFS(B5:B9,"<"&B1,C5:C9,"Refrigerator")
B.b. =IFS(B5:B9,">"2/11/2021,C5:C9,"Refrigerator")
C.c. =COUNTIFS(B5:B9,"<B1",C5:C9,"Refrigerator")
D.d. =COUNTIF(B5:B9,"<"&B1,C5:C9,"Refrigerator")
题目图片
查看解析

查看解析

标准答案
Please login to view
思路分析
The scenario asks which formula in B11 would count refrigerated items whose expiry date is earlier than Today's Date (B1). Option a: =COUNTIFS(B5:B9,"<"&B1,C5:C9,"Refrigerator") - This uses COUNTIFS with two criteria ranges: B5:B9 for dates and C5:C9 for storage type. The first criterion "<"&B1 checks if the expiry dat......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")

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?

更多留学生实用工具

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