DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
format, wide, height
|
|
|
format, row, height
|
|
|
format, coloum, autoselection
|
|
|
format, row, autoselection
|
Detailed explanation-1: -Change row height 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-2: -Select a column or a range of columns. On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK.
Detailed explanation-3: -The height of rows ‘tr’ in a table can be fixed very easily. This can be done by adding the height attribute in the tr tag. If the height is not specified, the height of the row changes according to the content. The height can be specified either in pixels, or percentage.
Detailed explanation-4: -Excel row height As you increase or decrease the font size for a specific row(s), Excel automatically makes the row taller or shorter. According to Microsoft, with the default font Calibri 11, the row height is 12.75 points, which is approximately 1/6 inch or 0.4 cm.