Problem solutions must make full use of defined name ranges using the labels indicated for each

cell$/$range$.$ Excepting Problem $4$: Forecasting, cell addresses should not be used in the formulas.

MAIN TASK: READ CAREFULLY BEFORE PROCEDING

Create one Excel Workbook containing separate worksheets to each of the problems below.

Save the workbook as your full name, e$.$g$.,$ anna$\_$watson.xlsx $($all lowercase$).$ Be sure to save

your workbook as a normal Excel workbook file with $.$xlsx extension. To confirm, after the

submission, download your file into a new location on your computer $($or $-$ better $-$ another

computer$)$ and try to open it$.$ If it opens in Excel, you're probably fine.

Each problem must be solved in its own worksheet within one workbook, so rename each sheet

tab with the specific problem title, e$.$g$.,$ Loan, Students, Tiers, etc. $($Ensure to keep everything

compact so that they are easily viewable when opened.$)$

You may use the raw data as provided in the examples and supplementary files to test your

solutions.

Be sure to include all required components in appropriate format for each problem solution.

Up to $50\%$ penalty will be applied for not using named ranges optimally.

Important note about named ranges in Office $365$: Due to some new features added to Excel recently,

named references may result in #N$/$A or #SPILL errors. If these are returned because of names in your

formulae, begin the named reference with an $\text{'}$at$\text{'}$ sign $($@$),$ e$.$g$.,$ @SALES instead of just SALES.