It depends. If you have a larger case, you can probably get away with using a non modular PSU. However, as there is generally not a big price difference, go for the modular. It'll make life easier.
As for the cables, check under the description of the part listing. It should tell you what connectors it comes with. Then just compare it to how many SATA or PCI components you have.