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

The correct answer is d.1,2,3.

Here's why:

1. If [Num_chars] is omitted, it is assumed to be 1: This is correct. If you don't specify a number, Excel will assume you want to extract just the first character.

2. [Num_chars] must be greater than or equal to zero: This is also correct. You can't extract a negative number of characters.

3. If [Num_chars] is greater than the length of text, the LEFT function returns all of text: This is correct as well. If you ask for more characters than the text string contains, Excel will simply return the entire string.

4. If [Num_chars] is less than the length of text, the LEFT function returns all of text: This is incorrect. If you specify a number less than the length of the text, Excel will return only that number of characters from the start of the string.