Is it possible for an object not to be in motion and still have force acting upon it?

Yes, this is an example:

An apple is sitting on a desk he is not in motion but one of the forces acting upon it is gravitational pull because is not floating around, the earth gravitational pull is pulling it down to the earth's surface.