MSQuery Question

I have a worksheet written by another programmer that I have to modify.
He uses MSquery to extract from a SQl 2003 DB. That part I understand
and I can duplicate. The hard part, is that for each row that is
displayed three additional columns show up (in all seven queries) and
in one case he changes the sorting of the query as well. These
functions use the columns output by MSquery. There very simple
functions and tests. In the SQL I can not find them or any reference to
them. There is no module in VBA. No add-in, just the MSQuery. How can
he do this. What should I be searching in Google to understand this
feature?