DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Drag the lines between the rows in Excel
|
|
|
Drag the lines between the columns in Excel
|
|
|
Drag the lines between the columns in Excel, or right-click and select Column Width to type in an exact column width
|
|
|
none of these
|
Detailed explanation-1: -To change the width of columns to fit the contents, select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading. To change the width of all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.
Detailed explanation-2: -The number that you see in the Column Width dialog box is the pixel width retranslated into character units (based on the Normal font) for display. A column width of 8.43 means that 8.43 of the default font’s characters fit into a cell.
Detailed explanation-3: -Move or copy rows and columns by using the mouse Select the row or column that you want to move or copy. Note: Make sure that you hold down CTRL or SHIFT during the drag-and-drop operation. If you release CTRL or SHIFT before you release the mouse button, you will move the rows or columns instead of copying them.