Spreadsheets

sscorssscors Feels At HomePosts: 72Registered
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 Posts: 2,526Registered
    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 Posts: 2,526Registered
    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 Posts: 108Registered
    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 Posts: 420Registered
    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 Posts: 75Registered
    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 Posts: 420Registered
    Just go over the aat mock exam and you will be fine!
  • sscorssscors Feels At Home Posts: 72Registered
    Thanks for the comments very helpful
Sign In or Register to comment.