C268 PRACTICE EXAM 200 QUESTIONS AND CORRECT
ANSWERS WITH RATIONALE LATEST 2026 ALREADY
GRADED A+
This comprehensive 200-question practice exam for the WGU C268
Spreadsheets course covers all essential Excel skills required for the Objective
Assessment. Questions address financial functions (PMT, RATE, NPER, PV,
FV, CUMIPMT, CUMPRINC, IRR, NPV), lookup functions (VLOOKUP,
HLOOKUP, XLOOKUP, INDEX, MATCH), logical functions (IF, AND, OR),
text functions (LEFT, RIGHT, MID, LEN, CONCAT, TEXTJOIN, TRIM),
date and time functions (DATE, TODAY, NOW, EDATE, EOMONTH,
NETWORKDAYS), statistical functions (AVERAGE, MEDIAN, MODE,
STDEV, VAR, CORREL), amortization tables, dynamic array functions
(FILTER, SORT, UNIQUE, SEQUENCE, RANDARRAY), and advanced
financial modeling concepts. Each question includes a detailed rationale
reinforcing spreadsheet principles essential for exam success and real-world
application.
1. Which Excel function calculates the monthly payment for a loan with a fixed
interest rate and fixed term?
A) RATE()
B) NPER()
C) PMT()
D) PV()
Answer: C
Rationale: The PMT function is used to calculate the periodic payment amount for
a loan based on a constant interest rate and constant payment period. It is one of
the most frequently tested functions on the C268 exam .
2. What is the correct syntax for the PMT function to calculate a monthly payment
when the annual interest rate is in cell C13, the number of months is in cell C12,
and the loan amount is in cell C11?
A) =PMT(C13, C12, C11)
B) =PMT(C13/12, C12, C11)
C) =PMT(C13, C12/12, C11)
D) =PMT(C13/12, C12*12, C11)
Answer: B
,Rationale: The first argument of the PMT function must be the interest rate per
period. When making monthly payments, the annual rate must be divided by 12 to
get the monthly rate .
3. How do you calculate the interest amount for a specific payment period in an
amortization table?
A) Multiply the current balance by the annual interest rate
B) Multiply the previous period's balance by the monthly interest rate
C) Subtract the principal from the payment amount
D) Multiply the payment amount by the number of periods
Answer: B
Rationale: For a given period, the interest is calculated by multiplying the balance
from the previous period by the monthly interest rate (annual rate divided by 12).
This formula should use an absolute reference for the interest rate cell to allow
copying down the column .
4. How is the principal amount calculated for a specific payment period in an
amortization table?
A) Payment amount minus the interest amount for that period
B) Payment amount plus the interest amount for that period
C) Previous balance minus the payment amount
D) Payment amount multiplied by the interest rate
Answer: A
Rationale: In an amortization table, each payment is split between interest and
principal. The principal amount is the difference between the total payment and the
interest for that period .
5. How is the remaining balance calculated for a specific payment period in an
amortization table?
A) Previous balance minus the principal amount for that period
B) Previous balance minus the interest amount for that period
C) Previous balance plus the principal amount for that period
D) Payment amount minus the interest amount
Answer: A
Rationale: The balance for each period is the previous period's balance minus the
principal paid in the current period. This follows the loan amortization process
where each payment reduces the outstanding balance .
6. What is the total amount paid over the life of a loan?
A) Payment amount divided by the loan term
,B) Payment amount multiplied by the loan term
C) Loan amount multiplied by the interest rate
D) Sum of all interest payments
Answer: B
Rationale: The total amount paid over the life of a loan is calculated by multiplying
the periodic payment amount by the total number of payments (the loan term in
periods) .
7. How is the total interest paid on a loan calculated using an amortization table?
A) Total amount paid minus the original loan amount
B) Total amount paid divided by the original loan amount
C) Original loan amount minus the total amount paid
D) Loan amount multiplied by the interest rate
Answer: A
Rationale: The total interest paid over the life of a loan is the difference between
the total amount paid (all payments combined) and the original loan amount. This
can also be calculated by summing the entire interest column in the amortization
table .
8. What is the primary function of the VLOOKUP function in Excel?
A) To search for data horizontally in a table
B) To search for data vertically in a table
C) To calculate the sum of a range
D) To create a logical IF statement
Answer: B
Rationale: VLOOKUP searches for a value in the leftmost column of a table and
returns a value in the same row from a specified column. It is a vertical lookup
function .
9. What is the primary function of the HLOOKUP function in Excel?
A) To search for data vertically in a table
B) To search for data horizontally in a table
C) To calculate the average of a range
D) To count cells in a range
Answer: B
Rationale: HLOOKUP searches for a value in the top row of a table and returns a
value from a specified row in the same column. It is a horizontal lookup function .
, 10. What is the correct syntax for a VLOOKUP function that looks up a value in
cell D16, references a table in cells E11 through H12, returns the value from the
second row of the table, and requires an exact match?
A) =VLOOKUP(D16, E11:H12, 2, TRUE)
B) =VLOOKUP(D16, E11:H12, 2, FALSE)
C) =VLOOKUP(D16, E11:H12, 1, FALSE)
D) =VLOOKUP(E11:H12, D16, 2, FALSE)
Answer: B
Rationale: The VLOOKUP syntax requires four arguments: lookup_value,
table_array, col_index_num (the column number from which to return a value),
and range_lookup (FALSE for exact match). Using FALSE ensures an exact match
is found .
11. What is the purpose of the IF function in Excel?
A) To calculate the sum of a range
B) To create a logical "If-Then" statement
C) To count cells with numbers
D) To find the average of a range
Answer: B
Rationale: The IF function creates a logical statement that returns one value if a
condition is true and another value if it is false. It is used for conditional logic in
spreadsheets .
12. Which function is used to combine multiple logical conditions, returning
TRUE only if all conditions are met?
A) OR()
B) AND()
C) IF()
D) SUMIF()
Answer: B
Rationale: The AND function evaluates multiple logical conditions and returns
TRUE only if all conditions evaluate to TRUE. It is often used inside an IF
function for complex logical tests .
13. Which function is used to combine multiple logical conditions, returning
TRUE if at least one condition is met?
A) AND()
B) OR()
C) IF()
D) NOT()
ANSWERS WITH RATIONALE LATEST 2026 ALREADY
GRADED A+
This comprehensive 200-question practice exam for the WGU C268
Spreadsheets course covers all essential Excel skills required for the Objective
Assessment. Questions address financial functions (PMT, RATE, NPER, PV,
FV, CUMIPMT, CUMPRINC, IRR, NPV), lookup functions (VLOOKUP,
HLOOKUP, XLOOKUP, INDEX, MATCH), logical functions (IF, AND, OR),
text functions (LEFT, RIGHT, MID, LEN, CONCAT, TEXTJOIN, TRIM),
date and time functions (DATE, TODAY, NOW, EDATE, EOMONTH,
NETWORKDAYS), statistical functions (AVERAGE, MEDIAN, MODE,
STDEV, VAR, CORREL), amortization tables, dynamic array functions
(FILTER, SORT, UNIQUE, SEQUENCE, RANDARRAY), and advanced
financial modeling concepts. Each question includes a detailed rationale
reinforcing spreadsheet principles essential for exam success and real-world
application.
1. Which Excel function calculates the monthly payment for a loan with a fixed
interest rate and fixed term?
A) RATE()
B) NPER()
C) PMT()
D) PV()
Answer: C
Rationale: The PMT function is used to calculate the periodic payment amount for
a loan based on a constant interest rate and constant payment period. It is one of
the most frequently tested functions on the C268 exam .
2. What is the correct syntax for the PMT function to calculate a monthly payment
when the annual interest rate is in cell C13, the number of months is in cell C12,
and the loan amount is in cell C11?
A) =PMT(C13, C12, C11)
B) =PMT(C13/12, C12, C11)
C) =PMT(C13, C12/12, C11)
D) =PMT(C13/12, C12*12, C11)
Answer: B
,Rationale: The first argument of the PMT function must be the interest rate per
period. When making monthly payments, the annual rate must be divided by 12 to
get the monthly rate .
3. How do you calculate the interest amount for a specific payment period in an
amortization table?
A) Multiply the current balance by the annual interest rate
B) Multiply the previous period's balance by the monthly interest rate
C) Subtract the principal from the payment amount
D) Multiply the payment amount by the number of periods
Answer: B
Rationale: For a given period, the interest is calculated by multiplying the balance
from the previous period by the monthly interest rate (annual rate divided by 12).
This formula should use an absolute reference for the interest rate cell to allow
copying down the column .
4. How is the principal amount calculated for a specific payment period in an
amortization table?
A) Payment amount minus the interest amount for that period
B) Payment amount plus the interest amount for that period
C) Previous balance minus the payment amount
D) Payment amount multiplied by the interest rate
Answer: A
Rationale: In an amortization table, each payment is split between interest and
principal. The principal amount is the difference between the total payment and the
interest for that period .
5. How is the remaining balance calculated for a specific payment period in an
amortization table?
A) Previous balance minus the principal amount for that period
B) Previous balance minus the interest amount for that period
C) Previous balance plus the principal amount for that period
D) Payment amount minus the interest amount
Answer: A
Rationale: The balance for each period is the previous period's balance minus the
principal paid in the current period. This follows the loan amortization process
where each payment reduces the outstanding balance .
6. What is the total amount paid over the life of a loan?
A) Payment amount divided by the loan term
,B) Payment amount multiplied by the loan term
C) Loan amount multiplied by the interest rate
D) Sum of all interest payments
Answer: B
Rationale: The total amount paid over the life of a loan is calculated by multiplying
the periodic payment amount by the total number of payments (the loan term in
periods) .
7. How is the total interest paid on a loan calculated using an amortization table?
A) Total amount paid minus the original loan amount
B) Total amount paid divided by the original loan amount
C) Original loan amount minus the total amount paid
D) Loan amount multiplied by the interest rate
Answer: A
Rationale: The total interest paid over the life of a loan is the difference between
the total amount paid (all payments combined) and the original loan amount. This
can also be calculated by summing the entire interest column in the amortization
table .
8. What is the primary function of the VLOOKUP function in Excel?
A) To search for data horizontally in a table
B) To search for data vertically in a table
C) To calculate the sum of a range
D) To create a logical IF statement
Answer: B
Rationale: VLOOKUP searches for a value in the leftmost column of a table and
returns a value in the same row from a specified column. It is a vertical lookup
function .
9. What is the primary function of the HLOOKUP function in Excel?
A) To search for data vertically in a table
B) To search for data horizontally in a table
C) To calculate the average of a range
D) To count cells in a range
Answer: B
Rationale: HLOOKUP searches for a value in the top row of a table and returns a
value from a specified row in the same column. It is a horizontal lookup function .
, 10. What is the correct syntax for a VLOOKUP function that looks up a value in
cell D16, references a table in cells E11 through H12, returns the value from the
second row of the table, and requires an exact match?
A) =VLOOKUP(D16, E11:H12, 2, TRUE)
B) =VLOOKUP(D16, E11:H12, 2, FALSE)
C) =VLOOKUP(D16, E11:H12, 1, FALSE)
D) =VLOOKUP(E11:H12, D16, 2, FALSE)
Answer: B
Rationale: The VLOOKUP syntax requires four arguments: lookup_value,
table_array, col_index_num (the column number from which to return a value),
and range_lookup (FALSE for exact match). Using FALSE ensures an exact match
is found .
11. What is the purpose of the IF function in Excel?
A) To calculate the sum of a range
B) To create a logical "If-Then" statement
C) To count cells with numbers
D) To find the average of a range
Answer: B
Rationale: The IF function creates a logical statement that returns one value if a
condition is true and another value if it is false. It is used for conditional logic in
spreadsheets .
12. Which function is used to combine multiple logical conditions, returning
TRUE only if all conditions are met?
A) OR()
B) AND()
C) IF()
D) SUMIF()
Answer: B
Rationale: The AND function evaluates multiple logical conditions and returns
TRUE only if all conditions evaluate to TRUE. It is often used inside an IF
function for complex logical tests .
13. Which function is used to combine multiple logical conditions, returning
TRUE if at least one condition is met?
A) AND()
B) OR()
C) IF()
D) NOT()
