While making a spreadsheet for a delivery service, you notice you need a way to keep track of the number of items that are perishable and are still pending delivery.ABCD1ProductCategoryAmountStatus2Fresh ProducePerishable$70Delivered3TelevisionAppliance$500Delivered4Milk TeaPerishablePending5Cellular phoneAppliance$1000PendingGiven the table above, what will this function return?=COUNTIFS (D2:D5, "Pending", B2:B5, "Perishable")1 pointIt will give an error. The statement should be=COUNTIFS (D2:D5 = "Pending", B2:B5 = "Perishable") .It will return 1. given there is only one item that is both pending and is perishable.It will return 3, given the condition for “Pending” is first in the function, it takes it as a priority.

ou have an Excel file of 50 orders placed by customers. There are three columns:Column A stores whether a customer is a repeat customer or not. It can only be Yes or NoColumn B stores whether an order was placed on a weekend. It can also only be Yes or NoColumn C stores the order amountWhich of the following is best suited to calculate: the total order amount placed by all repeat customers on a weekend?SUMSUMIFIFSUMSUMIFS

Which function in Excel tells how many numeric entries are thereNUMCOUNTSUMCHKNUM

Your client, Fatima, is organizing an End of Year party for funders and has a Google Sheet that contains a list of 100 attendees. Each person is listed in a row from rows 1-100. In column B, it indicates whether the person in that row is a "VIP" or "Non-VIP". Fatima wants to know how many total "VIP"s are on the sheet to prepare special arrangements for them. What formula would you put in the cell where you want this information?=COUNTB(B1:B100,“VIP”)=COUNTIF(B1:B100,“VIP”)=COUNT(B1:B100,“VIP”)=COUNTA(B1:B100,“VIP”)I don't know

Which function enables a data professional to count the total number of spreadsheet values within a specified range?1 pointSUMWHOLETOTALCOUNTA

What Excel formula is =DGET similar to, yet a bit more involved than?=VLOOKUP=SUM=COUNT