First Principle Studies On Ground And Excited Electronic States: Chemical Bonding In Main-Group Molecules, Molecular Systems With Diffuse Electrons, And Water Activation Using Transition Metal Monoxides