Explore BrainMass

Explore BrainMass

    Excel: how to design various sort fields for a video game

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Your Uncle Larry has entered all of his video game collection data into an Excel workbook. He took your advice and used headings to organize the information. He now wants to have the information sorted in the fields Name, Date Purchased, Purchase Price, Color, Size, and Location for each of his video games. In addition, his wife, your Aunt Mary, wants to know how much money he has invested in this hobby, and his son wants to know the date he started this collection. Larry would also like to quickly be able to identify which video games were bought before the year 2000. Advise him regarding how he can accomplish these tasks.

    © BrainMass Inc. brainmass.com June 3, 2020, 9:37 pm ad1c9bdddf

    Solution Preview

    Step 1)

    Enter all the information in columns in the following format:

    Column No: Field

    A Name
    B Date Purchased
    C ...