DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Column Height
|
|
|
Column Heading
|
|
|
Row Heights
|
|
|
Row Heading
|
Detailed explanation-1: -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.
Detailed explanation-2: -top to bottom measurement of a row, measured in point; 1 point=1/72 inch. Default row height is 15 points but you can specify a row height of 0 to 409 points. a predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items within a workbook, such as charts or tables.
Detailed explanation-3: -Go to File > Options > Advanced > Display > select an option from the Ruler Units list. If you switch to Normal view, then column widths and row heights will be displayed in points.
Detailed explanation-4: -To set the row height to a specific measurement, click a cell in the row that you want to resize. On the Layout tab, in the Cell Size group, click in the Table Row Height box, and then specify the height you want. To use the ruler, select a cell in the table, and then drag the markers on the ruler.
Detailed explanation-5: -2. Row height option. This option provides the user to change or set the row height to a specific point. Choose the format option from the Home tab ribbon, click on Row Height.