Functions

MO 210 (Excel 365 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.

• Generate numeric data by using RANDBETWEEN(). NEW

• Generate numeric data by using SEQUENCE(). NEW

• Sort data by using the SORT() function. NEW

• Get unique values by using the UNIQUE(). NEW

MO 211 (Excel 365 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.

• Generate numeric data by using RANDARRAY(). NEW

• Perform logical operations by using nested functions including the LET() function. NEW

• Look up data by using the XLOOKUP(). NEW

• Filter data by using FILTER(). NEW

• Sort data by using SORTBY(). NEW