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.
You've reached the end of your free preview.
Want to read all 9 pages?
- Fall '16
- Mohammad Alizadeh
- Visual Basic for Applications, Microsoft Office 2007