DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
width, height
|
|
|
spacing, margins
|
|
|
margins, spacing
|
|
|
height, width
|
Detailed explanation-1: -The key difference between columns and rows is that a column arranges data vertically from top to bottom, while a row arranges data horizontally from left to right.
Detailed explanation-2: -Just click the column header. The status bar, in the lower-right corner of your Excel window, will tell you the row count. Do the same thing to count columns, but this time click the row selector at the left end of the row. If you select an entire row or column, Excel counts just the cells that contain data.
Detailed explanation-3: -Excel begins with a default width of 8 characters and translates this into a given number of pixels, depending on the Normal style font. It then rounds this number up to the nearest multiple of 8 pixels, so that scrolling across columns and rows is faster.
Detailed explanation-4: -Row height is measured in points and there are 72 points to an inch. The default row height is 12.75 points (17 pixels). This height is sufficient to display text in font size of 10 and 12pts. The ends of the horizontal lines that separate the rows can actually be moved using the mouse.