sac.simnetonline.com Open the EX2019-Fixlt-4-6 start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the t0p of the workbook so you can modify the workbook. The workbook was last saved in Page Break Preview view. Switch it back to Normal view. The workbook uses a very unattractive theme. Change the theme to Office. The COpy of the ShOpping List worksheet is incomplete. Delete it. Be careful to delete the copy, not the original. Both worksheets should include the sheet name in the header center section. Both worksheets should include the gridlines when printed. 1) 19) 19) do) 1) 1) 19) B sac.simnetonline.com 8. Correct the following errors in the Shapping List worksheet: a. The Shopping List worksheet should be first in the workbook. One of the columns is not wide enough to display the data. Autofit that column. There is an extra row between the label row and the shopping data. Delete the extra row. 9. Correct the following errors in the Guest List worksheet: a. The worksheet tab is misspelled. Correct the spelling of Gest. Column D should not be visible. Row 3 is too tall. Autofit the row to fit the content. Page orientation should be Portrait. Margins should be set to the Narrow option. All columns should fit on one page when printed. The right footer section should no) 10) 4) n) 4) 19) 10) 4) 19) 10) 3:27 Student Hussein.Alobaidi-EX2019-Fixit-4-6 Gest List Shopping List Shopping List (2) Guest List Title First Name | Last Name Name Tag Street City State ZIP Phone RSVP 95602 916-598-6952 Cindy Jacobs CINDY JACOBS 417 9th St. OCKIIn CA Larrina LARRINA GRANDE 87441 Palace Square Newcastle CA 95602 916-741-8526 Katherine KATHERINE HAIRLESS 2068 Harry Hill burn CA 602 530-888-0805 James JAMES MUCHLEY 87543 Baldys Road 602 530-885-6523 Mr./Mrs WILLIAM HOLLAND 9225 Marchmont Dr ramento 95602 19161348-9982 anchaz BETHANY SANCHAZ 8852 Jones Lane santa Rosa CA 95602 7071521-3478 Mr/Mrs Mrs Watkins GERALD WATKINS 446 Chest Ave San Jose 95602 (4151441-8639 Mr Thatcher EMILY THATCHER 2275 Oak Park Lane Rocklin CA 5602 19161315-8690 Mr/Mrs Cater LOUISA CATER 852 Paly Place Roseville CA 5602 (9161789-4470 Roger HAROLD ROGER 14 Header Or ocklin CA 602 555-1324 ichael slocum MICHAEL SLOCUM 543 Tulip Ave Rocklin CA 555-2453 Idam Melon ADAM MELO 387 Daly St Rocklin CA Claire Ace CLAIRE ACE 9083 Rocky Rd Rocklin CA Jackson Perry JACKSON PERRY 883 Forest Drive Rocklin CA lames Smith JAMES SMITH 5366 Onyx Drive Rocklin 19161521-6654 JIM SMITH 5366 Onyx Drive Rocklin -5152 Tom Jackson TOM JACKSON 2323 Windy! Drive Rocklin -0127 Chuck Newman CHUCK NEWMAN 4477 Jade Road Rosevill CA Steve Nicks STEVE NICKS 2897 Josh Street Lincoln CA Bill Wilson BILL WILSON 1925 Park Ln Colfax CA Robert Nettle ROBERT NETTLE |45 High St. Auburn CA Debbie Frost DEBBIE FROST 25572 Sieata Way Weimar CA Linzy O'Neil LINZY O'NEIL 6312 Westridger Ave. CA 16-9975 Josh Hawkins JOSH HAWKINS 7438 Pacific Dr. uburn CA 602 530-878-7369 Zach Na ZACH NA 1400 Racer Terrace Pine Broo CA 602 (973) 575-7120 Barbra Williams BARBRA WILLIAMS 1453 Frosty S San Diego CA 5602 (6191279-9486 Walter Pell WALTER PELL 890 1st Ave. CA 5602 (619156 Jerry lones JERRY JONES 5678 Oak Ave. 95602 (5301823-4983 Christopher Jones CHRISTOPHER JONES 5678 Oak Ave. 95602 (5301823-4983 Keith Lee KEITH LEE 7823 Seacrest Weimar 95602 (5301637-9901 syung Nagato BYUNG NAGATO 23 Shadow Ln Dark City 95602 458-628 Sharon Nagasaki SHARON NAGASAKI |410 Lemoen Dr Watershed 602 626-8324 David Lonsdale AVID LONSDALE 725 Wave st. La Beach 95602 364-6214 Karen Negreedy KAREN NEGREEDY 858 Steal Way Dark City 602 458-582 Larry Chama LARRY CHAMA 443 Harty Ave. Watershed 95602 626-5461 Brenda Smith BRENDA SMIT 564 Newby Street Rack 95602 906-452-5581 Matt Castle MATT CASTLE 48265 Long St Dewy Techi Willows TECHI WILLOWS 852 Spree St Bark Marie Bond MARIE BOND 1007 Pagent St Steams Juan JUAN SCOTT 8584 Sure Ln Nowhere -3210 Scott Kim KIM JOHNSON 5687 Art Way Rocklin CA Charles Nosmiles CHARLES NOSMILES 4412 Meanie Street Loomis CA Larrina Grande LARRINA GRANDE 87441 Palada Circle Newcastle CA 602 916-741-8526 Katherine Hairless KATHERINE HAIRLESS 2068 Bald Hill iburn CA 388-0805 James Muchley JAMES MUCHLEY 87543 Harry's Road CA 85-6523 Mr./Mrs WILLIAM HOLLAND 9225 Larchmont Or CA Mr/Mrs nchaz BETHANY SANCHAZ 8852 Smith Lane Santa Rosa 5602 (707)521-3478 Mrs Watkins GERALD WATKINS 446 Chester Ave San Jose CA 602 (4151441-86 Mr Thatcher EMILY THATCHER |2275 Oak Tree Lane Rocklin CA 5602 19161315-8690 Cater 852 Park Place Roseville CA 95602 19161789-4470 Mr/Mrs LOUISA CATER Roger HAROLD ROGER 14 Body Dr Rocklin 02 555-1324 slocum MICHAEL SLOCUM 543 Lily Av Rocklin 555-2453 Melon ADAM MELON 387 Day St Rocklin 602 555-260 Claire Ace CLAIRE ACE 9083 Rock Rd Rocklin 95602 555-269 Jackson Perry JACKSON PERRY 883 Forest Ln Rocklin 602 555-990 lames Smith JAMES SMITH 5366 Onyx Drive Rocklin 602 (9161521-6654 JIM SMITH 5366 Onyx Drive Rocklin 1632-5152 Tom Jackson TOM JACKSON 2323 Windfall Drive Rocklin Mr. Chuck Newman CHUCK NEWMAN 4477 Emerald Road Roseville 5602 (9161624-56 Mrs. Steve Nicks STEVE NICKS 2897 Tyler Street Lincoln 602 19161521-46 Bill Wilson BILL WILSON 1925 Park L Colfax Robert Nettle ROBERT NETTLE 45 High St. Auburn Debbie Frost DEBBIE FROST 25572 Sierra Way Welmar CA Linzy O'Neil LINZY O'NEIL 6312 Westridge Ave CA 95602 530-346-9975 Josh Hawkins JOSH HAWKINS 7438 Atlantic Dr. Auburn CA 95602 530-878-7369Shopping List Source Item Description Quantity Units ostperUni Cost Soft Drinks and $8.00 Water 7 case $56 Invitations 70 each $1.29 $90 Flower 15 each $45.00 Arangements $675 Glass Coffee Cups 50 each $2.50 and Saucers $125 Cake 1 Each $400.00 $400 Appetizers 25 pounds $12.00 $300 Music 1 each $1,750.00 $1,750 Dessert Forks, 100 each $0.50 Cofee spoons $50 Dessert Plates 100 each $1.00 $100 Dinner Plates 100 each $1.50 $150 Dinner Silverware 100 sets $1.00 $100 Glasses 100 each $2.25 $225 Napkins 100 each $0.40 $40 Salad Plates 100 each $1.00 $100 Table Cloths 10 each $6.00 $60Gest List Shopping List Shopping List (2) Shopping List Source Item Description Quantity Units stperUn Cost Costco - Folsom Soft Drinks and Water 7 case $8.00 $56 Engravers Invitations 70 each $1.29 $90 Flower Power Florist Flower Arangements 15 each $45.00 $675 Party Rentals Glass Coffee Cups and Saucers 50 each $2.50 $125 Sharons Bakery Cake 1 Each $400.00 $400 Super Supermarket Appetizers 25 pounds $12.00 $300 The Entertainers Music 1 each $1,750.0 $1,750 The Party Store Dessert Forks, Cofee spoons 100 each $0.50 $50 The Party Store Dessert Plates 100 each $1.00 $100 The Party Store Dinner Plates 100 each $1.50 $150 The Party Store Dinner Silverware 100 sets $1.00 $100 The Party Store Glasses 100 each $2.25 $225 The Party Store Napkins 100 each $0.40 $40 The Party Store Salad Plates 100 each $1.00 $100 The Party Store Table Cloths 10 each $6.00 $6010. h. Rows 1:3 should always be visible as you scroll down the worksheet. Hint: Select the entire row where you want to apply the Freeze Panes command. ' Rows 1:3 should also print on every page. The page break should be between rows 56 and 57 so the guests who have not yet RSVP'd are grouped together on the second page. If you were working in Page Layout view or Page Break Preview view, be sure to switch back to Normal view. Review your work by previewing how each worksheet will print and then save and close the workbook