Microsoft 77-888 Online Practice Questions and Exam Preparation

Microsoft 77-888 Online Questions & Answers

• Question 51:

  Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft Excel 2010. He wants to fill the active cell with the content of the adjacent cell. Mark the option that he will choose to accomplish the task.

  Hot Area:

  

  

• Question 52:

  You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in Excel 2010.

  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:

  

  

• Question 53:

  You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2010 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:

  

  

  ---

  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.

• Question 54:

  You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2010 application on the network. You open the application and see various changes in Excel 2010. You have to open an

  existing worksheet through the application.

  You are unable to find the Office button.

  Mark the option that you will click to accomplish the task.

  Hot Area:

  

  

• Question 55:

  Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through Microsoft Excel 2010. While creating forms for a number of users, he is required to repeat some of the actions multiple times. It is a very time consuming process. To resolve the issue, he has created a macro to record the sequence of actions to perform a certain task. Now, he wants to run the macro to play those exact actions back in the same order. Which of the following steps will Rick take to accomplish the task?

  Each correct answer represents a part of the solution. Choose all that apply.

  A. Click on the 'Macros' icon in the 'Developer' tab under the 'Code' category to run a Macro.
  B. The Macro will be run in any worksheet of the Workbook.
  C. Put the workbook in a trusted location.
  D. The Macro dialogue box appears on the screen which contains a list of Macros in it. Select the Macro to run and click the Run button.
  E. Run the created Macro by using the shortcut key specified while creating the Macro.
  A. Click on the 'Macros' icon in the 'Developer' tab under the 'Code' category to run a Macro.
  B. The Macro will be run in any worksheet of the Workbook.
  D. The Macro dialogue box appears on the screen which contains a list of Macros in it. Select the Macro to run and click the Run button.
  E. Run the created Macro by using the shortcut key specified while creating the Macro.

  ---

  Take the following steps to run a Macro:

  1.

  Click on the 'Macros' icon in the 'Developer' tab under the 'Code' category to run a Macro.

  2.

  The Macro dialogue box appears on the screen which contains a list of Macros in it. Select the Macro to run and click the Run button.

  3.

  The Macro will be run in any worksheet of the Workbook.

  4.

  A user can run the created Macro by using the shortcut key that he has specified while creating the Macro. The macro records the user's mouse clicks and keystrokes while he works and lets him play them back later. The macro can be used to record the sequence of commands that the user uses to perform a certain task. When the user runs the macro, it plays those exact commands back in the same order. Answer option C is incorrect. The benefit of connecting to external data from Microsoft Excel is that a user can automatically update Excel workbooks from the real data source whenever the data source is updated with new information. It is possible that the external data connection might be disabled on the computer. For connecting to the data source whenever a workbook is opened, it is required to enable data connections by using the Trust Center bar or by putting the workbook in a trusted location.

  

  

• Question 56:

  You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history. Which of the following will you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

  A. History tracking
  B. Onscreen highlighting
  C. Slicer-enabled highlighting
  D. Reviewing of changes
  A. History tracking
  B. Onscreen highlighting
  D. Reviewing of changes

  ---

  The following ways are provided by Excel to access and use the stored change history:

  1.

  Onscreen highlighting: It is used when a workbook does not contain many changes and a user wants to see all changes at a glance.

  2.

  History tracking: It is used when a workbook has many changes and a user wants to investigate what occurred in a series of changes.

  3.

  Reviewing of changes: It is used when a user is evaluating comments from other users. Answer option C is incorrect. This is an invalid answer option.

• Question 57:

  Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft Excel 2010. Rick wants to trace the project with the actual requirements. For this purpose, he is required to compare month to month, actual v budget, quarter to quarter, year to year variances. Which of the following will Rick use to accomplish the task?

  A. Evaluate Formula
  B. Accounting template
  C. Form control
  D. Trust Center
  B. Accounting template

  ---

  The accounting template is used for numbering months of a financial year to period numbering. It is used to compare month to month, actual v budget, quarter to quarter, year to year variances. It is the initial point for other reports that need

  the use of months. Answer option C is incorrect. A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 0. It is designed for use on XLM macro sheets. It can be used when a user

  wants to simply interact with cell data without using VBA code and when he wants to add controls to chart sheets. By using form controls, the user can run macros. He can attach anexisting macro to a control, or write or record a new macro.

  These controls cannot be added to User Forms, used to control events, or modified to run Web scripts on Web pages. Answer option A is incorrect. Evaluate Formula is the formula examination tool provided by Microsoft Excel. This tool is

  useful for examining formulas that do not produce any error but are not generating the expected result.

  Answer option D is incorrect. Trust Center is where a user can find security and privacy settings For Microsoft Office 2010 programs.

• Question 58:

  You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2010. You want to summarize a large amount of data to analyze numerical data and to answer unexpected questions about your data in the Business Intelligence (BI) report that you are working with. For this purpose, you are required to create a PivotTable. Which of the following steps will you take to accomplish the task?

  Each correct answer represents a part of the solution. Choose all that apply.

  A. Click OK.
  B. Choose Select a table or range under Choose the data that you want to analyze.
  C. Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.
  D. Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.
  E. Click a cell in the cell range that contains data for using worksheet data as the data source.
  A. Click OK.
  B. Choose Select a table or range under Choose the data that you want to analyze.
  D. Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.
  E. Click a cell in the cell range that contains data for using worksheet data as the data source.

• Question 59:

  You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a worksheet for preparing the report. You have

  inserted the sales figures of all sales managers as shown in the image given below:

  You have to calculate the first quarter incentives for all sales managers. The incentive percentage (provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total first quarter sales. You have to write a formula

  in the cell F8. Then you will drag the cell border to the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8 cell. Which of the following formulas will you insert to accomplish the task?

  A. =andBand3/100 * E8
  B. =B3/100 * E8
  C. =B3/100 * andEand8
  D. =$B$3/100 * E8
  E. =B3/100 * $E$8
  D. =$B$3/100 * E8

  ---

  In order to accomplish the task, you will have to insert the following formula:

  =$B$3/100 * E8

  According to the question, the formula will be inserted in cell F8 and then the cell's border will be dragged to the F12 cell. Furthermore, the incentive percentage is fixed for all sales managers and the value is provided in the cell B3. You will

  have to insert a formula that refers to the B3 cell as an absolute reference. For this you will have to type currency symbol ($) before the row name and column number. In order to accomplish the task, type the following formula in the cell

  F8:

  =$B$3/100 * E8

  When absolute reference is used for referencing a cell in a formula, dragging cell's border to another cell does not change the cell's reference.

  Answer options B and E are incorrect. This formula references the B3 cell as a relative reference. After inserting the formula, when the cell's border is dragged, it will change the cell reference relatively. Answer options A and C are incorrect.

  Ampersand symbol (and) is not used for referencing cells in Excel.

• Question 60:

  You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to make a slicer available for use in another PivotTable. Which of the following steps will you take to accomplish the task?

  Each correct answer represents a part of the solution. Choose all that apply.

  A. Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort and Filter group.
  B. In the Slicer Connections dialog box, clear the check box of any PivotTable fields for which you want to disconnect a slicer.
  C. In the PivotTable Connections dialog box, select the check box of the PivotTables in which you want the slicer to be available.
  D. Click the slicer that you want to share in another PivotTable.
  C. In the PivotTable Connections dialog box, select the check box of the PivotTables in which you want the slicer to be available.
  D. Click the slicer that you want to share in another PivotTable.