Home For AAT student members AQ 2013 AAT Level 3 (Level 6 in Scotland)
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Spreadsheets

sscorssscors Feels At HomeRegistered Posts: 72
Hi

currently studying for spreadsheets module not sure about a question wondering if any one would be able to help. I was given a table with a list of full names ie forenames and surnames and I had to reorder it by SURNAME in to alphabetical order?

Comments

  • Jo ClarkJo Clark Font Of All Knowledge Registered Posts: 2,525
    Hello sscors

    What I think the question is asking you to do is to use the sort function to rearrange the list of names so that the SURNAMES are in alphabetical order e.g. bloggs, clark, davies, edwards etc.

    I would advise how/where to find this but am not sure what spreadsheet application/version you are using.

    Hope the above helps.


    JC
    ~ An investment in knowledge always pays the best interest ~
    Benjamin Franklin
  • Jo ClarkJo Clark Font Of All Knowledge Registered Posts: 2,525
    Hello

    I meant to say that you need to ensure that all the data in each row is selected so that everything is sorted not just surname.

    Hope that makes sense?


    JC
    ~ An investment in knowledge always pays the best interest ~
    Benjamin Franklin
  • NicFNicF Well-Known Registered Posts: 108
    Jo is correct about this. You need to highlight the entire table then select Data and Sort. This will give you a box with the option of which column to sort by. If your table has headers and you have highlighted them with everything else make sure the 'headers' box at the bottom of the 'Sort' options box is ticked or it will sort these as well.

    N
  • MWAUGH1983MWAUGH1983 Trusted Regular Registered Posts: 420
    I did this 3 wks back and got the result the other day as competent. This question is one I fluffed as I was sorting the column and the other data wasnt being sorted - thats why you NEED to select the other day; thinking about this, this is where I fluffed it I think! :( lol
  • Chimpette22Chimpette22 Feels At Home Registered Posts: 75
    I would say highlight and then data sort. I've got my exam coming up.... eek :ohmy:
    Fully AAT qualified July 2015
  • MWAUGH1983MWAUGH1983 Trusted Regular Registered Posts: 420
    Just go over the aat mock exam and you will be fine!
  • sscorssscors Feels At Home Registered Posts: 72
    Thanks for the comments very helpful
Sign In or Register to comment.