Day 2 Excel Quiz

1. 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")

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

The shortcut keys to increase the number of decimal places is

• ALT + H + 9

• ALT + H + P

• ALT + H + D

• ALT + H + 0

What is the shortcut keys to open up the Find and Replace window? (Aside from CTRL + H)

• ALT + H + FD + R

• CTRL + FD

• CTRL + FD

• ALT + H + FD

Suppose a company expected its revenue to be $180,000 for 2014-2018. What formula should be entered in cell E6 so it displays revenue in 2016 if it was above budget, otherwise it'll show 0?

• =IF(E2<$B$6,E2,0)

• =IF(E2<$B$6,0,E2)

• =IF(E2>$B$6,E2,0)

• =IF(E2>$B$6,0,E2)

What is the keyboard shortcut keys to insert a table?

• ALT + N + R

• ALT + N + C

• ALT + N + V

• ALT + N + T