Ms. Excel and Ms. Access Revision
Authored by Dr. Nurul Farhaini Razali undefined
Computers
University
Used 25+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
What is the VLOOKUP formula to find the last name for Mary?
=VLOOKUP(H6,A4:E20,2,FALSE)
=VLOOKUP(A4,A4:E20,1,FALSE)
=VLOOKUP(B4,A4:A20,1,FALSE)
=VLOOKUP(H6,A4:E20,1,FALSE)
2.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
What is the VLOOKUP for Mary's employment status?
=VLOOKUP(C4,C4:E20,2,FALSE)
=VLOOKUP(C4,C4:E20,3,FALSE)
=VLOOKUP(C4,C4:E20,1,FALSE)
=VLOOKUP(B4,C4:E20,1,FALSE)
3.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
What is the formula for Today's date?
=TODAY ( )
=NOW ( )
=DAY ( )
=DATE ( )
4.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
What is the formula to find bonus status for Jose Grimes?
=IF(C20=$C$5,"No Bonus")
=IF(C20=$C$5,"Bonus")
=IF(C20=$C$5,"Bonus",No Bonus)
=IF(C20=$C$5,"Bonus","No Bonus")
5.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
What is the formula to calculate total salaries?
=SUM(E4:E20)
=SUM(E4/E20)
=SUM(E4*E20)
=SUM(E4+E20)
6.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
What is the formula to Count for Full Time?
=COUNTIF(C4:C20,Full Time)
=COUNTIF(C4:C20,"Full Time")
=COUNTIF(B4:B20,"Full Time")
=COUNTIF(A4:A20,"Full Time")
7.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
What is the formula to Sum for Part Time?
=SUMIF(C4:C20,"Part Time",E4:E20)
=SUMIF(C4:C20,"Part Time")
=SUMIF(C4:C20,Part Time,E4:E20)
=SUMIF("Part Time",E4:E20)
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
Already have an account?
