73
EXL
10
Party Planner Checklist
C
ustomersloveparticipatingintheplanningofaneventforalovedonein
thehopesofmakingitahugesuccess.Oftencompaniesprovideamenu
of their products and services to customers so they can select the items that
willmaketheireventtrulyunique.Forthebusiness,organizingtherequests
from various customers into one spreadsheet is important so that everyone
receivesthepartytheyhelpedtoplan.MicrosoftExcelanditsdropdown
boxescanhelpproduceaspreadsheetthatwillkeepalloftheevents"as
ordered."
1. Copyandpasteobjects,suchasthedate,sothatthesizeandstyleremainthe
same.
2. Readthroughallinstructionspriortocompletingtheproject.
1. UsingMicrosoftExcel,createanewblankworkbook.
2. SavetheworkbookasProjectEXL-10PartyPlannerinyour"Excel"folderunder
"The Hub" folder.
3. Unlessotherwisenoted,thefontshouldbesettoArial10point.
4. KeythedataasitappearsinFigureEXL-10.1intoSheet1ofthespreadsheet.
5. Formatrow1titlesto12point,bold.
6. FormatcolumnCusingthelongdateformat.Forexample:Saturday,March26,
2012
note:
Use only if this is an option with the Excel version you are working with.
7. UseAutoFittoadjustthewidthofthecolumnsinSheet1sothatthedatafits
appropriately.
8. RenameSheet1"BOOKEDPARTIES."
9. KeythedataasitappearsinFigureEXL-10.2intoSheet2ofthespreadsheet.
10. Formatrow1titlesto12point,underlined.
11. UseAutoFittoadjustthewidthofthecolumnsinSheet2sothatthedatafits
appropriately.
12. Rename Sheet2 "Dropdown Data."
13. Inthesheetnamed"DropdownData,"selectcellsandnamethemasfollows:
· A2throughA6--nametheselection"Style"
· B2throughB6--nametheselection"Drink1"
· C2throughC6--nametheselection"Drink2"
· D2throughD5--nametheselection"Food1"
· E2throughE5--nametheselection"Food2"
your TASK
Your task is to create
an Excel spreadsheet
that lists all of the
information about
the parties scheduled
to take place at The
Hub. This spreadsheet
will list the customer's
name and date of the
event and will use
the dropdown list
feature of Excel to
select from the variety
of decoration styles,
drinks, foods, cakes,
and party favors for
each event.
the SKILLS
· Create dropdown
lists
· Rename worksheets
· Format dates
For Evaluation Purposes Only