Can I make music with software?

I would like to create my own "digital band" where I can create guitar
riffs, drums and bass.  Ive heard of Cakewalk's Sonar 3 software but
Im not sure if its possible to make music from scratch with all the
effects etc...
I dont care about lyrics at this point, just want to make my own
music, is there software that can do this?