Theoretical description of diabatic mixing and coherent excitation in singlet-excited states of carotenoids