Online Access Free 77-888 Exam Questions

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You want to protect the worksheet and locked cells by permitting or prohibiting other employees to select, format, insert, delete, sort, or edit areas of the spreadsheet. Which of the following options will you use to accomplish the task?

• A.Protect Workbook Structure
• B.Encrypt with Password
• C.Mark as Final
• D.Protect Current Sheet

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You observe that while trying to look up or match a lookup_value within an array, Excel is not able to recognize the matching value. 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.The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.
• B.The contents of the cells that are being compared may have different data types.
• C.You are inserting a new column, next to a column that is already formatted as text.
• D.Excel is trying to reference an invalid cell.

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.Put the workbook in a trusted location.
• B.Click on the 'Macros' icon in the 'Developer' tab under the 'Code' category to run a
  Macro.
• C.Run the created Macro by using the shortcut key specified while creating the Macro.
• 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.The Macro will be run in any worksheet of the Workbook.

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2010. Rick wants to interact with cell data but his computer does not contain VBA code and few features of his computer are still Excel 5. 0 features. Which of the following will Rick use to accomplish the task?

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

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick wants to display data series, categories, data markers, and axes in the report. Which of the
following actions will Rick take to accomplish the task?

• A.He will create a PivotChart report.
• B.He will use stand-alone slicers.
• C.He will create a PivotTable report.
• D.He will configure form controls.