Fill in the Blanks functions on excelOnline version the concepts of the functions of Excel by jose david Santisteban Vargas 1 Date Round Formula References Logical Errors Count Array Financial Sum Cell Text Time Lookup Formulas Statistical and Reference 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 : Learn how to use Excel's logical functions such as the IF , AND , OR and NOT function . 3 : Cell references in Excel are very important . Understand the difference between relative , absolute and mixed reference , and you are on your way to success . 4 & : To enter a date in Excel , use the " / " or " - " characters . To enter a time , use the " : " ( colon ) . You can also enter a date and a time in one cell . 5 : Excel has many functions to offer when it comes to manipulating text strings . 6 & : Learn all about Excel's lookup & reference functions such as the VLOOKUP , HLOOKUP , MATCH , INDEX and CHOOSE function . 7 : This chapter illustrates Excel's most popular financial functions . 8 : An overview of some very useful statistical functions in Excel . 9 : This chapter illustrates three functions to round numbers in Excel . The ROUND , ROUNDUP and ROUNDDOWN function . 10 : This chapter teaches you how to deal with some common formula errors in Excel . 11 : This chapter helps you understand array formulas in Excel . Single cell array formulas perform multiple calculations in one cell .