NEW
Font size
WorksheetsDay 2 Excel Quiz
Total questions: 10
Worksheet time: 5mins
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
