I can't make heads or tails of this thing....

This Excel Project 3 has got me going BONKERS!!!!! I honestly don't get this whole assumptions/absolute references thing, not to mention the figures at the end of the whole thing don't match. I'm going to have to BEG somebody for help, as Prof. Buonaguro isn't in town and has no easily accessibility to the Blackboard. At least the chart seems to be okay. But I don't want to get a bad grade on this project. I've been doing good so far, and I don't wanna mess up.