Question

short note on formatting cell
​

Answer 1

Answer:

When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc).

Overview. Cell formats allow you to 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. ... Formatting also allows you to set font, background color, and borders for selected cells.

Answer 2

Answer:

Formatting cell: Only the appearance of cell data in the spreadsheet can be changed with cell formats. It's important to remember that this only changes the way the data is presented, not the value of the data. Money units, scientific options, dates, times, fractions, and other formatting options are available.

Explanation:

Only the appearance of cell data in the spreadsheet can be changed with cell formats. It's important to remember that this only changes the way the data is presented, not the value of the data.

• Money units, scientific options, dates, times, fractions, and other formatting options are available. Positive and negative values can be represented by different colors and formats to make it easier to keep track of them.
• There are also a plethora of date and time formats available for almost any time and date format imaginable. You can also use formatting to change the font, background color, and borders of selected cells.
• You can either use the Format Cells dialogue, which contains all of the formatting options, or use specific formatting elements available as buttons on the Format Toolbar to change the formatting of a cell or a selection.
• Finally, advanced formatting options allow you to restrict the range of values that can be entered in selected cells or lock some of the cells so that their values cannot be changed.