Discuss the below in detail:
Q: Find and discuss the ways a company can use advanced Excel tools such as MIN and MAX statement, conditional formatting, and additional tools that you have discovered to manage their business finances. Once you have created a formula, the formula can be copied to subsequent cells. When the formula is copied it may change depending on the type of cell reference displayed in the formula. Explain the difference between a relative cell reference and an absolute cell reference.