# Excel Certification - Group Report

This report groups results for test takers matching the following search criteria:**Course:**REFM Excel For Real Estate Certification Level One

**Date Range:** 12/3/2018 - 1/30/2019

To view the full questions, visit the test here.

## Test taker data

Name | Date | Questions Correct | Grade |
---|

## Number of correct responses - by question

###### 1: How should assumptions, or inputs, be formatted?

0/0 (NAN% correct)

###### 2: Each formula written in an Excel pro forma should begin using what symbol?

0/0 (NAN% correct)

###### 3: To apply the Currency format with two decimal places, the following keyboard shortcut can be used:

0/0 (NAN% correct)

###### 4: Which of the following formula would yield the sum of the cells in column J between rows 1 and 8, inclusive:

0/0 (NAN% correct)

###### 5: Which of the following formulas would produce the value 230.00 in cell E6 of the table?

0/0 (NAN% correct)

###### 6: Which of the following formulas would produce the value 236.00 in cell E6 of the table?

0/0 (NAN% correct)

###### 7: Which of the following formulas would produce the value 240.00 in cell E6 of the table?

0/0 (NAN% correct)

###### 8: Which of the following transfers cell data and characteristics to other parts of a spreadsheet while potentially only including values, formulas or formats?

0/0 (NAN% correct)

###### 9: If the contents of Cell A1 displayed 1/1/2010, then the formula =EOMONTH(A1,4) would produce which of the following dates?

0/0 (NAN% correct)

###### 10: If the contents of Cell A1 contain the value 1/17/2010, then the Formula =EDATE(A1,2) would produce which of following dates?

0/0 (NAN% correct)

###### 11: The value 47,443.443438 is located in cell D5. Please select the appropriate code to round down the value to the thousandths place:

0/0 (NAN% correct)

###### 12: Choose the formula that calculates the Net Present Value of the entire stream of cash flows.

0/0 (NAN% correct)

###### 13: Choose the formula that will produce the % of the total budget spent in Month #6 for a 9-month construction schedule.

0/0 (NAN% correct)

###### 14: Choose the formula that will pull in the NOI in Year 4.

0/0 (NAN% correct)

###### 15: In row 16, you would like to see the number of Pre-Sales units sold in the months in which pre-sales occur. Otherwise, return a 0. What is the correct formula to put in cell C16?

0/0 (NAN% correct)

###### 16: You wish for the cells in the Unit Sales Forecast table in row 16 to read "Yes" if it is a month of either pre-sales or regular sales. Otherwise, return no text. Choose the correct formula for cell C16.

0/0 (NAN% correct)

###### 17: Select the formula that will calculate the Present Value of Year 4 Cash Flow.

0/0 (NAN% correct)

###### 18: Which of the following formulas will calculate the Internal Rate of Return of the cash flows?

0/0 (NAN% correct)

###### 19: Which of the following formulas will calculate the Internal Rate of Return of the cash flows?

0/0 (NAN% correct)

###### 20: You wish for cell D1 to read "2-Bedroom" if the average of array A2:E2 is between 1000 and 1500. If not, "1-Bedroom". Please choose the appropriate formula to place in cell D1.

0/0 (NAN% correct)

###### 21: You wish for cell A3 to read "Go" if cell A1 equals a positive value less than 7 and B3 equals 5 or 6. If not, no text. Please select the appropriate formula.

0/0 (NAN% correct)

###### 22: Please select the phrase which corresponds to the following formula: =IF(AND(D11=0, D10=1), "Ready","")

0/0 (NAN% correct)

###### 23: Please select the phrase which corresponds to the following formula: =IF(B2>5,10,SUM(D5,D7))

0/0 (NAN% correct)

###### 24: Which of the formulas represents the Present Value of year 4 cash flow?

0/0 (NAN% correct)

###### 25: Which of the formulas below represents the Discount Factor by which the year 3 value is divided to get its Present Value?

0/0 (NAN% correct)

###### 26: Choose the formula that calculates the Monthly Payment of the amortizing mortgage loan.

0/0 (NAN% correct)

###### 27: What are three different ways to calculate the Interest Portion of the monthly payment of an amortizing loan?

0/0 (NAN% correct)

###### 28: In each successive period of an Amortizing loan, the following will occur simultaneously:

0/0 (NAN% correct)

###### 29: In an Amortizing loan, which of the following formulas will determine the Total monthly obligation to the lender?

0/0 (NAN% correct)

###### 30: In an Amortizing loan, the monthly payments made to the lender include which of the following?

0/0 (NAN% correct)

###### 31: In a 30-year Amortizing loan with monthly payments, if the Loan Amount is $40,280, and the monthly interest rate is 0.6%, what is the Interest Portion of the Total monthly payment in Month 1 (rounded to the nearest dollar)?

0/0 (NAN% correct)

###### 32: In an Amortizing loan, the Total monthly payment ____ over the term of the loan.

0/0 (NAN% correct)

###### 33: In an Amortizing loan, which of the following functions will calculate the portion of the monthly payment dedicated to the repayment of the loan's Principal?

0/0 (NAN% correct)

###### 34: In an Amortizing loan, which of the following formulas will calculate the Interest portion of the loan's monthly payment?

0/0 (NAN% correct)

###### 35: Choose the formula that calculates the Principal Portion of the amortizing mortgage loan in month 3 of the table.

0/0 (NAN% correct)

###### 36: You wish to build a Sensitivity Table for the Capitalized Value by varying the Rent PSF and the Capitalization Rate. Which of the following is the appropriate range to highlight in order to run the Data Table function?

0/0 (NAN% correct)

###### 37: You wish to create a data table that will show how the capitalized value will change at different rent levels and different capitalization rates. Which value in the Table below should you place into cell F3 in order to do so?

0/0 (NAN% correct)

###### 38: You have linked the Capitalized Value in cell D9 into cell F3 and highlighted the appropriate Data Range. You then click "Data Table" under the "What If" analysis. The dialog box requires the Row Input Cell and the Column Input Cell. Assuming you are varying the Rent PSF against the Cap Rate as shown in columns F through K, which of the following cells is the Row Input Cell?

0/0 (NAN% correct)

###### 39: You have linked the Capitalized Value in cell D9 into cell F3 and highlighted the appropriate Data Range. You then select "Data Table" under the "What If" analysis. The dialog box requires the Row Input cell and the Column Input Cell. What of the following cells is the Column Input Cell?

0/0 (NAN% correct)

## Number of correct responses - by category

###### formatting best practices

0/0 (NAN% correct)

###### Level 1 Test REFM Excel For Real Estate Certification

0/0 (NAN% correct)

###### formula basics

0/0 (NAN% correct)

###### keyboard shortcuts

0/0 (NAN% correct)

###### SUM function

0/0 (NAN% correct)

###### rounding to less precision

0/0 (NAN% correct)

###### rounding to whole number

0/0 (NAN% correct)

###### paste special

0/0 (NAN% correct)

###### EOMONTH function

0/0 (NAN% correct)

###### EDATE function

0/0 (NAN% correct)

###### NPV function

0/0 (NAN% correct)

###### VLOOKUP function

0/0 (NAN% correct)

###### HLOOKUP function

0/0 (NAN% correct)

###### IF(AND compound function

0/0 (NAN% correct)

###### IF(OR compound function

0/0 (NAN% correct)

###### PV function

0/0 (NAN% correct)

###### XIRR function

0/0 (NAN% correct)

###### IRR function

0/0 (NAN% correct)

###### IF(AND(OR compound function

0/0 (NAN% correct)

###### IF function

0/0 (NAN% correct)

###### PMT function

0/0 (NAN% correct)

###### amortization table

0/0 (NAN% correct)

###### PPMT function

0/0 (NAN% correct)

###### IPMT function

0/0 (NAN% correct)

###### data tables

0/0 (NAN% correct)