Need help with the assignment.

[superfly]

I am a newbie in excel. Need help with the questions 2-6.

 

[Hui]

Q2. Requires the use of the VLookup formula based on the Vehicle Code in Policy Data and the details on the Vehicles Details worksheet
Refer:
http://chandoo.org/wp/2010/11/01/vlookup-excel-formula/
http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/

Q3. I assume you just average all the results for this year vs Last year
Refer:
Averageifs uses the same format as Sumifs
http://chandoo.org/wp/2010/04/20/introduction-to-excel-sumifs-formula/

Q6. Right click on the chart series, Add Trendline
Tick Display Equation on Chart

Use the equation to setup a formula in column C
eg: if the Equation is = 0.01x + 2
in C3 it will be =0.01*A3+2
copy down