1. The cell reference will be provided as a string of text. The function can return an address in a relative or absolute FORMAT and can be used to construct a cell reference inside a formula. As a financial analyst, cell ADDRESS can be used to convert a column number to a letter, and vice versa.2. FunctionsCount and Sum: The most used functions in Excel are the functions that count and sum. ...Logical: Learn how to use Excel's logical functions, such as IF, AND, OR and NOT.Cell References: Cell references in Excel are very important. ...Date & Time: To enter a date in Excel, use the "/" or "-" characters.3.relative and absolute. Relative and absolute references behave differently when COPIED and filled to other cells. Relative references CHANGE when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.4. MAX( ) function returns the biggest value from the given SET of data. MIN ( ) function returns the smallest value from the given set of data. ... The Max( ) and the Min ( ) functions. These will help you to separate the maximum and the lowest value respectively from a given set of numbers.Maplz MARK as brainliast answer