MIST EXCEL CHECKS EXAM 2025
BRAND NEW ACTUAL EXAM WITH
ANSWERS.
1. Consider the following VLOOKUP. What should you use as
your col_index_num? (assume that you plan to complete the
entire column) - correct answer -2
2. Consider the following XLOOKUP. What should you use as
your lookup array? (assume that you plan to complete the
entire column) - correct answer -$A$3:$A$4
3. Consider the following XLOOKUP. What should you use as
your return array? (assume that you plan to complete the entire
column) - correct answer -$B$3:$B$4
4. What is the future value of $1250 (today) after 5 years at 6%
APR compounded annually? Round to the nearest dollar. -
correct answer -$1,673