Excel Assignment $1$:

Using the raw data provide, please prepare a summary sale report for the year $2014.($fill in the yellowhighlighted areas; $10$ points$)$

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|\}$

$\backslash$hline Sales$\_$Year & $\backslash (\backslash$mathbf$\{2014\}\backslash )$ & $\backslash \backslash$

$\backslash$hline Real Estate Financing Types & Sum of Sales $(\backslash$$$)$ & $\backslash$# Deals $\backslash \backslash$

$\backslash$hline $10-$year mortgage loan & & $\backslash \backslash$

$\backslash$hline $15-$year mortgage loan & & $\backslash \backslash$

$\backslash$hline $3-$year mortgage loan & & $\backslash \backslash$

$\backslash$hline $5-$year mortgage loan & & $\backslash \backslash$

$\backslash$hline $7-$year mortgage loan & & $\backslash \backslash$

$\backslash$hline Adjustable loan & & $\backslash \backslash$

$\backslash$hline Interest Only & & $\backslash \backslash$

$\backslash$hline Un$-$defined property & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$