MOS-Using-Microsoft-Office-Excel-2007-(77-602).pdf - Microsoft 77-602 MOS Using Microsoft Office Excel 2007 http\/killexams.com\/exam-detail\/77-602 Answer

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

This preview shows page 1 - 4 out of 9 pages.

77-602 Microsoft MOS Using Microsoft Office Excel 2007
Image of page 1
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
Image of page 2
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.
Image of page 3
Image of page 4

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture