Question

What is the need of formatting in excel and explain the use of alignment and its types?

Answer 1

Answer:

Formatting in excel is a neat trick in excel which is used to change the appearance of the data represented in the worksheet, formatting can be done in multiple ways such as we can format the font of the cells or we can format the table by using the styles and format tab available in the home tab.

Left − Aligns the cell contents to the left side of the cell.

Center − Centers the cell contents in the cell.

Right − Aligns the cell contents to the right side of the cell.

justify− Repeats the contents of the cell until the cell's width is filled.