Is he at office a correct statement?

"Is he at office?" is in fact correct, but a very old fashioned way of making that statement.

A more current way would be "Is he in the office?" or "Is he in his office?"