They float over the worksheet, but you can adjust the size so that it seems to
fit a cell exactly.

If you insert a picture, you can hold the alt-key down while you move/resize the
picture.  When it gets close to the edge of a cell, it'll snap-to that edge.