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
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...
20 questions
Business Writing 2
Quiz
•
Professional Development
20 questions
DEPUTI PERKOPERASIAN
Quiz
•
Professional Development
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
Discover more resources for Professional Development
20 questions
Black History Month Trivia Game #1
Quiz
•
Professional Development
100 questions
Screening Test Customer Service
Quiz
•
Professional Development
20 questions
90s Cartoons
Quiz
•
Professional Development
10 questions
Reading a ruler in Inches
Quiz
•
4th Grade - Professio...
16 questions
Parallel, Perpendicular, and Intersecting Lines
Quiz
•
KG - Professional Dev...
12 questions
Valentines Day Trivia
Quiz
•
Professional Development
