Spreadsheet mock , pivot table answer

Julietteb

hi all

Just doing the AAT mock for this and am really struggling on the last question - pivot table. Im assuming it is a vlookup but just cant seem to get the right answer.

The AAT answer shows the figures but not the formula used.

Does anyone have any pointers - much appreciated!

Joe Barraclough

hi
its not a vlookup, you dont type in formula at all, there is an option to create a pivot table all you have to do is pick the data, in excel 2007 + it will be the first option under insert, if you are using 2003 or below it should be under the data tab or one of the last few tabs anyway

hope this helps

sdv

youtube It

excellent resources!

Julietteb

Great, thanks for your help.