WGU C268 Spreadsheets questions and answers 2026\2027 A+
Grade
PMT function
- correct answer calculates the periodic payment for a loan with a fixed interest rate and fixed term
=PMT(rate,nper,pv)
Interest rate (divided by 12 months), the number of payments to be made to pay off the loan, the
original loan amount.
HLOOKUP function
- correct answer A lookup function that searches horizontally across the top row of the lookup table and
retrieves the value in the column you specify.
=HLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
Lookup information, the location of the reference table, the column in the table that contains the
information that is returned, true if an approximate match is OK and FALSE if an approximate match is
not okay.
AND function
- correct answer Combines Boolean expressions to determine if ALL of the combined expressions are
TRUE.
=AND(logical1, [logical2],...)
First Boolean expression, second Boolean expression (as needed), additional Boolean expression(s) as
needed
Grade
PMT function
- correct answer calculates the periodic payment for a loan with a fixed interest rate and fixed term
=PMT(rate,nper,pv)
Interest rate (divided by 12 months), the number of payments to be made to pay off the loan, the
original loan amount.
HLOOKUP function
- correct answer A lookup function that searches horizontally across the top row of the lookup table and
retrieves the value in the column you specify.
=HLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
Lookup information, the location of the reference table, the column in the table that contains the
information that is returned, true if an approximate match is OK and FALSE if an approximate match is
not okay.
AND function
- correct answer Combines Boolean expressions to determine if ALL of the combined expressions are
TRUE.
=AND(logical1, [logical2],...)
First Boolean expression, second Boolean expression (as needed), additional Boolean expression(s) as
needed
