Spreadsheet mock , pivot table answer

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
    Joe Barraclough Registered Posts: 69 ? ? ?
    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
    sdv Registered Posts: 585
    youtube It

    excellent resources!
  • Julietteb
    Julietteb Registered Posts: 26 ? ? ?
    Great, thanks for your help.
Privacy Policy