69
EXL
9
your TASK
Your task is to compare
the past several weeks'
weekend attendance
at different events at
The Hub. The use of the
Highest, Lowest, and
Average function will
allow for the creation
of a column chart
to determine which
type of event is most
popular.
the SKILLS
· UsetheMinfunction
· UsetheMaxfunction
· Insert column chart
A
nalyzing data is an important aspect of running any business. Business
ownerswanttobesuretheyaremakingeducateddecisions.Theyoften
relyondatatohelpdrivethosedecisions.Comparingpastactionscanoften
leadtochangingfuturepractice.
1. Sort reports to keep similar data together.
2. Format charts with labels for easier reading.
3. Format all numbers with the same number of decimal places.
4. Readthroughallinstructionspriortocompletingtheproject.
1. UsingMicrosoftExcel,createanewblankworkbook.
2. SavetheworkbookasProjectEXL-9WeekendAttendanceinyour"Excel"folder
under "The Hub" folder.
3. KeythedataasitappearsinFigureEXL-9.1intothespreadsheet.Unless
otherwisenoted,thefontshouldbesettoArial10point
4. FormatthewidthofcolumnsAthroughCto32.
5. FormatthetitleincellA1to20point.
6. MergeandcentercellsA1throughC1.
7. Formatrow3to16point.
8. Sortthedatainthespreadsheetby"Event"inascendingorder.
9. EnteraformulaincellC17thatwillcomputetheeventwiththelargestcrowd.
Hint:
=MAX(C4:C15).
10. EnteraformulaincellC18thatwillcomputetheeventwiththesmallestcrowd.
Hint:
=MIN(C4:C15).
11. EnteraformulaincellC20thatwillcomputetheaveragecrowdforBattleof
the Bands.
Hint:
=AVERAGE(C4:C5).
12. EnteraformulaincellC21thatwillcomputetheaveragecrowdforGuestDJ.
Hint:
=AVERAGE(C6:C8).
13. EnteraformulaincellC22thatwillcomputetheaveragecrowdforHouseDJ.
Hint:
=AVERAGE(C9:C13).
14. EnteraformulaincellC23thatwillcomputetheaveragecrowdforaPrivate
Party.
Hint:
=AVERAGE(C14:C15).
15. Format all numbers to whole numbers.
Hint:
Show no decimal places.
Weekend Attendance Chart
For Evaluation Purposes Only