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

a. Home

b. Insert

c. Data

d. Review

e. Formulas

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

a. =A1

b. =$A$1

c. =A$1

d. =$A1

e. =$A$1$

3. How do you access the number format?

a. Ctrl + 1

b. Ctrl + 3

c. Ctrl + F

d. Ctrl + S

e. Alt + HBC

4. Where should you orientate your Assumptions on the worksheet?

a. Left Side

b. Right Side

c. Top

d. Bottom

e. User Preference

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

True

False

6)

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

a. 9 Columns

b. 8 Columns

c. 7 Columns

d. 11 Columns

e. 10 Columns

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

a. General

b. Capital

c. Debt

d. Operating Expense

e. Exit Assumptions

8) What does "Above/Below the Line" refer to?

a. NOI

b. NCF

c. Debt

d. Capital

e. Returns