Functions
Microsoft wants you to know
For the new Excel 365 Exams
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 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