Explore BrainMass
Share

Explore BrainMass

    Excel Data Processing

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

    Someone please help!

    The class president has given me a MS Word document that contains a list of everyone who has been invited to the high school reunion. I will enter this data into a pre-made Excel workbook. This Excel workbook does not contain all the information, so I will enter and format a substantial amount of the data.

    The Guest Information document.
    Page 1 (this data has already been added to your Excel spreadsheet)

    Last Name First Names Street Address City ST Zip
    Brushing Jim and Sue 7445 Pine Tree Drive Dunwoody GA 30338
    Mills Jeff, Jamie, Riley, and Kim 546 City Way McDonough GA 30253
    Kaye Bob and Sally 98 Pool Drive Loudon TN 37774
    Matthews Jeff 42 Pool Drive Loudon TN 37774
    Martin Chris and Gerald 58 Dudley Street Loudon TN 37774
    Saledo Guy and Patricia 5 Pine Drive Alpharetta GA 30201
    Cannon Mary 3 Johnson Ct. Atlanta GA 30328
    Fugate Chistopher 230 Arapahoe Rd Savannah GA 31419
    Nichols Charlie and Cathy 707 Lanky Road Nashville TN 37209
    Shetley Will and Sheri 770 Sire Drive Myakka City FL 34251
    Adams Chris, Joan and Courtney 35 Field Way Cumming GA 30040
    Smith David 31042 Beth Cir. Duluth GA 30096
    Johnson James 38 Meridian NW Washington DC 20010
    Brewster Randy, Minette, Liz and Jon 3 Island Drive Savannah GA 31406
    Black Conrad and Glenda 51 Meadow Lane Billings MT 59102
    Shea Ty and Carol PO Box 2 Cherry Log GA 30522
    Deery Aunt Lois 789 Rue Mandeville LA 70471
    Denbow Fred and Anne 5485 Port Drive Greenville SC 29607
    Hansen David and Elaine 589 Creek Drive Fogelsville PA 18051
    Andrews Morris and Anne 432 Tree Road Dunwoody GA 30338
    Staley Roy 156 Peach Road Dunwoody GA 30338
    Stebbens Bubba and Jane 5198 Club Drive Marietta GA 30068
    Wilkens Deitz, Peggy, Ryan and Stacy 5 Stone Lane Macon GA 31210
    Byrd Jeff and Linda 480 Vail Drive Dunwoody GA 30338
    Harrelson Major and Anne 85 Craig Alpharetta GA 30202
    Burwell Robert and Elsa 58 Tree Drive Dunwoody GA 30338
    Bauer Richard and Ann 322 Land Drive Doraville GA 30340
    Anderson Max and Sandra 780 Wooly Drive Atlanta GA 30360
    Davis Joey and Donna 26 View Circle Waleska GA 30183
    Davidson Bubba and Elizabeth PO Box 5 Camden AL 36726
    Gomez Lisa 9 Moss San Antonio TX 78250
    Young Carl and Loma 271 Fence Road Durham NC 27705
    Edwards Dean and Pam 433 Village Court Dunwoody GA 30338
    Easton Jim, Cathy, Caroline, Guy, Max and Dillon 71 Ridge Way Colorado Springs CO 80542
    Eisler John and Kim 94 Spruce Street Woodland Park CO 80863
    Dye Alexander and Lynette 80 Flint Drive Colorado Springs CO 80918
    Crippen Pauline 255 Tail Drive Colorado Springs CO 80916
    Hermann Joyce 241 Pecan Ave. Colorado Springs CO 80909
    Gregg Lori and Mark 240 Pat Way Colorado Springs CO 80909
    Foster Chris and Martie 28 Shane Place Monument CO 80132
    Thomas Curtis and Janice 15 Lindsey Street Castle Rock CO 80104
    Vance Adam, Carrie and Dan 117 North 9th Street Indianola IA 50125
    Nolte Kristi 60955 North Evans Pueblo CO 81004
    Payne Ken and Barbie 44 Castle Road Colorado Springs CO 80917
    Morris Daniel and Sara 555 Eldora Drive Colorado Springs CO 80918
    Noble Leon and Olive 899 Beasley Drive Pueblo CO 81005
    Meek Richard, Mary, Patrick and Lauren 158 Park Drive Moorpark CA 93021
    Nelson Angelina 172 Harvard Street Pueblo CO 81004
    Perry Frank 121 La Huerta Pueblo CO 81005
    Starr Mike, Sabina, Leo and Alex 41 Tusks Drive Amarillo TX 79109
    Reeser Jason, Heather and Braedyn 16 Alpine Drive Rifle CO 81650
    Ryan Mary 23 Normal Street Pueblo CO 81005
    Page 2 (this data must be entered into your Excel spreadsheet)

    Jenkins Will and Josephine 280 Rose Lane Pueblo CO 81005
    Garcia Harry and Becky 510 Wood Lane Alexandria VA 22311
    Snow Bill and Dee 32 Farm Road Pueblo CO 81006
    Sommer Irene 103 River Cir. Bayamon PR 954
    Jordan Roberto 3 Corona Blvd Pueblo CO 81004
    Gunderson Pedro, Jaime and Maria 415 Sand Drive Colorado Springs CO 80911
    Smithson Bobby 60 Autumn Circle Colorado Springs CO 80919
    Martinez Michael and Deb 118 Cedar Drive Pueblo CO 81005
    Hopkins Sasha 18 Crest Drive Pueblo CO 81005
    Crawford Jim and Linda 63 West 96th Pueblo CO 81005
    Yoder Pete and Beta 29 Avenue Y Alpine TX 79830
    Hunt Judy and Sally 6 Mountain Street Alpine TX 79830
    Carlson George and Norma 215 North Wood Pueblo CO 81003
    Mora Tim and Romie 82 East 7th Road Pueblo CO 81001
    Dean Missy 20 Fuller Road Euless TX 76039

    -----------------------------------------

    Download the Excel workbook.

    After you open both documents, perform the following steps:

    Review the data entered on Sheet1 of classmates.xls.
    Create meaningful headings for your data on Sheet1.
    Rename Sheet1 to Classmates and change the color of the tab.
    Delete any sheets not being used.
    In cell A1, enter your name.
    In cell A2, enter the date.
    Insert two blank rows between the date and the beginning of your data.
    Enter the data from page 2 of guest.doc directly below the existing data on your newly named sheet.
    Format the data on the Classmates sheet.
    Use borders to clearly define your table.
    Use patterns (background colors) to differentiate between your headings and data.
    Change the font and font color of your headings to make them more visible.
    Center your headings.
    Increase the width of each column so that no data is hidden (ensure that columns are not too wide).
    Using Save As, save this workbook using the following naming convention: YourlastnameYourfirstnameIP1.xls.
    Save a copy of this Excel workbook on your hard drive or removable storage device.

    © BrainMass Inc. brainmass.com October 9, 2019, 11:30 pm ad1c9bdddf
    https://brainmass.com/computer-science/trees/excel-data-processing-258616

    Attachments

    Solution Summary

    The solution contains an Excel spreadsheet that satisfies each of the listed requirements. The spreadsheet is clean and in a easy-to-read format.

    $2.19