1.Open the guest.xls workbook that I created and uploaded:
Review the data on the responded.doc document.
2. Enter the Attend, Adult, and Child data into your existing workbook.
3. Create headings on your Guest List sheet for each of the three columns in cells G5, H5, and I5 respectively.
4. Enter the data for each column based on the data found in the responded.doc document.
5. Ensure that the formatting of the added columns matches that of the existing table on your Guest List sheet.
6. Ensure that the columns are wide enough to contain the headings and data you have entered; widen the columns if necessary.
7. In cell G74, enter the words Total Attending.
8. Right justify this text.
9. Change the color of the font of this text to match the color of your headings.
10. Make this text bold.
11. Use either the Insert Function feature or the button on your standard toolbar to enter a SUM function in cell H74 to total the number of adults attending the family reunion.
12. Use either the Insert Function feature or the button on your standard toolbar to enter a SUM function in cell I74 to total the number of children attending the family reunion.
13. Review the data in the budget.doc document.
14. In your Excel workbook, insert a new blank worksheet.
15. Move this worksheet to the right of your Guest List worksheet.
16. Rename this worksheet Budget.
17. Change the color of the Budget tab.
18. Use the budget.doc document as your guide to create a table on the Budget worksheet to calculate the total costs of the family reunion.
19. Cell A1, enter your name.
20. In Cell A2, enter the date.
21. A5:D5 should contain the following headings:
Description
Cost
22. Multiplier (This is the number that you multiply the cost by to reach your total that will be used for the adult meal, child meal, adult t-shirts, child t-shirts, and hours for the photographer.)
Total
Change the font size of your headings.
Change the font color of your headings.
Change the background color for your headings.
23. Enter the data from the budget.doc document into the sheet.
24. Food Cost and Family Reunion T-Shirts should be bold, and the two items under each (Adult and Child) should be indented.
25. Format the Cost and Total columns to Currency.
26. Add borders as necessary to create your table.
27. The Multiplier column should contain the following information:
28. For the Adult Meal item, create a link that refers to the cell on the Guest List sheet that contains the total number of adults planning on attending the family reunion (Verify that the number that shows as a result of the link in this cell is 73).
29. For the Child Meal item, create a link that refers to the cell on the Guest List sheet that contains the total number of children planning on attending the family reunion (Verify that the number that shows as a result of the link in this cell is 13).
30. For the Adult T-shirts and Child T-shirts items, create links that refer to the same cells referenced in items 7a and 7b.
31. For the Photographer item in the Multiplier column, enter 4 as the number of hours that the photographer will be used.
32. In the Total column, enter formulas in cells D7, D8, D13, D14, and D15 using cell references to calculate the total for each of these items.
33. In the Total column, create links to pull the information from the Cost column to the Total column for all other items.
34. In cell C19, enter the text Total Projected Cost (Omit the quotation marks).
35. In cell D19, enter a Sum function to total the Total column (Verify that the result of your formula is $1,900.00).
The initial spreadsheet is uploaded as SandersJosephIP1. And the additional data is also uploaded as List of People who Responded and List of Cost Incurred for Reunion.
Attachment:- List of Cost Incurred for Reunion.zip