# Excel Fundamentals – Formulas for Finance -CFI Quiz Answer

In this free Excel tutorial, you will learn all the tips, tricks, shortcuts, functions, and formulas you need to be an Excel power user. This free Excel course is designed specifically for spreadsheet users who are already performing professional financial analysis and financial modeling or are looking to prep for a wall street career. Take CFI’s Excel crash course now to advance your career!

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)

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

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

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

• = “Income”&” “&”Statement”
• = “Income”&”Statement”
• =Income&Statement
• = “Income ”+”Statement”

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

• =TODAY()
• =12/14/2014
• 12/14/2014
• =DATE(2014,12,14)

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

Suppose the following formula is inputted into Excel:

=MROUND(1/4,100)

The output in the cell will be:

• 0
• 0.2500
• 0.25
• 1

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

• #NUM!
• 50
• 780
• 2000

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

• #VALUE!
• 1100
• 2600
• #NUM!

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

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

• A1
• \$A1
• A\$1
• \$A\$1

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

• error
• ok
• #NAME?
• 5

What is the correct syntax for the =YEARFRAC function?

• =YEARFRAC(basis,start_date,end_date)
• =YEARFRAC(start_date)
• =YEARFRAC(start_date,end_date,[basis])
• =YEARFRAC(end_date,start_date)

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

513.24

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

• 12/31/2021
• 12/31/2020
• 9/30/2017
• 12/31/2019

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

• ERROR
• OK
• TRUE
• FALSE