Browse all free courses from CFI to advance your career as a world-class financial analyst. From accounting to finance, CFI has a wide range of free courses to help you start your career in corporate finance or move up the ladder in your field.

Corporate Finance Institute® (*CFI*) is the leading provider of online financial analyst certification programs. Our courses and programs have been delivered to hundreds of thousands of students from over 170 countries.

**Apply Link Below**

**What combination of keys will autofill highlighted cells to the right?**

**CTRL + R (PC and Mac)**- CTRL + D (PC and Mac)
- ALT + R (PC) / Alt + R (Mac)
- ATL + D (PC) / Alt + D (Mac)

**2) What combination of keys turns the value in a cell into a percentage?**

- ALT + P (PC) / Ctrl + P (Mac)
- CTRL + H (PC) / Command + H (Mac)
- ALT + M (PC) / Ctrl + M (Mac)
**ALT + H + P (PC) / Ctrl + Shift + % (Mac)**

**3) Which of the following formulas properly produces the string “Income Statement”?**

- = “Income”&”Statement”
**= “Income”&” “&”Statement”**- =Income&Statement
- = “Income ”+”Statement”

**4) Suppose today is December 14, 2014. Which of the following functions will NOT return 12/14/2014 as a date?**

- =TODAY()
- =DATE(2014,12,14)
**=12/14/2014**- 12/14/2014

**5) Given the above screenshot, which of the following formulas will NOT produce the correct weighted average of 7,751 as in cell D10?**

**=D8/C8**- =(C3*D3+C4*D4+C5*D5+C6*D6+C7*D7)/C8
- =SUMPRODUCT(C3:C7,D3:D7)/SUM(C3:C7)
- =SUMPRODUCT(C3:C7,D3:D7)/C8

**6) Suppose the following formula is inputted into Excel:**

**=MROUND(1/4,100)**

**The output in the cell will be:**

- 1
- 0.2500
- 0.25
**0**

**7) Given the above screenshot, suppose =SMALL(C2:C6,4) is entered into cell C9. What output will result from this formula?**

- 2000
- 50
- #NUM!
**780**

**8) Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of this formula?**

- #NUM!
**2600**- 1100
- #VALUE!

**9) According to the information mentioned in the course, which of the following color schemes is best practice for financial modeling?**

- Hard Codes in Black, Hard Codes in Red
- Hard Codes in Red, Formulas in Black
**Hard Codes in Blue, Formulas in Black**- Hard Codes in Black, Formulas in Blue

**10) Which of the following formulas correctly anchors ONLY the row in cell A1?**

- $A$1
- $A1
**A$1**- A1

**11) What is the result of inputting =IF(5>9,ok,error) into a cell?**

- 5
- error
- ok
**#NAME?**

**12) What is the correct syntax for the =YEARFRAC function?**

- =YEARFRAC(end_date,start_date)
- =YEARFRAC(start_date)
**=YEARFRAC(start_date,end_date,[basis])**- =YEARFRAC(basis,start_date,end_date)

**13) The result of =ROUND(513.2413,2) is __**

513.24

**14) Given the above screenshot, which of the following is the resulting value in cell G2?**

**12/31/2020**- 9/30/2017
- 12/31/2021
- 12/31/2019

**15) Given the above screenshot, what is the resulting value in cell D22?**

- TRUE
**FALSE**- OK
- ERROR

Great step by mam for students.

We thanks alot mam for all their countless efforts.