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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
5 questions
What is Presidents' Day?
Interactive video
•
10th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
20 questions
Mardi Gras History
Quiz
•
6th Grade - University
10 questions
The Roaring 20's Crash Course US History
Interactive video
•
11th Grade - University
17 questions
Review9_TEACHER
Quiz
•
University