35 Functions

MO 200 (2019 Associate-Level Exam)

• Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions.

• Perform conditional operations by using the IF() function.

• Format text by using RIGHT(), LEFT(), and MID() functions.

• Format text by using UPPER(), LOWER(), and LEN() functions.

• Format text by using the CONCAT() and TEXTJOIN() functions.

MO 201 (2019 Expert-Level Exam)

• Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), AND(), OR(), and NOT() logical functions and...

  • the 8 range-conditional (RACON) functions: SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS().

• Look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions and...

  • MATCH() and INDEX() together for lookups.

• Reference date and time by using the NOW() and TODAY() functions

• Calculate dates by using the WEEKDAY() and WORKDAY() functions 

• Forecast (financial) data by using the AND(), IF(), and NPER() functions.

• Calculate financial data by using the PMT() function.