How does answer A,B,C affect how people answer D?

I have 9 questions in 3 different blocks where you answer with a number (1-7). And there is a question (how did you like this place overall?) that is answered (1-10). I need a way to find out how much each block (and maybe also each question) affects the tenth question. Preferably using excel or R. The number of respondents are in the thousands if that makes any difference.