DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In the Code column there is information about the year the student started school at Olympia. The 5th and 6th characters in the Code are the year the student entered. Column C4 is the result of Characters 5, 6 in cell B4, column C4 will have the formula:
|
|
=MID(Bch, 5, 2)
|
|
|
= MID(Bch, 2, 5)
|
|
|
=MID (Bch, 5, w)
|
|
|
=LEN (Bch)
|
Explanation:
There is 1 question to complete.