What is the Du`a (supplication) of Istikhara (guidance prayer)?
O Allah, I consult You as You are All-Knowing and I appeal to You to give me power as You are Omnipotent, I ask You for Your great favor, for You have power and I do not, and You know all of the hidden matters. O Allah! If you know that this matter (then he should mention it) is good for me in my religion, my livelihood, and for my life in the Hereafter, or he said: "for my present and future life" then make it (easy) for me. And if you know that this matter is not good for me in my religion, my livelihood and my life in the Hereafter, or he said: "for my present and future life" then keep it away from me and take me away from it and choose what is good for me wherever it is and please me with it."
When the soul leaves the body, does it hear and see? And where does the soul go?
The important thing is that the soul departs while its owner is a believing, repentant Muslim, as this is a good ending. As for the details, they are lengthy. The grave is either a garden from the gardens of Paradise or a pit from the pits of Hellfire. And Allah The Almighty Knows Best.
What should a person, who delayed making up missed fasts of last Ramadan due to the continuance of the same excuse, do?
It is permissible for one, whose excuse for not making up missed fasts of last Ramadhaan has continued, to delay fasting until the excuse ceases to exist, and he is considered neither sinful, nor obligated to pay a ransom. And Allah Knows Best.
Is it permissible for a person to sever ties with his sister because her husband had quit prayer and done him harm?
A sister is a blood-relative and maintaining blood-relations is obligatory in Islam. As regards her husband, he should be invited to the way of Allah with wisdom and beautiful preaching.