Online Access Free 77-888 Exam Questions

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 Evaluate Formula tool.
• B.He will create and run a macro.
• C.He will put the workbook in a trusted location.
• D.He will use the Trust Center bar.

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

Jack wants the rows containing the name Tom and product Jam. There are thousands of entries in the log. Plowing through all the records will be time taking. Which option can be used to view only the relevant records?

• A.Autofilter
• B.All filter
• C.Find
• D.Sort

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Microsoft Excel 2010 to prepare sales reports. You have created a quarterly sales report of the department. After entering required data and inserting charts, you want to give a professional look to the document. You want to produce the document with soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to accomplish the task with least administrative burden?

• A.Select all the text of the document.
  Change font style to Verdana and font color to light gray. Use vibrant colors for charts.
• B.Use the SmartArt option.
• C.Choose one of the pre-built themes.
• D.Create a new workbook through a template.Copy all data and charts of the report to the new workbook.

HOTSPOT
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.

Correct Answer: