FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Select the cells with the Excel Style. Right-click the applied style in Home > Cell Styles. Select Modify > Format to change what you want.

Detailed explanation-2: -Whenever you want to modify the appearance of a number or date, display cell borders, change text alignment and orientation, or make any other formatting changes, the Format Cells dialog is the main feature to use.

Detailed explanation-3: -Right-click the cell or cell range, select Format Cells…, and select Number. Select the small arrow, dialog box launcher, and then select Number.

Detailed explanation-4: -Applying number formatting-such as currency, accounting, or percentage-changes how values are displayed. Excel is often smart enough to apply number formatting automatically, but you can also add it manually.

Detailed explanation-5: -Cell formats allow you to only change the way cell data appears in the spreadsheet. It is important to keep in mind that it only alters the way the data is presented, and does not change the value of the data. The formatting options allows for monetary units, scientific options, dates, times, fractions, and more.