USING MICROSOFT EXCEL
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: -Basic Excel formula for age in years This conventional age formula can also be used in Excel. The first part of the formula (TODAY()-B2) returns the difference between the current date and date of birth is days, and then you divide that number by 365 to get the numbers of years.
Detailed explanation-2: -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.
There is 1 question to complete.