55
EXL
4
your TASK
Your task it to create
a spreadsheet that
lists the companies
that have advertised
with The Hub. The
list will be broken up
into two categories:
display ads and
sponsorship ads. Each
list will be subtotaled
using the AutoSum
function. Then, the two
subtotals will be added
together with the
addition function.
the SKILLS
· UseAutoSum
· Addcells
· Vertically/
horizontally center
worksheets
T
hepowerofExcelisinthemathandtheperformingofcalculations.Adding
rangesofcellsiseasywhenyouuseAutoSum.Addingcellsthatarenot
adjacent to one another is also a snap with the use of your mouse. Simply
begintheformulawithanequalsign,aswithanyfunctioninExcel,andclickon
the cells you wish to total.
1. Thenumberformattinginfinancialreportsneedstobeconsistent.The$
symbolmaybeattachedtothenumber,left-alignedinthecell,ornotdisplayed
at all.
2. Format all numbers with the same number of decimal places.
3. Readthroughallinstructionspriortocompletingtheproject.
1. UsingMicrosoftExcel,createanewblankworkbook.
2. SavetheworkbookasProjectEXL-4AdvertisingRevenueinyour"Excel"folder
under "The Hub" folder.
3. KeythedataasitappearsinFigureEXL-4.1intothespreadsheet.Unless
otherwisenoted,thefontshouldbesettoArial10point.
4. UseAutoFittoadjustthewidthofthecolumnssothatdatafitsappropriately.
5. UnderlinethetextincellsA4,A11,B8,andB16.
6. FormatthecellsincolumnBtoAccountingwith2decimalplacesandthe$
symbol.
7. UsetheAutoSumformulaincellB9tofindthesubtotaloftheDisplayAds.
Hint:
=Sum(B5:B8).
8. UsetheAutoSumformulaincellB17tofindthesubtotaloftheSponsorship
Ads.
Hint:
=Sum(B12:B16).
9. BoldcellsA4andA11.
10. EnteraformulaincellB19tocalculatethetotalofDisplayAdsand
SponsorshipAds.
Hint:
=B9+B17.
11. Display formulas in your spreadsheet by using Ctrl +` to check for accuracy.
12. Carefully proofread your work for accuracy and format.
13. Resavethefile.
14. SetthePrintAreatoincludeallcellscontainingdatainthespreadsheet.
Advertising Revenue
For Evaluation Purposes Only