FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In Excel, when formatting a cell as Text and typing the keys 0, 0, 1 in turn, the cell will appear:
A
‘001
B
‘0
C
‘010
D
‘1
Explanation: 

Detailed explanation-1: -Detailed Solution. The correct answer is Formula bar. The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell.

Detailed explanation-2: -Select the cell or range of cells that you want to format. Press Ctrl+1 to load the Format Cells dialog. Select the Number tab, then in the Category list, click Custom and then, in the Type box, type the number format, such as 000-00-0000 for a social security number code, or 00000 for a five-digit postal code.

Detailed explanation-3: -An important thing to remember is that formatting cells in Excel changes only the appearance, or visual representation, of a cell value but not the value itself. For example, if you have number 0.5678 in some cell and you format that cell to display only 2 decimal places, the number will appear as 0.57.

There is 1 question to complete.