CFI Assessment
According to the information mentioned in the course, which of the following color schemes
is best practice for financial modeling?
a) Hard Codes in Black, Hard Codes in Red
b) Hard Codes in Black, Formulas in Blue
c) Hard Codes in Red, Formulas in Black
d) Hard Codes in Blue, Formulas in Black - ANS-d) Hard Codes in Blue, Formulas in Black
Given the above screenshot, suppose =SMALL(C2:C6,4) is entered into cell C9. What
output will result from this formula?
a) 2000
b) 780
c) 50
d) #NUM! - ANS-b) 780
Given the above screenshot, what is the resulting value in cell D22?
a) ERROR
b) FALSE
c) TRUE
d) OK - ANS-b) FALSE
Given the above screenshot, which of the following formulas will NOT produce the correct
weighted average of 7,751 as in cell D10?
a) =D8/C8
b) =SUMPRODUCT(C3:C7,D3:D7)/SUM(C3:C7)
c) =SUMPRODUCT(C3:C7,D3:D7)/C8
d) =(C3*D3+C4*D4+C5*D5+C6*D6+C7*D7)/C8 - ANS-a) =D8/C8
Given the above screenshot, which of the following is the resulting value in cell G2?
a) 9/30/2017
b) 12/31/2020
c) 12/31/2019
d) 12/31/2021 - ANS-b) 12/31/2020
Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of
this formula?
a) 2600
b) 1100
According to the information mentioned in the course, which of the following color schemes
is best practice for financial modeling?
a) Hard Codes in Black, Hard Codes in Red
b) Hard Codes in Black, Formulas in Blue
c) Hard Codes in Red, Formulas in Black
d) Hard Codes in Blue, Formulas in Black - ANS-d) Hard Codes in Blue, Formulas in Black
Given the above screenshot, suppose =SMALL(C2:C6,4) is entered into cell C9. What
output will result from this formula?
a) 2000
b) 780
c) 50
d) #NUM! - ANS-b) 780
Given the above screenshot, what is the resulting value in cell D22?
a) ERROR
b) FALSE
c) TRUE
d) OK - ANS-b) FALSE
Given the above screenshot, which of the following formulas will NOT produce the correct
weighted average of 7,751 as in cell D10?
a) =D8/C8
b) =SUMPRODUCT(C3:C7,D3:D7)/SUM(C3:C7)
c) =SUMPRODUCT(C3:C7,D3:D7)/C8
d) =(C3*D3+C4*D4+C5*D5+C6*D6+C7*D7)/C8 - ANS-a) =D8/C8
Given the above screenshot, which of the following is the resulting value in cell G2?
a) 9/30/2017
b) 12/31/2020
c) 12/31/2019
d) 12/31/2021 - ANS-b) 12/31/2020
Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of
this formula?
a) 2600
b) 1100
