The action of Volterra integral operators with highly singular kernels on Hölder continuous, Lebesgue and Sobolev functions