FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which is the best way to set a column to a specific width?
A
On the Home tab, in the Cells group, click Format, click Column Width and enter the measurement.
B
Press CTRL+W to specify the width for the column.
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Resize columns On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK.

Detailed explanation-2: -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.

Detailed explanation-3: -To AutoFit column width: The AutoFit feature will allow you to set a column’s width to fit its content automatically. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. Double-click the mouse. The column width will be changed automatically to fit the content.

Detailed explanation-4: -On the Home tab, in the Cells group, click Format. Under Cell Size, do one of the following: To automatically adjust the row height, click AutoFit Row Height. To specify a row height, click Row Height, and then type the row height that you want in the Row height box.

There is 1 question to complete.