Microsoft 77-888 Online Practice Questions and Exam Preparation

Microsoft 77-888 Online Questions & Answers

• Question 61:

  You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You use a function in one cell and it works perfectly but when you attempt to copy the function down to other rows, you get the #REF error. Which of the following are the reasons that are causing the above problem? Each correct answer represents a complete solution. Choose all that apply.

  A. You are inserting a new column, next to a column that is already formatted as text.
  B. Excel is trying to reference an invalid cell.
  C. The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.
  D. You are referencing an entire worksheet by clicking on the grey square at the top left of the worksheet.
  B. Excel is trying to reference an invalid cell.
  D. You are referencing an entire worksheet by clicking on the grey square at the top left of the worksheet.

  ---

  The Lookup Function Won't Copy Down to Other Rows error occurs when a user uses a function in one cell and it works perfectly but when he attempts to copy the function down to other rows, he gets the #REF error. The #REF! Error arises when Excel tries to reference an invalid cell. This error occurs if the user has referenced an entire worksheet by clicking on the grey square at the top left of the worksheet. For Excel, this reference range is 1 to 1048576. Since the references are Relative References, Excel automatically increases the row references when this cell is copied down to other rows in the spreadsheet. Answer option C is incorrect. The Failure to Look Up Values in Excel error occurs when a user gets an unexpected error while trying to look up or match a lookup_value within an array and Excel is not able to recognize the matching value. If the lookup_value or the array the user is searching resides in a cell, the user can have unseen spaces at the start or end of that cell. This will create the situation where the contents of the two cells that the user is comparing look the same but extra spaces in one of the cells cause the cells to have slightly different content. The other reason is that the contents of the cells that are being compared may have different data types.

  Answer option A is incorrect. The Excel Won't Calculate My Function error occurs when a user types in a function and presses Enter; the cell shows the function as the user typed it, instead of returning the function's value. The reason that causes this problem is that the cells containing the formula are formatted as 'text' instead of the 'General' type. This happens when the user inserts a new column, next to a column that is already formatted as text due to which the new column inherits the formatting of the adjacent column.

• Question 62:

  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 this issue, he wants to record the sequence of actions to perform a certain task and to play them back in the same order. Which of the following actions will Rick take to accomplish the task?

  A. He will use the Trust Center bar.
  B. He will use the Evaluate Formula tool.
  C. He will put the workbook in a trusted location.
  D. He will create and run a macro.
  D. He will create and run a macro.

  ---

  A macro is defined as a tool that permits a user to automate tasks and add several functionalities to forms, reports, and controls. For example, if a user adds a command button to a form, he associates the button's OnClick event to a macro,

  and the macro consists of the commands that are to be performed by the button each time it is clicked. 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 B is incorrect. Evaluate Formula is a 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 options A and C are 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 wheneverthe 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.