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 function enables a data professional to count the total number of spreadsheet values within a specified range?1 pointSUMWHOLETOTALCOUNTA

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

The total number of rows in a worksheet? a1,048,576 b65,535 cUnlimited d1,068,576

Question 2A data analyst works with a spreadsheet containing project plan IDs that must be exactly 25 characters long. To ensure accuracy, they use a function to count the number of characters in cell E50. What is the correct syntax of the function?1 point=LEN(25, E50)=LEN(E50)=LEN(25)=LEN(E50, 25)