FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Formatting text or numbers can make them appear more visible especially when you have a large worksheet. Changing default formats includes things like changing the font color, style, size, text alignment in a cell, or apply formatting effects.

Detailed explanation-2: -The correct answer is Conditional formatting. Conditional formatting allows users to automatically apply formattings such as colours, icons, and data bars to one or more cells based on the cell value.

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: -On the Home tab, select Number from the drop-down. Or, you can choose one of these options: Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells…, and select Number.