FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following is used to drag or double-click to change the width of a column?
A
Cell pointer
B
Column marker
C
Fill handle
D
Formula bar
Explanation: 

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: -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: -To modify column width: Position the mouse over the column line in the column heading so the cursor becomes a double arrow. Click and drag the mouse to increase or decrease the column width. Release the mouse. The column width will be changed.

Detailed explanation-4: -Change column width To use your mouse, rest the cursor on right side of the column boundary you want to move until it becomes a resize cursor., and then drag the boundary until the column is the width you want. To change the width to a specific measurement, click a cell in the column that you want to resize.

There is 1 question to complete.