USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
delete
|
|
|
copy
|
|
|
resize
|
|
|
fill
|
Detailed explanation-1: -Question 1 (B) it automatically sizes them to fit the largest text To quickly adjust the row height or column width, use a double-click shortcut.
Detailed explanation-2: -Navigation. To quickly navigate through a worksheet, use a double-click shortcut. Excel will select a cell in that row or column, moving in the direction that you clicked. It stops at the cell just before the first blank cell.
Detailed explanation-3: -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-4: -There are several easy ways to adjust column width. The first way is by double-clicking the column border. This automatically modifies the column to fit the text it contains.
Detailed explanation-5: -To check this, go to File > Options > Advanced. Scroll down to the “Editing options” section and make sure “Enable automatic resizing of cells” is checked. If it’s not, check it and try double-clicking on a column header again.