Formulate an answer to this elaborate question: What is the name of the American actor, comedian, and singer, known for playing Andy Bernard in the U.S. version of "The Office" who starred in American comedy film Vacation?
Ed Helms