Working on a web application used on an intranet. The next phase includes 'using' Sharepoint so users can access documents. I have never used Sharepoint.

Will I be able to do things like ...

Within the web application present a list of documents to do with a certain project so users can, for example, click on a spreadsheet and it will open - on their computer - in Excel?

When the document is saved - what is the mechanism for it being saved in the same location it was retrieved from?

Is there any sort of source control involved - so that two users don't access the same document at the same time and then one of them overwrites the other's changes etc.

Does the Sharepoint Server have to be the same server that the web app is running on. If not - what authentication issues arise and are they easy to deal with?

Any pointers much appreciated. I have to either own up and say 'I don't know how to do this' - or convince myself I can pick it up somehow.