WGU C268 Study Guide for EXCEL PA QUESTIONS AND VERIFIED CORRECT ANSWERS GRADED A+ -LATEST - GUARANTEED PASS.docx

WGU C268 Study Guide for
EXCEL PA QUESTIONS AND
VERIFIED CORRECT
ANSWERS GRADED A+
[LATEST] 100% GUARANTEED
PASS



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. -
CORRECT ANSWER-Yes



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. - CORRECT ANSWER-=HLOOKUP(D16, $E$11:$H$12, 2, 0)



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. - CORRECT 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. - CORRECT 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. - CORRECT 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." - CORRECT 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. - CORRECT ANSWER-
=vlookup(B40,$B$16:$1$35,3,0)



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. - CORRECT ANSWER-
=Vlookup(B40,$B$16:$H$35,6,0)



Use the Countif function to complete the #of Jobs, column in table 3. Reference the "employee"
names in table three as your criteria. - CORRECT ANSWER-=Countif(B16:D35,G39)



Use the SUMIF function to complete the "total hours" column in table 1 as your range and the
"employee" names in table three as your criteria. - CORRECT ANSWER-=sumif($D$16:D35, 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. - CORRECT ANSWER-
=SUMIF($D$16:$D$35,G39,$K$16:$K$K35)



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. -
CORRECT ANSWER-