Excel - Exam 2
Quiz
•
Professional Development
•
Professional Development
•
Practice Problem
•
Medium
Gabriel Curiel
Used 7+ times
FREE Resource
Enhance your content in a minute
21 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Which formula will calculate the amount the gross salary for employee 1?
=B4*C4
=B4+C4
=B4:C4
=(B4:C4)*C4
2.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Which formula will provide the right calculation for employee payout?
=IF(B4="OFF",0,C4*B4)
=IF(B4=OFF,0,C4*B4)
=IF(B4="OFF",C4*B4,0)
=IF(B4=OFF,C4*B4,0)
3.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Which formula will calculate the amount of hours worked?
=(C4-B4)*24
=C4-B4
=C4*B4
=(C4-B4)*12
4.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Which formula will calculate the hours worked for employees?
=IF(C4="OFF",0,(C4-B4)*24)
=IF(C4=OFF,0,C4-B4)
=IF(C4="OFF",0,(C4-B4)*12)
=IF(C4=OFF,0,(C4-B4)*24)
5.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Given the information already present in the table. Which formula would you use to calculate the proper pay?
=D4*E4
=IF(C4="OFF",E4*D4,0)
=C4-B4
=(C4-B4)*E4
6.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Considering that employees can sometimes work over 40 hours and as such, work overtime. Which formula would you put in this table to determine overtime hours? (determines ONLY the overtime hours)
=IF(B5>40,0,40-B5)
=IF(B5>40,40-B5,0)
=B5-40
=40-B5
7.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Which formula would calculate the pay? knowing that regular working week is 40 hours
=IF(B5>40,((40*C5)+(B5-40)*C5*1.5),B5*C5)
=IF(B5>40,((40*C5)+(B5-40)*C5),B5*C5)
=IF(B5<40,((40*C5)+(40-B5)*C5),0)
=IF(B5<40,((40*C5)+(40-B5)*C5),B5*C5)
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
20 questions
Business Writing 2
Quiz
•
Professional Development
20 questions
DEPUTI PERKOPERASIAN
Quiz
•
Professional Development
19 questions
Orders Unit 8 Level 2
Quiz
•
University - Professi...
20 questions
Leadership and Management in Schools
Quiz
•
Professional Development
20 questions
90's Quiz
Quiz
•
Professional Development
20 questions
La sintassi CSS
Quiz
•
9th Grade - Professio...
20 questions
Day #4 : Komponen Pengurang Gaji Karyawan
Quiz
•
Professional Development
17 questions
L3 AP Cold water P2
Quiz
•
University - Professi...
Popular Resources on Wayground
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
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
