Matching Pairs five point examOnline version the explain function in ecxel in a match activity by Juan Esteban Triviño 1 The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria. 2 Excel has many functions to offer when it comes to manipulating text strings. 3 Learn how to use Excel's logical functions such as the IF, AND, OR and NOT function. 4 This chapter illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function. 5 Lookup & Reference Logical Round text Count and Sum