Does the excess(unused) part of a wire have any resistance effect
It has no effect on resistance calculation. However, depending on the circuit, an "unused" piece of wire can have effects, as it could function as an antenna.