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)

The function LEN() returns the total number of characters in a string

You want to count the number of cells in a column that contain text and are longer than 10 characters. Which function would you use?*COUNTLONGCOUNTTEXTLENCOUNTIFS

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

In Excel, the LEFT function syntax has the [Text] and the [Num_chars] arguments. What are the requirements for the [Num_chars] argument?1) If [Num_chars] is omitted, it is assumed to be 12) [Num_chars] must be greater than or equal to zero3) If [Num_chars] is greater than the length of text, the LEFT function returns all of text4) If [Num_chars] is less than the length of text, the LEFT function returns all of textQuestion 3Select one:a.1,2,4b.2,3c.3,4,1d.1,2,3

How many characters can be typed in a single cell in Excel?A1024B256C32,767D32000