Microsoft Microsoft Certifications 77-427 Questions & Answers

• Question 61:

  You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in Excel 2013. You want to insert flow-chart in the sheet. Mark the option that you will choose to insert flow- chart symbols in the report. Explanation: In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple objects provided by Microsoft Office to add them to a document. A single shape or combined multiple shapes can be inserted in the document. The Office includes simple shapes, such as lines, basic geometric shapes, arrows, equation shapes, flowchart shapes, stars, banners, and callouts. Users can add text, bullets, numbering, and Quick Styles to these shapes after inserting them in the document. Take the following steps to add a shape in a document:

  

  Hot Area:

  

  Correct Answer:

  

• Question 62:

  

  You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2013 to create different reports for your company. Drag and drop the appropriate methods for efficient data entry in front of their descriptions.

  Select and Place:

  

  Correct Answer:

  

  Excel provides multiple methods for fast data entry into a worksheet. These data entry techniques help users to quickly enter data wherever required. The following methods help users in speeding-up their data entry work:

  AutoFill: The AutoFill feature recognizes the series a user wants to enter and fills the series when the fill handle is dragged.

  FillSeries: In FillSeries method, a user enters the first two values in a series and then by selecting both the cells and dragging the selected cells through the fill handle, extends the series. AutoComplete: The AutoComplete feature provides

  users a facility to enter few words in a cell. If this entry matches with any of the entries done before in other cells, it suggests users for the same. The user can press the Enter key to get the same entry in the cell. Pick from Drop-down List: The

  

  Pick from Drop-down List option displays the unique entries from the column of a cell. A user can choose an entry from the list to quickly fill the entry.

  Ctrl + Enter: Ctrl + Enter key combination is used to quickly fill a range of cells with the same entry. For this, select a range of cells to contain the same data, type the data in the active cell, and press Ctrl + Enter keys