Question

What will be the output of the following MS-Excel function.
a) MID ("COMPUTER",4,3)​

Answer 1

The output of the MS-Excel function =MID("COMPUTER",4,3)​ will be PUT

Explanation

Syntax of MS-Excel function MID

MID(string, starting_at, extract_length)

MID is an Excel function that returns a part of a string.

As seen in the syntax of MID Excel function

1. At the place of string we write the string from which we have to extract a part of it.

2. At the place of starting_at we write the index of the string from where we have to start extracting the part of the string.

3. At the place of extract_length we mention the length of the part of string to extract.

In String the first character has the index 1

Now, as we see in string COMPUTER.

Letter C which is at first has index 1 and it is mentioned to start extracting the part of string from index 4 and at index 4 there is P so, it starts extracting from there and the string which this MID function will return should have length 3 and as the extraction has started from P we can assume it to be 1 and then for U it's 2 and for T it's 3 and these are the letters which make the total length of extracted string to be 3 and that's how the output is PUT

Extra Information

In Excel, columns are named as A, B, C, D, E, F, and so on.

In Excel, rows are named as 1, 2, 3, 4, 5, 6, and so on.

Cells in an Excel sheet are made with intersections of rows and columns.

Cell Address is used to identify cell on an Excel Sheet and Cell Address comprises of a letter and a number. The letter shows the column and the number shows the row.

Example

A1

In this, it is the cell that is present in column A and row 1.

D6

In this, it is the cell that is present in column D and row 6.

Function is a predefined formula that allows users to perform mathematical, statistical, and logical operations.

There are various functions in Microsoft Excel some of them are:

1. SUM

2. AVERAGE

3. COUNT

4. IF

5. MAX

6. MIN

There are two formats by which you can apply Excel functions on cells.

1. Name of Function (Range of Cells i.e. Starting Cell : Ending Cell)

Example

=AVERAGE(A1:A3)

2. Name of Function (Each Cell Address separated with a comma(,))

Example

=AVERAGE(A1,A2,A3)

Example

Suppose you want to add values present in cells from A1 to A5 and display the sum in A6.

First, write the values in A1 to A5 and then click on A6 cell and type=SUM(A1:A5)

After that press "Enter"

In the A6 cell, you will get the sum of values present in cells from A1 to A5.

In case you have typed the wrong formula or want to modify it then you can click on the cell where you have written the formula and there will be a Formula Bar available above the worksheet area which will show the formula that you have written in the cell and you can edit it.

Answer 2

1. MS-Excel function syntax MID is an Excel function that returns a portion of a string (string, starting at, extract length).
2. As may be observed in the MID Excel function's syntax, We write the string from which we need to extract a portion at the position of string.
3. We write the index of the string where we should begin extracting the section of the string in place of starting at.
4. We specify the length of the string segment to be extracted in place of extract length.
5. The first character in a String has the index 1
6. As we may see in the string COMPUTER, it is suggested to start extracting the part of string from index 4.
7. The string that this MID function will return should have length 3 and as the extraction has started from P, we can assume it is 1 and then for U it is 2 and for T it is 3 and these are the letters that make the total length of extracted string to be 3 and that is how the output is PUT.

Hence, the output is PUT.

#SPJ3