65
EXL
8
your TASK
Your task is to create
a multi-sheet file
that shows expense
amounts per month
and a quarterly
summary. The project
will contain data for
three months. Each
month will have
its own sheet. The
Quarterly Summary
sheet will sum all
months by expense
name. The owners
will use this report
to analyze where
the majority of
expenditures are made
by The Hub.
the SKILLS
· Use cell reference
· Format numbers to
currency
· Rename worksheets
B
usinessownersoftenanalyzefinancialreportstohelpthemmake
decisions.Reviewingexpensesisagoodpracticetomaintainanefficient
operation.Examiningandevaluatingmonthlyexpensescanhelpmanagers
andownersunderstandthecostofoperatingtheirbusinesses.Budgeting
decisionsaremadebaseduponthisreview,soit'simportanttokeepdata
organized.
1. Carefullycheckyourresultsafterenteringtheformulasinthespreadsheet.
2. Ifyouareworkingwithaworkbookthathasmultipleworksheets,renaminga
worksheethelpsyouquicklyidentifywhichworksheetyouareworkingin.
3. Readthroughallinstructionspriortocompletingtheproject.
1. UsingMicrosoftExcel,createanewblankworkbook.
2. SavetheworkbookasProjectEXL-8MonthlyExpensesinyour"Excel"folder
under "The Hub" folder.
3. Insertadditionalsheetstothefileandrenamethemasfollows:
· RenameSheet1toQuarterlySummary
· RenameSheet2toJanuary
· RenameSheet3toFebruary
· RenameSheet4toMarch
4. KeythedataasitappearsinFigureEXL-8.1intotheQuarterlySummarysheet.
Unlessotherwisenoted,thefontshouldbesettoArial10point.
5. CopyandpastethelistofexpensesincolumnAontheQuarterlySummary
sheettoeachmonthlysheet,beginningonrow3.
6. Keythetitle"JanuaryExpenses"onrow1oftheJanuarysheet.Continueto
titleeachsheet(FebruaryandMarch)inthesamewayusingtheappropriate
month's name.
7. KeythemonthlyexpenseamountsasshowninFigureEXL-8.2.
8. UseAutoSumtofindthe"TotalExpenses"foreachmonthincellB17foreach
sheet.
9. IncellB3oftheQuarterlySummarysheet,inserttheformulatoaddtheTotal
AdvertisingExpensesforJanuary,February,andMarch.
Hint:
=January!B3+February!B3+March!B3.
10. UsetheAutoFillfeaturetocopytheformuladowntotheremainingexpenses
ontheQuarterlySummarysheet.
11. Formatallnumberstocurrencywiththe$symboland2decimalplaceson
each sheet.
12. Display formulas in your spreadsheet by using Ctrl +` to check for accuracy.
Monthly Expenses
For Evaluation Purposes Only