concepts of functionsOnline version this is to know some interesting things of excel by ariel rincón garnica 1 count and sum 2 cell references 3 date and time 4 round 5 array formulas You can count and sum based on one criteria or multiple criteria 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. Understand the difference between relative, absolute and mixed reference, and you are on your way to success. Cell references in Excel are very important. You can also enter a date and a time in one cell. to enter a date in Excel, use the "/" or "-" characters. This chapter illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function. This chapter helps you understand array formulas in Excel Single cell array formulas perform multiple calculations in one cell.
New game