Day 2 Excel Quiz
Authored by Eduardo Edralin
Computers
Professional Development
Used 7+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
1. What is the keyboard shortcut key to lock cell references in a formula?
CTRL
ALT
F2
F4
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are the shortcut keys for AutoSum?
ALT and S
CTRL and S
ALT and =
CTRL and =
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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")
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are the keyboard shortcut keys to edit formula in a cell?
F2
F4
CTRL + 1
CTRL + F
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The shortcut keys to increase the number of decimal places is
ALT + H + 9
ALT + H + P
ALT + H + D
ALT + H + 0
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
