FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -One of the most helpful number formats is the percentage (%) format. It displays values as percentages, such as 20% or 55%. This is especially helpful when calculating things like the cost of sales tax or a tip.

Detailed explanation-2: -Formatting text or numbers can make them appear more visible especially when you have a large worksheet. Changing default formats includes things like changing the font color, style, size, text alignment in a cell, or apply formatting effects.

Detailed explanation-3: -You can use number formats to change the appearance of numbers, including dates and times, without changing the actual number. The number format does not affect the cell value that Excel uses to perform calculations. The actual value is displayed in the formula bar. Excel provides several built-in number formats.

Detailed explanation-4: -On the Home tab, in the Number group, click the icon next to Number to display the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Percentage. In the Decimal places box, enter the number of decimal places that you want to display.

Detailed explanation-5: -An N-formatted number has an implied decimal point (for example, 2.01 formatted as N2 is 201). An R-formatted number has an explicit decimal point and truncates trailing zeros (for example, 2.123 formatted as R2 is 2.12 and 3.10 formatted as R2 is 3.1).