The passive voice exists for a reason; as far as I can tell all languages have some way of creating a construction equivalent in semantics (and pragmatics) to the English passive.
At the semantic level, the passive voice operates on transitive verbs (=2 or more arguments; note that the subject is included as an argument) and "promotes" the transitive object to a subject. The meaning is equivalent semantically (barring idiomatic usages), as the subject of a passive construction is still the object of that transitive verb. Consider these two sentences below, where the event (=what happens to the object) is the same, in either active or passive voice.
1) John ate [the cake]
2) [The cake] was eaten (by John).
In either 1) or 2), this information is the same: there was a salient cake and it was eaten. However, note that the passive allows one to drop out the agent.
So, why would one use the passive voice over the active? Perhaps the writer/speaker wants to give attention to the object. In English the subject position is often where topics go, and so is considered the "important" element. Promoting the object to a subject via passive allows one to emphasize this. Another possible case: we simply don't know who the agent was or perhaps the agent doesn't really matter. The passive is also helpful for generalizing / avoiding assigning blame / being polite.
Consider these cases:
3) The trash can was blown over (by the wind).
4) John was really screwed.
5) That project got really messed up. (<= note how it doesn't blame anyone in particular)
In 3), it probably obvious what blew the trash can over (in general people don't go around blowing down trash cans, etc.). For 4), this begins to get idiomatic--we could try to attribute reason(s) why John is not in a good situation, but usually this is secondary to stressing that John is really screwed.
We can apply this reasoning to the example sentence you gave:
6) [Tonight's moon] can be seen from anywhere worldwide.
In this sentence, the fact that the moon is visible from anywhere in the world is being stressed, hence why the writer probably chose to use the passive. We really don't care who is seeing the moon.
You should use the passive when its the idiomatic way to talk about an event (e.g. the agent usually is implied or not important) or when you want to focus on the object of such an event, and therefore promote it to subject position via the passive construction.
Two liters are contained in the bottle.
The sentence is correct grammatically. Some state verbs can't be formed in the passive, but others can be put in the passive. For example: He is known to me. You are loved by us. This house is owned by me.
The word contain in the sentence presented is also a state verb that is usually followed by the preposition in/within in the passive, especially when you want to say that something is included to be part of a book. document. report or speech, etc. For Example:
The information you want is contained in this report.
Different new sections are contained in the bill.
Best Answer
Both This mess was made by who(m)?
and your second sentence Who was this mess made by? are correct.
Your first sentence is not grammatical. You can say By whom was this mess made?