Challenge Yourself

Create a budget for a special event. Use the list of expenses located in the Expenses.xls file. Track the estimated and actual amounts for each expense.  Figure out the totals for each category of expenses and an overall total for the expenses (estimated vs. actual).  Rename the worksheet Expenses and delete the empty worksheets.  Center a title across the page and add. Add sample data to test your formulas.

Open the Special Event.xls file. Duplicate the Expenses worksheet in order to create an Income worksheet.  Copy the data from the Income.xls file and rename the worksheet to Income.  Delete any unused rows. Change Total Expenses to Total Income and modify the formulas if necessary. Create another worksheet to compare Profit vs. Loss.  Rename the worksheet to Profit vs. Loss. Link this worksheet to the Expenses and Income worksheets. Create a column chart to illustrate the Profit vs. Loss.

Create a presentation for a special event. Include a title slide and at least three other slide layouts in the presentation. Include pictures and drawing objects in the slides.  Align, distribute, and/or group objects accordingly. Use transitions and animation schemes to add special effects to the slides. Save the file as Special Event.ppt.

Open the Special Event.ppt. Customize the slide master to include your event logo or a graphic that represents the event.  Change the fonts, font sizes, colors, and any other items to create a consistent look for the presentation. Create a Blank slide and link to the Special Event.xls file. Apply custom animation to the slides. Export the slides (with blank lines) to Microsoft Word to create handouts to e-mail in advance to the main participants.

Open the Thank You Letter.doc document. Insert the date so that it updates automatically. Copy the information from the Speaker.doc file to create a letter for Robert King.  Create a 2 inch top margin for the letter to print on special letterhead.  Change the font and font size to make the letter easy to read. Check the document for any spelling errors. Attach an envelope to the document with your return address.

Open the Vendor List.doc file. Apply styles to make the company name the main heading and the contact name the subheading.  Create a cover page.  Include the title: Vendor List.  List the date, location, and other relevant information.  Create a table of contents on the page following the cover page in order to easily locate the vendors.  Insert page numbers in the document using the following instructions: no page number on the cover page, (i,ii,iii) number format on the table of content pages, and (1, 2, 3) number style on every page thereafter.  Set the first page of vendor information to start at 1.  Insert a table on the Order of Events page (last page).  Use the information from the Agenda.doc to create the table.  Create name badges for the vendors using a mail merge. Use the Vendors.xls file to retrieve their company and name.  Save the merge file as Vendor Badges.doc.