WGU C268 SPREADSHEETS FINAL PAPER TEST
BANK QUESTIONS AND DETAILED ANSWERS
2026
◉ HLOOKUP function. 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. 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
BANK QUESTIONS AND DETAILED ANSWERS
2026
◉ HLOOKUP function. 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. 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
