C268 Practice Exam Certification Evaluation 2026 Questions With Practice Solution Graded A+

C268 PRACTICE EXAM CERTIFICATION
EVALUATION 2026 QUESTIONS WITH
PRACTICE SOLUTION GRADED A+

◉ 4. 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)


◉ 4. 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=True, K16*M$12,0)


◉ 6. 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"))

,◉ 7. 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:D$35,3)


◉ 8. 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:H$35,6)


◉ 9. 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(B16:D35,G39)


◉ 10. 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)


◉ 11. 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)

, ◉ 12. 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)


◉ 13. 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)


◉ 14. 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" rating in table 4 as your
criteria. Answer: =AVERAGEIF(G$16:G$35,G46,E$16:E$35)


◉ GOOGLE 1. Construct a column chart to examine the total annual
revenue for Google, Inc. from 2003 to 2010, using the data in table 1
(range C12:J12). Format the chart with the title "Total Google
Revenue" and the years across the horizontal axis. Do not include a
legend. Note: in order for the grading engine to identify the chart for
grading, the title must be precisely, "Total Google Revenue" (without
the quotes). Answer: Drag from C12:J12 and click on quick analysis.
Click on bar graphs. Click on numbers below graph and click select
data. Click on edit drag on Table 1 (Quarters) =Google!$C$7:$J$7
(The Dates).