FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
A
8.43
B
7.52
C
11.65
D
9.43
Explanation: 

Detailed explanation-1: -A column width of 8.43 means that 8.43 of the default font’s characters fit into a cell. The default font for the worksheet is the font that is assigned to the Normal style. Excel 2000 uses a factory default font of Arial 10. Changing Printer DPI can affect the font metrics and can adjust the column widths.

Detailed explanation-2: -Finally, it’s worth noting that Excel has a maximum column width of 255 characters. This means that if you try to make a column wider than 255 characters, Excel will automatically adjust it down to 255.

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.
Previous
Next