Excel 3

What is the keyboard shortcut key to lock cell references in a formula?

• CTRL

• ALT

• F2

• F4

What are the shortcut keys for AutoSum?

• ALT and S

• CTRL and S

• ALT and =

• CTRL and =

Which of the following is the correct formula to calculate the weighted average score in cell C8 as shown below?

• =SUMPRODUCT(C2:C5,B2:B5)

• =SUMPRODUCT(C2:C4,B2:B4)

• =AVERAGE(B2:B4)

• =AVERAGE(C2:C4)

Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown below?

• =IF(B2>=E2,"Accept","Reject")

• =IF(B2>=$E2,"Accept","Reject")

• =IF(B2>=E$2,"Accept","Reject")

• =IF(B2>=$E$2,"Accept","Reject")

What are the shortcut keys to insert a new row in an Excel spreadsheet?

• ALT + H + I + R

• ALT + H + I + C

• ALT + H + I + I

• ALT + H + I + S

Which of the following Excel features allows you to select/highlight all cells that are formulas?

• Find

• Replace

• Go To

• Go To Special

What formula should be entered in cell A3 to display the results as shown below?

• ="Income Statement"&A1

• ="Income Statement "&A1

• ="Income Statement "+A1

• ="Income Statement "&"A1"

What formula can be used in cell G2 to create a dynamic date which shows the last day of each month?

• =EOMONTH($B$2,B1)

• =EOMONTH($B$2,G1)

• =EOMONTH($B$2,C1)

• =MONTH($G$2)

Assuming cell A1 is displaying the number "12000.7789". What formula should be used to round this number to the closest integer?

• =MROUND(A1,100)

• =MROUND(A1,10)

• =ROUND(A1,0)

• =ROUND(A1,1)

What are the keyboard shortcut keys to edit formula in a cell?

• F2

• F4

• CTRL + 1

• CTRL + F