DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select Columns A to G > Right click in Column A > column width > Enter 25. Select Rows 1 to 7 > Right click in Row 1 > Row Height > Enter 15
|
|
|
Select Columns A to G > Right click in Column A > column width > Enter 25. Select Rows 1, 5 and 7 while holding the Ctrl key > Right click in Row 1 > Row Height > Enter 15
|
|
|
Select Columns A to G > Drag right border of Column G to the right until it display the value 25. Select Rows 1, 5 and 7 > Drag the border bottom of the row header downwards until it displays the value 15
|
|
|
Select Columns A to G > Format tab > Column > Width > Enter 25. Select Rows 1 to 5 > Format tab > Row > Height > Enter 15
|
Detailed explanation-1: -Adjust the column width To increase the column width quickly and easily, you can move your mouse to the far-right edge of the column label area until you see the crosshairs (see below). You then just double-click your mouse, and the column is adjusted to fit the width of the largest content.
Detailed explanation-2: -Resize columns On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK.
Detailed explanation-3: -Changing the column width in Excel automatically You can quickly adjust the column width to accommodate the longest entry. Select any column from the worksheet. From the Cells group on the Home tab, choose Format. Select AutoFit Column Width to set that column to auto-fit the width depending on the contents.