1|Page
WGU C268 SPREADSHEETS OA AND PA BANK
CURRENTLY TESTING COMPLETE EXAM QUESTIONS
WITH DETAILED VERIFIED ANSWERS ||VERIFIED
EXAM!!!ALREADY GRADED A+||NEWEST EXAM!!!
Check to see if the total interest calculation in the
amortization table is correct. The total interest paid is also
equal to the difference between the total amount paid over
the course of the loan and the original loan amount. Insert
a formula into cell G14 to calculate the difference between
the total amount paid and the original loan amount. Notice
the negative sign associated with the original loan amount.
This value should equal the total interest calculated using
the amortization table. - Answers-=G12+C11
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.
- Answers-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
,2|Page
Information" above table 1 as your reference table. -
Answers-=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. -
Answers-=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. - Answers-=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. - Answers-=IF(I16=True,
K16*M$11,0)
Use the IF function to complete the "Outcome Bonus $"
column of table 1. If an employee earns an outcome
, 3|Page
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. - Answers-=IF(J16=True, 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." - Answers-
=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 your reference. - Answers-
=vlookup(B40,B$16:D$35,3)
Calculate the payment amount for the loan in cell C15.
Reference the cells containing the appropriate loan
information as the arguments for the function you use.
Cells C20-C67 in the "Payment" column are populated
WGU C268 SPREADSHEETS OA AND PA BANK
CURRENTLY TESTING COMPLETE EXAM QUESTIONS
WITH DETAILED VERIFIED ANSWERS ||VERIFIED
EXAM!!!ALREADY GRADED A+||NEWEST EXAM!!!
Check to see if the total interest calculation in the
amortization table is correct. The total interest paid is also
equal to the difference between the total amount paid over
the course of the loan and the original loan amount. Insert
a formula into cell G14 to calculate the difference between
the total amount paid and the original loan amount. Notice
the negative sign associated with the original loan amount.
This value should equal the total interest calculated using
the amortization table. - Answers-=G12+C11
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.
- Answers-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
,2|Page
Information" above table 1 as your reference table. -
Answers-=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. -
Answers-=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. - Answers-=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. - Answers-=IF(I16=True,
K16*M$11,0)
Use the IF function to complete the "Outcome Bonus $"
column of table 1. If an employee earns an outcome
, 3|Page
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. - Answers-=IF(J16=True, 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." - Answers-
=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 your reference. - Answers-
=vlookup(B40,B$16:D$35,3)
Calculate the payment amount for the loan in cell C15.
Reference the cells containing the appropriate loan
information as the arguments for the function you use.
Cells C20-C67 in the "Payment" column are populated
