WGU C268 SPREADSHEETS FINAL OA COMPLETE TEST PAPER WITH CORRECT ANSWERS

WGU C268 SPREADSHEETS FINAL OA
COMPLETE TEST PAPER WITH CORRECT
ANSWERS

◉ Assume you have made the first 36 payments on your loan. You
want to trade the car in for a new car. You believe that you can sell
your car for $4000. Will this cover the balance remaining on the car
in period 36? Answer either "Yes" or "No" in cell G15 from the drop-
down menu. (Amortization)
Answer: No


◉ Use the HLOOKUP function to complete the "Hourly Wage"
column of table 1. Use the "Employee" column of table 1 as the
lookup_value and the "Employee Wage Information" above table 1 as
your reference table. (Four J)
Answer: =HLOOKUP(D16,$E$11:$H$12,2,FALSE)


◉ Use the AND function to complete the "Time Bonus?" column of
table 1. An employee earns a time bonus if the project's "Hours
Worked" are fewer than the "Estimated Hours" and if the work
"Quality" is greater than 1. (Four J)
Answer: =AND(E16<C16,H16>1)

,◉ Use the OR function to complete the "Outcome Bonus?" column of
table 1. An employee earns an outcome bonus if the difficulty of a
job is greater than 3 or if the quality of their work is equal to 3. (Four
J)
Answer: =OR(G16>3,H16=3)


◉ 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. (Four J)
Answer: =IF(I16,K16*$M$11,0)


◉ Use the IF function to complete the "Outcome Bonus $" column of
table 1. If an employee earns an outcome bonus (i.e., the
corresponding cell in the "Outcome Bonus?" column is TRUE), then
"Outcome Bonus $" is the "Job Pay" for that project times the
outcome bonus percentage in cell M12; otherwise, "Outcome Bonus
$" is 0. (Four J)
Answer: =IF(J16,K16*$M$12,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." (Four J)
Answer: =IF(AND(E16<=C16,H16>1),"Good Job",IF(E16>C16,"Too
Much time","Poor Quality"))


◉ 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 the reference table. (Four J)
Answer: =VLOOKUP(B40,$B$16:$O$35,3,FALSE)


◉ Use the VLOOKUP function to complete the "Difficulty" column of
table 2. Again, use "Job ID" from table 2 as the lookup_value(s) and
table 1 as the reference table. (Four J)
Answer: =VLOOKUP(B40,$B$16:$O$35,6,FALSE)


◉ Use the COUNTIF function to complete the "# of Jobs" column in
table 3. Reference the appropriate field in table 1 as your range and
the "Employee" names in table 3 as your criteria. (Four J)
Answer: =COUNTIF($D$16:$D$35,G39)


◉ Use the SUMIF function to complete the "Total Hours" column in
table 3. Reference the appropriate field in table 1 as your range and
the "Employee" names in table 3 as your criteria. (Four J)
Answer: =SUMIF($D$16:$D$35,G39,$E$16:$E$35)