Question

In the LEFT function in Excel, what is the purpose of the num_characters?

Select one:

a. How many characters to the left of a word to extract.

b. It counts the total number of characters in a text string.

c. None of the options listed are correct.

d. It counts how many characters in a cell are numbers.

ANN stands for:

Select one:

a. Administration Neural Network

b. Add Null Neuron

c. Artificial Neural Network

Answer 1

Here is the format of the LEFT function -

LEFT(text,num_characters)

The num_characters field accepts the argument of a number. This number represents how many characters from the text are to be extracted starting from the left side. Example -

LEFT("Hello",3) - This would give the first three characters of "Hello", that is Hel.

So the answer would be option a - How many characters to the left of a word to extract.

ANN stands for Artificial Neural Network.  Artificial Neural Network is defined as a computational model or an information processing paradigm which has been inspired by the nervous system. It is a non-linear statistical data modeling tool. ANN consists of many neurons and all of them are connected to other neurons as well. So it is a very complex model in which each neuron is a node.

Advantages of ANN-

They learn from themselves and their output is not only limited to the input which has been provided to them.

Multiple tasks can be performed in parallel.

Some of the applications of ANN are- image processing and speech recognition.

ALL THE BEST !!