WGU C268 2026 MICROSOFT EXCEL
DATA ANALYSIS REVIEW PAPER ANSWERS
COMPLETE LEARNING PACK
◉ Use the IF function to complete the "Time Bonus $" column of
table 1. If an employee earns a time bonus (i.e., the corresponding
cell in the "Time Bonus?" column is TRUE), then "Time Bonus $" is
the "Job Pay" for that project times the bonus percentage in cell M11.
Otherwise "Time Bonus $" is 0.
Answer: =IF(I16=True, K16*$M$11,0)
◉ Use the IF function to complete the "Comments" column of table
1. Display "Good Job" if both the "Hours Worked" are less than or
equal to the "Estimated Hours" for a project and the assessed
"Quality" of that project is greater than 1. Display "Too Much Time" if
the "Hours Worked" on a project exceed the "Estimated Hours" for
that project; otherwise, display "Poor Quality."
Answer: =IF(E17>C17, "PoorQuality","Too MuchTime"
◉ Use the Vlookup Function to complete the "employee" column of
table 2. Use "job Id" from table 2 as your lookup_value(s) and table 1
as your reference.
Answer: =vlookup(B40,$B$16:$1$35,3,0)
DATA ANALYSIS REVIEW PAPER ANSWERS
COMPLETE LEARNING PACK
◉ Use the IF function to complete the "Time Bonus $" column of
table 1. If an employee earns a time bonus (i.e., the corresponding
cell in the "Time Bonus?" column is TRUE), then "Time Bonus $" is
the "Job Pay" for that project times the bonus percentage in cell M11.
Otherwise "Time Bonus $" is 0.
Answer: =IF(I16=True, K16*$M$11,0)
◉ Use the IF function to complete the "Comments" column of table
1. Display "Good Job" if both the "Hours Worked" are less than or
equal to the "Estimated Hours" for a project and the assessed
"Quality" of that project is greater than 1. Display "Too Much Time" if
the "Hours Worked" on a project exceed the "Estimated Hours" for
that project; otherwise, display "Poor Quality."
Answer: =IF(E17>C17, "PoorQuality","Too MuchTime"
◉ Use the Vlookup Function to complete the "employee" column of
table 2. Use "job Id" from table 2 as your lookup_value(s) and table 1
as your reference.
Answer: =vlookup(B40,$B$16:$1$35,3,0)
