FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -By default, Excel displays numbers with two decimal places. This can be changed by selecting the cell(s) whose format you want to change, and then going to Format > Cells. In the Number tab of the Format Cells dialog box, select the number of decimal places you want from the Decimal places drop-down list.

Detailed explanation-2: -The General format is the default number format that Excel applies when you type a number. For the most part, numbers that are formatted with the General format are displayed just the way that you type them.

Detailed explanation-3: -By using a button: Select the cells that you want to format. On the Home tab, click Increase Decimal or Decrease Decimal to show more or fewer digits after the decimal point.

Detailed explanation-4: -By default, cells formatted as currency display two decimal places. You can change this setting so cells display as many decimal places as you type in them, or so all cells display the same number of decimal places.

Detailed explanation-5: -The syntax for the function is ROUND(number, decimals), where number is the number you are rounding and decimals is the number of decimal places you want to round to. For example, if you wanted to round the number 1.234 to two decimal places, you would use the function ROUND(1.234, 2).