Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started