DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select FORMAT in the CELLS group and select AUTOFIT ROW HEIGHT
|
|
|
Right-click on a row header and select COLUMN HEIGHT
|
|
|
None
|
|
|
Both answer choices
|
Detailed explanation-1: -Resize rows Select a row or a range of rows. On the Home tab, select Format > Row Width (or Row Height). Type the row width and select OK.
Detailed explanation-2: -Select the row you want to adjust the height. In Microsoft Office Excel 2003 and in earlier versions of Excel, point to Row on the Format menu, and then click AutoFit. In Microsoft Office Excel 2007 and later versions, click the Home tab, click Formatin the Cells group, and then click AutoFit Row Height.
Detailed explanation-3: -Select one or more columns that you wish to resize. To select all columns, press Ctrl + A or click the Select All button. On the Home tab, in the Cells group, click Format > Column Width. In the Column width box, type the desired number, and click OK.