DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Cell M4 shows the year of birth in the Student’s date of birth. Cell M4 has the following formula:
|
|
=LEFT (J4, 5)
|
|
|
=RIGHT (J4, 4)
|
|
|
=RIGHT(J4, 1, 4)
|
|
|
=MID(J4, 4)
|
Explanation:
Detailed explanation-1: -Enter a formula in cell E4 to calculate the average value of cells B4:D4. On the Home tab, in the Editing group, click the AutoSum button arrow and select Average. Press Enter.
Detailed explanation-2: -Hence, we conclude that Addressing a cell as $A$4 is called Absolute Addressing.
There is 1 question to complete.