WGU C268 Spreadsheets Questions and Answers (2025 / 2026) (Verified Answers)

WGU C268 Spreadsheets Questions and Answers (2025
/ 2026) (Verified 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. - 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. - 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. - 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. - 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. - 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. - 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." - 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. -
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. - 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. - 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. - ANSWER-=SUMIF($D$16:$D$35,G39,$E$16:$E$35)


Use the SUMIF function to complete the "Total Pay" column in table 3. Reference
the "Employee" field in table 1 as your range, the "Employee" names in table 3 as
your criteria, and the "Total Pay" field in table 1 as your sum_range. - ANSWER-
=SUMIF($D$16:$D$35,G39,$N$16:$N$35)


Use the COUNTIF function to complete the "# of Touch-ups" column in table 4.
Reference the appropriate field in table 2 as your range and the "Difficulty" rating
in table 4 as your criteria. - ANSWER-=COUNTIF($D$40:$D$46,G46)


Use the SUMIF function to complete the "Cost Touch-ups" column in table 4.
Reference the appropriate field in table 2 as your range and the "Difficulty" rating
in table 4 as your criteria. - ANSWER-=SUMIF($D$40:$D$46,G46,$E$40:$E$46)


Use the AVERAGEIF function to complete the "Average Hours/Job" column in table
4. Reference the appropriate field in table 1 as your range and the "Difficulty"