FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Formatting in Excel is a neat trick used to change the appearance of the data represented in the worksheet. We can do formatting in multiple ways, such as we can format the font of the cells or format the table by using the “Styles” and “Format” tabs available in the “Home” tab.

Detailed explanation-2: -In Excel, the format cells is used to modify the formatting of cell numbers without modifying the actual number. With the help of the format cells, we can change the number, alignment, font style, Border style, Fill options, and Protection. We can access this option with right-click of the mouse.

Detailed explanation-3: -A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. To prevent anyone from making changes to specific cells, you can also use a cell style that locks cells.

Detailed explanation-4: -What is Excel template? An Excel template is a predesigned sheet that can be used to create new worksheets with the same layout, formatting and formulas. With templates, you don’t need to recreate the basic elements every time as they are already integrated into the spreadsheet.