Question

1. This is Mike in the picture.

(What does 'in the picture' modify in this sentence?)

Answer 1

It's a prepositional phrase and seems to be modifying "Mike," but it could also be taken as adverbial ... telling where "This is." I think I'd go with adverbial!