Quick Excel Functions
There are some quick functions in Excel that can provide you the statistics of your worksheet without using formulas such as Status Bar quick functions.
See the image given below, as soon as you select the desired range you will get the statistics in the status bar, the average of numbers, the number of cells that contain values and the sum of numbers.
By a right click on the status bar you can customize it. You can add more functions in the status bar. Select the function from the menu which you want to add in the status bar. See the image shown below, status bar is customized. It is also showing maximum and minimum of the numbers.
JavaTpoint offers too many high quality services. Mail us on [email protected], to get more information about given services.
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected]
Duration: 1 week to 2 week