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]
Ruby wants all the entries in Column D in her worksheet to display fully. What is the best method for ensuring Column D is wide enough?
A
Dragging the right border of Column D to the right edge of the Excel window.
B
Using the AutoFit command.
C
Using the Resize command.
D
Entering a very large number in the Column Width dialog box.
Explanation: 

Detailed explanation-1: -Ruby wants all the entries in Column D in her worksheet to display fully. What is the best method for ensuring Column D is wide enough? Using the AutoFit command.

Detailed explanation-2: -The answer is 2. Autofit. Explanation: The Autofit feature of Microsoft Excel will resize the width of the column or row’s height in order to accommodate the height or width of the largest entry.

Detailed explanation-3: -The most commonly used way to select multiple cells is to click and drag. You need to click on a cell and drag it over the spreadsheet. Press on a cell.

Detailed explanation-4: -2. Now just press Ctrl + Shift + + (plus on the main keyboard). Tip. If you are not really into shortcuts, you can right-click on the selected column and pick the Insert option from the menu list.

Detailed explanation-5: -Which of the following is true about changing worksheet column width? In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column.

There is 1 question to complete.