USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cell pointer
|
|
|
Column marker
|
|
|
Fill handle
|
|
|
Formula bar
|
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: -Excel’s AutoFit feature is designed to automatically resize cells in a worksheet to accommodate different sized data without having to manually change the column width and row height. AutoFit Column Width-changes the column width to hold the largest value in the column.
Detailed explanation-3: -Generally, every cell in a row or column has the same size, so you can’t adjust the size of a cell individually without affecting the others in its same row or column. You can merge adjacent cells to create larger compound cells, however, and you can set rows and columns to automatically adjust to fit text.