WGU C268 FINAL EXAMS ACTUAL ALL QUESTIONS AND ANSWERS SURE

WGU C268 FINAL EXAMS ACTUAL ALL QUESTIONS
AND ANSWERS SURE A+
✔✔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. -
✔✔=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. -
✔✔=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. - ✔✔=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. - ✔✔=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. -
✔✔=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. - ✔✔=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. - ✔✔=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" rating in
table 4 as your criteria. - ✔✔=AVERAGEIF($G$16:$G$35,G46,$E$16:$E$35)

✔✔Use the LEN function in cell D10 to determine the number of characters in the
statement template in cell D9. - ✔✔=LEN(D9)

✔✔Use the SEARCH function in cell D11 to determine the position of the "#" character
in the statement template (cell D9). - ✔✔=SEARCH("#",D9)

✔✔Use the SEARCH function in cell D12 to determine the position of the "$" character
in the statement template (cell D9). - ✔✔=SEARCH("$",D9)

✔✔Use the LEFT function in cell D13 to return the text "I spent $" from the statement
template in cell D9. Refer to the location of the "$" character you calculated in cell D12
as the "num_char" argument for your function. - ✔✔=LEFT(D9,D12)

✔✔Use the MID function in cell D14 to return the text "at merchant #" from the
statement template in cell D9. Refer to the location of the "$" (in cell D12)—adjusted by
adding 1—as the "start_num" argument. Use the difference between the location of the
"#" character (in cell D11) and the "$" character (in cell D12) as the "num_char"
argument. - ✔✔=MID(D9,D12+1,D11-D12)

✔✔Use the RIGHT function in cell D15 to return the text "on:" from the statement
template in cell D9. Use the difference between the length of the statement template (in
cell D10) and the location of the "#" character (in cell D11) as the "num_char" argument.
- ✔✔=RIGHT(D9,D10-D11)

✔✔Use the MONTH function in cell E18 to calculate the month portion of the "Time
Stamp" in cell B18. Copy and paste your function down to complete the "Month" column
of the table. - ✔✔=MONTH(B18)