MIST 2090 EXCEL FORMULAS STUDY GUIDE | 2026 | GUARANTEED PASS

MIST 2090 EXCEL FORMULAS STUDY GUIDE | 2026 |
GUARANTEED PASS

AND - Answers -= AND (logical1, [logical2],...)

IF - Answers -= IF (logical test, [value if true], [value if false])

IFS - Answers -= IFS (logical test, value if true1, ...)

OR - Answers -= OR (logical1, [logical2], ...)

HLOOKUP - Answers -=HLOOKUP(lookup_value, table_array, row_index_number,
[range_lookup])

INDEX - Answers -= INDEX (array, row number, [column])

= INDEX (reference, row number,[column number], [area number])

MATCH - Answers -= MATCH (lookup value, lookup array, [match type])

VLOOKUP - Answers -=VLOOKUP(lookup_value, table_array, col_index_num,
[range_lookup])

XLOOKUP - Answers -= XLOOKUP (lookup value, lookup array, return array, [if not
found], [match mode], [search mode])

SUM - Answers -= SUM (number1, [number2], ...)

SUMIFS - Answers -=SUMIFS(sum range, criteria range 1, criteria 1, criteria range 2,
criteria 2)

AVERAGE - Answers -= AVERAGE (number1, [number2], ...)

AVERAGEIF - Answers -=AVERAGEIF(range, criteria, [average_range])

AVERAGEIFS - Answers -= AVERAGEIF (range, criteria, [average range])

COUNT - Answers -= COUNT (value1, [value2], ...)

COUNTA - Answers -= COUNTA (value1, [value2], ...)

COUNTBLANK - Answers -= COUNTBLANK (range)

COUNTIF - Answers -=COUNTIF(range, criteria)