$.$ Use IF$,$ TODAY, NOW functions

$2.$ Create formulas using Relative Referencing, Absolute Referencing, and Mixed Referencing

$3.$ Perform What$-$If Analysis

$4.$ Inserting Rows and Columns

$5.$ Reinforce functions$($SUM$),$ simple formulas, and formatting$($Color Fill, Font Color, Indent$)$

Lesson Instructions

Background: You will be completing a Profit$/$Loss Projections worksheet for the Titan Off$-$Campus Shops. The

worksheet you will use is the L$3\_$Titan$\_$Profit$\_$Loss$\_$Projections file. The income has been provided for you, it

will be your job to calculate all the projected expenses and profit for the year. Open it and complete the

following instructions. $($Note: when no specific cell reference is given, you are to use your best judgement

based upon how the worksheet is set up for you to decide what cells are involved or where a result should be

placed.$)$

$1.$ Re$-$save the file to either your desktop or other storage device using the name

$$firstName$\_$LastName$\_$L$3\_$Titan$\_$Profit$\_$Loss$\_$Projections$.($Note firstName and LastName are your

own first and last names$).$

$2.$ Fill the Total Income, Total Expenses, and Profit$/$Loss rows with Yellow $($through column N$).$

$3.$ Under Income, indent the two income categories two spaces $($Sales and Interest$).$ Under Expenses,

indent the six expense categories two spaces.

$4.$ Under Assumptions, insert a blank row above Bonus $\%$ and type in $$Target for Bonus$,$ then next to it in

B$29$ type in $$35,000.$

$5.$ Using a function, calculate the Total Sales and Total Interest for the year.

$6.$ Using a formula, calculate the Total Income for January $($Sales plus Interest$),$ and copy this across for

the remaining months and year total.

$7.$ Calculate the projected expenses $($rows $12$ through $16$ excluding Bonuses$)$ which are based upon the

percentages under the assumptions as a portion of the Sales amount which appears under Income.

$$ Starting with the Product expenses for January, you will multiply the Sales for January by the

Product $\%$ under assumptions.

$$ You will then copy this formula across for the additional months.