Yearly Archives: 2010

Rounding-off values manually is a tiring process and can become quite complex, especially when you are dealing with huge data values with more than 3 decimal points. Just like previous Excel versions, Excel 2010 provides an easy way to round off decimal values. Using the MROUND function, you can easily evaluate round-off values for specified numbers without having to manually enter the round off values.. It takes two simple arguments for evaluation. All you need is to enter the data range the decimal values are stored or enter the values as function arguments to display their round off values. Using the relative referring, you can easily display round off values of an entire column by just dragging the cell containing the function. Additionally, it allows you to specify the number, which is to be used to round off values. Read More

Finding out modulus and quotient manually can become a tiresome process, especially when you are dealing with big numbers. Excel 2010 includes a build-in function to find out Modulus and Quotient instantly. These functions are dead-easy to use and take only two arguments for evaluation. The Modulus and Quotient functions require data range i.e., the cell location where values are residing or direct values to calculate modulus and the quotient, respectively. You can also copy or drag the cell containing the formula to calculate the modulus/quotient for the corresponding data set. It's advisable to check the the divisor values before finding the modulus and quotient in order to get correct results for your data set.  Read More

Changing cell colors in Excel 2010 is very easy, as you can change it via Font Color options which is present right up front. But through Cycle Font Color, you don't need to change it over and over again to find the best color that suits your datasheet. Through this feature you can change color of cells repetitively through multiple clicks for choosing the appropriate one. Read More