Question 6A data analyst wants to know how many cells from E2 through cell E100 contain numbers below 299. Which of the following COUNTIF statements should they use? 1 point=COUNTIF(E2:E100,"<299")=COUNTIF(E2:E100,">=299")=COUNTIF(E2:E100, >299)=COUNTIF(E2:E100, <=299)

Question 6A data analyst wants to know how many cells from G2 through cell G100 contain only numbers below 500. Which of the following COUNTIF statements should they use? 1 point=COUNTIF(G2:G100,"<500")=COUNTIF(E2:E100, <=500)=COUNTIF(G2:G100, >500)=COUNTIF(G2:G100,">=500")7.Question 7

Question 5A data professional in the trucking industry calculates the number of spreadsheet rows that contain the SKU value BK09876. Which function do they use?1 point=COUNTIF(BK09876=G2:G30)=COUNTIF(G2:G30,“BK09876”)=COUNTIF(G2:G30,BK09876)=COUNTIF(G2:G30,“=BK09876”)

Which of the following functions would you use to calculate the value of cell C18.(1)Group of answer choices=SUM=COUNT=COUNTIF=COUNTA

A data professional in the trucking industry calculates the number of spreadsheet rows that contain the SKU value BK09876. Which function do they use?1 point=COUNTIF(G2:G30,BK09876)=COUNTIF(G2:G30,“BK09876”)=COUNTIF(BK09876=G2:G30)=COUNTIF(G2:G30,“cell=BK09876”)

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