Introduction to ComputersUnit 5 Discussion BoardHolly J. MaierNovember 4, 2010American Intercontinental UniversityInformation Systems•Research and discuss the ways in which a company can use advanced Excel tools, such as MIN and MAX statement, conditional formatting, and additional tools that you have discovered, to manage its business financesFirst off, when using Microsoft Excel there are two value range functions that you can use which are; “MIN and “MAX”. MIN will return the absolute minimum value in the range of cells you yourself specify, while MAX will do the opposite by retuning the maximum value in the range of cells.Within Excel, conditional formatting allows the user to select one or more cells and then create certain rules for when and how exactly those cells are to be formatted. These formulas are very beneficial to businesses and organizations in the way that it can help them build more professional appearing spreadsheets faster and by using fewer clicks with the aid of the charting tools. Also by applying conditional formatting to businesses
This is the end of the preview.
access the rest of the document.