WGU C268 Study Guide for EXCEL PA – Practice Questions and Answers 2026

WGU C268 Study Guide for EXCEL PA – Practice Questions and Answers 2026 Question 1 A student is creating an amortization table in Excel and needs to calculate the monthly payment amount. The loan amount is in cell A1, the annual interest rate is in cell A2, and the number of payment periods is in cell A3. Which formula should be used in cell A4 to calculate the payment amount? A) =PMT(A2,A3,A1) B) =PMT(A2/12,A3,A1) C) =PMT(A2,A3/12,A1) D) =PV(A2/12,A3,A1) Correct Answer: B) =PMT(A2/12,A3,A1) Rationale: The PMT function calculates loan payments and requires the monthly interest rate, which is the annual rate divided by 12. The number of periods and the loan amount are provided as the other arguments in the correct order. Question 2 In an amortization table, the interest amount for Period 2 should be calculated by: A) Multiplying the original loan amount by the monthly interest rate B) Multiplying the beginning balance of Period 2 by the monthly interest rate C) Subtracting the payment amount from the beginning balance of Period 2 D) Dividing the total interest paid by the number of periods Correct Answer: B) Multiplying the beginning balance of Period 2 by the monthly interest rate Rationale: The interest for any given period is calculated by multiplying the outstanding balance at the beginning of that period by the monthly interest rate. As payments are made, the principal decreases, reducing the interest portion of each subsequent payment. Question 3 What is the correct formula to calculate the principal portion of a payment in an amortization table where the payment amount is in cell C20 and the interest is in cell D20? A) =C20/D20 B) =C20*D20 C) =C20-D20 D) =C20+D20 Correct Answer: C) =C20-D20 Rationale: The principal portion of a loan payment is the remaining amount after the interest is deducted from the total payment. This represents the amount that reduces the outstanding loan balance. Question 4 In an amortization table, the ending balance for Period 1 should be calculated by: A) Adding the payment amount to the beginning balance B) Subtracting the payment amount from the beginning balance C) Subtracting the principal amount from the beginning balance D) Adding the principal amount to the beginning balance Correct Answer: C) Subtracting the principal amount from the beginning balance Rationale: The ending balance for a period is the beginning balance minus the principal amount paid during that period. The principal amount is the portion of the payment that reduces the outstanding loan balance. Question 5 A student needs to calculate the total interest paid over the life of a loan. Which approach would accomplish this? A) =C15*C12 B) =SUM(D20:D67) C) =SUM(C20:C67) D) =PMT(C13/12,C12,C11) Correct Answer: B) =SUM(D20:D67) Rationale: The total interest paid is the sum of all interest payments made over the life of the loan. Summing the interest column (D20:D67) will provide the correct total interest amount. Question 6 To verify the total interest calculation, a student can calculate total interest as: A) Total Amount Paid – Original Loan Amount B) Total Amount Paid + Original Loan Amount C) Original Loan Amount – Total Amount Paid D) Total Amount Paid × Original Loan Amount Correct Answer: A) Total Amount Paid – Original Loan Amount Rationale: The total interest paid is the difference between the total amount paid over the life of the loan and the original loan amount. This mathematical check validates the accuracy of the amortization table calculations. Question 7 In the HLOOKUP function =HLOOKUP(D16, E$11:H$12, 2, False), what does the “2” represent? A) The column in the table array to look up B) The row in the table array to return C) The range lookup value D) The employee name to search for Correct Answer: B) The row in the table array to return Rationale: In HLOOKUP, the row index number indicates which row of the table array contains the value to return. A value of 2 means the function will return the value from the second row of the lookup table. Question 8 Which function should a student use in Excel to determine if an employee qualifies for a time bonus based on two conditions: hours worked are fewer than estimated hours AND quality score is greater than 1? A) IF B) OR C) AND D) NOT Correct Answer: C) AND Rationale: The AND function tests multiple conditions simultaneously and returns TRUE only when all conditions are met. In this scenario, both conditions must be true for the employee to earn a time bonus. Question 9 An employee earns an outcome bonus if the difficulty of a job is greater than 3 OR if the quality of work is equal to 3. Which Excel function should be used? A) AND B) OR C) IF D) NOT Correct Answer: B) OR Rationale: The OR function returns TRUE if at least one of the specified conditions is true. This is the correct choice when a bonus can be earned under either of the described circumstances. Question 10 What is the purpose of the IF function in Excel as used in =IF(I16=True, K16*M$11, 0)? A) To determine if a time bonus should be calculated B) To lookup an employee’s hourly wage C) To calculate the total loan payment D) To sum all interest payments Correct Answer: A) To determine if a time bonus should be calculated Rationale: The IF function evaluates a logical test and returns one value if the test is true and another if the test is false. In this case, it checks if a time bonus is earned (TRUE) and calculates the bonus amount; otherwise, it returns 0.