74
EXL
10
Party Planner Checklist
· F2throughF10--nametheselection"Cake"
· G2throughG10--nametheselection"Favors"
14. Inthesheetnamed"BOOKEDPARTIES,"applyadropdownlistbyallowingalistinthedatavalidationsetting
for the following cells:
· IncellF2,source=Style
· IncellG2,source=Drink1
· IncellH2,source=Drink2
· IncellI2,source=Food1
· IncellJ2,source=Food2
· IncellK2,source=Cake
· IncellL2,source=Favors
15. UseAutoFilltocopytheformatsofG2toL2downthroughG7toL7.
16. UsethedropdownlistfeaturetochoosetheitemsforeachpartyasshowninFigureEXL-10.3.
17. Carefully proofread your work for accuracy and format.
18. Resavethefile.
19. SetthePrintAreatoincludeallcellscontainingdatainthespreadsheet.
20. Print Preview and adjust Page Setup with the following changes:
· Paperorientationshouldbelandscape
· Pagemarginsshouldbe.25inchesonallsides
· Thesheetshouldbeverticallyandhorizontallycenteredonthepage
· Thecenteroftheheadershouldcontainthetext"BOOKEDPARTIES"
· The sheet should show gridlines
· Thescalingshouldbesettofittoonepage
21. Print a copy of the document if required by your instructor.
For Evaluation Purposes Only