Question

3. Which of the following way cannot be adopted for changing the column width ?
(a) Drag the right border left or right to decrease or increase the column width.
(b) Double-click the right border of the column to fit the contents.
(c) In the Cells group, click Format > Column Width.
(d) In the Cells group, click Format > Shift Cells Right.​

Answer 1

Answer:

By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells.b.

Tutorial

Introduction

By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells.

Optional: Download our practice workbook.

Watch the video below to learn more about modifying columns, rows, and cells.

To modify column width:

In our example below, column C is too narrow to display all of the content in these cells. We can make all of this content visible by changing the width of column C.

Position the mouse over the column line in the column heading so the cursor becomes a double arrow

Answer 2

Answer:

(c) In the Cells group, click Format > Column Width

Explanation:

I hope