MOS-Using-Microsoft-Office-Excel-2007-(77-602).pdf -...

77-602
Microsoft
MOS Using Microsoft Office Excel 2007

Answer options A is incorrect. The Sort function is used to arrange the records
in ascending or descending order.
QUESTION: 37
Sam works as an Office Assistant. He uses Microsoft Excel XP to create
reports. He creates a sales report as shown in the figure. Since text written in
cell A1 is longer than the cell size, he wants to adjust it into the next line in the
same cell. Which of the following options will he use to accomplish the task?
A. Use the Wrap text option.
B. Use the Shrink to fit option.
C. Use the Justify alignment.
D. Use the Auto Selection command.
Answer: A
Explanation:
The Wrap text option is used to adjust text into the next line in the same cell.
This option automatically wraps the text to the next line.
Take the following steps to use the Wrap text option:
52

1.Select the cell that has to be formatted using the Wrap text option.
2.Choose Format > Cells from the menu bar.
3.The Format Cells dialog box will open. Click the Alignment tab, and then
select the Wrap text check box under the Text control.
Answer option B is incorrect. The Shrink to fit option under the Text control
reduces the size of text font to fit the text within the cell.
Answer option D is incorrect. The AutoFit Selection command in Microsoft
Excel is used to fit the cell contents in a column by changing the column width.
This command adjusts the column width, which is actually needed to display
the contents in the selected cells. If changes are made in the cell contents, the
AutoFit Selection command has to be used again to fit the cell contents.