70
EXL
9
Weekend Attendance Chart
16. Insertacolumnchartthatcomparesthetypeofeventbytheaveragecrowdsize(providedincellsC20-C23).
Hint:
Select cells B20:B23 and C20:C23.
· Titleyourchart"CrowdSizebyEvent"
· Show value labels for each column
· Do not include a legend
· Include the chart on the same sheet as the data
· Thesheetshouldbeverticallyandhorizontallycenteredonthepage
17. Display formulas in your spreadsheet by using Ctrl +` to check for accuracy.
18. Carefully proofread your work for accuracy and format.
19. Resavethefile.
20. SetthePrintAreatoincludeallcellscontainingdatainthespreadsheet.
21. Print Preview and adjust Page Setup with the following changes:
· Paperorientationshouldbelandscape
· Pagemarginsshouldbe.25inchesonallsides
· Thesheetshouldbeverticallyandhorizontallycenteredonthepage
· Thecenterofthefootershouldcontainthetext"WEEKENDATTENDANCE"
· The sheet should show gridlines
· Thescalingshouldbesettofittoonepage
22. Print a copy of the document if required by your instructor.
For Evaluation Purposes Only