$1.$ Which tab in Excel is used do Goal Seeks and Data Tables?

Home

Insert

Data

Review

Formulas

$2.$ Which of the following cells would be a column locked cell?

$=$A$1$

$=$$A$$1$

$=$A$$1$

$=$$A$1$

$=$$A$$1$$

$3.$ How do you access the number format?

Ctrl $+1$

Ctrl $+3$

Ctrl $+$ F

Ctrl $+$ S

Alt $+$ HBC

$4.$What does EGI stand for?

Ending Gross Income

Eventual Grand Interest

Effective Gross Income

Eventual Gross Income

Ending Grand Income

$5.$True or False: Vacancy should be applied off of the EGI.

True

False

$6.$If you had a hold period of $8$ years, how many columns $($one column per year$)$ would you have in the model?

$9$ Columns

$8$ Columns

$7$ Columns

$11$ Columns

$10$ Columns

$7.$Which category should you lead with when creating your assumptions?

General

Capital

Debt

Operating Expense

Exit Assumptions