Assessment Review - Corporate Finance Institutehttps://cfi.brillium.com/Assess.aspx?guid=A54F589B4EDC49108A78461ABC25433E&a=R1 1/9Advanced Excel Formulas Course1 To return the value of the cell D8, the formula should be =OFFSET(A1, 1. , 2. ).Your Answer1. 72. 3Correct Answer1. 72. 3ExplanationA1 needs to move 7 rows down and 3 columns to the right to reach D8.2 To set up scenarios, you need to Òr
...[Show More]
Assessment Review - Corporate Finance Institute
https://cfi.brillium.com/Assess.aspx?guid=A54F589B4EDC49108A78461ABC25433E&a=R1 1/9
Advanced Excel Formulas Course
1 To return the value of the cell D8, the formula should be =OFFSET(A1, 1. , 2. ).
Your Answer
1. 7
2. 3
Correct Answer
1. 7
2. 3
Explanation
A1 needs to move 7 rows down and 3 columns to the right to reach D8.
2 To set up scenarios, you need to Òrst use ______ to set up a list, then ______ to set up the reference cell. Last
you need to use ______ to set up the cells that display the output results from the scenario.
Your Answer
Data validation; VLOOKUP; CHOOSE
Below is a scored review of your assessment. All questions are shown.
Correct Answer
Partially Correct
Incorrect Answer
12/22/2020 Assessment Review - Corporate Finance Institute
https://cfi.brillium.com/Assess.aspx?guid=A54F589B4EDC49108A78461ABC25433E&a=R1 2/9
ata a dat o ; OO U ; C OOS
Correct Answer
Data validation; VLOOKUP; CHOOSE
Explanation
None.
3 The 1. function calculates the repayment for a loan; the 2. function calculates the interest portion of the
loan repayment.
Your Answer
1. PMT
2. IPMT
Correct Answer
1. PMT
2. IPMT
Explanation
None.
4
Based on the image above, the dynamic formula that Ònds the XIRR of the 6th period would be: (must use
cell B1 to make formula dynamic)
=XIRR(B4:OFFSET(B4,0,_____),B3:OFFSET(B3,0,_____)) and the output would be _____ %.
Your Answer
B1-1, B1-1, 34.1%
[Show Less]