77-888 Exam Dumps - Microsoft Office Specialist Questions and Answers

C:\Documents and Settings\Administrator\Desktop\1.JPG

C:\Documents and Settings\Administrator\Desktop\1.JPG

In this situation, you will take the following steps:

1.Create a new column subsequent to the one with the additional spaces in it.

2.Use the TRIM function in the new column to get rid of extra spaces.

3.Copy the contents of the new column and paste them on the top of the original column by usingpaste > special > values sequence.

4.Delete the column having the TRIM function.

Answer option A is incorrect. This is an invalid answer option.

Take the following steps to merge copies of a shared workbook:

1.Add Compare and Merge Workbooks.

2.Open the copy of the shared workbook to merge the changes.

3.Click Compare and Merge Workbooks on Quick Access Toolbar.

4.Save the workbook if prompted.

5.In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook

containing changes to be merged, and then click OK.

The Gantt Chart Template Deluxe Edition for Excel is used to generate quick and easy Gantt charts that define the progress of a user's projects containing up to 100 project tasks and team members. Answer option B is incorrect. A form control is an original control that is compatible with old versions of Excel, beginning with Excel version5.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 an existing macro to a control, or write or record a new macro. These controls cannot be added to UserForms, used to control events, or modified to run Web scripts on Web pages. Answer option D is incorrect. 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. Trust Center is where a user can find security and privacy settings for Microsoft Office 2010 programs.

A data table is used to see all the outcomes in one place. It is defined as a type of what-if

analysis tools. It is used if a user has a formula that uses one or two variables or multiple

formulas that all use one common variable. It is used to examine a range of possibilities at a

glance and since the user focuses on only one or two variables, results are easy to read and share

in tabular form. If automatic recalculation is enabled, it is possible to recalculate the data in

data tables immediately and as a result, the user always gets fresh data.

Answer option D is incorrect. A scenario is defined as a type of what-if analysis tools. It is a

set of values saved by Excel and can be substituted automatically in cells on a worksheet. A user

can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results. Scenario reports are not automatically recalculated. If the

user changes the values of a scenario, those changes will not be displayed in an existing summary report and he must create a new summary report to show the reflection of the changed report.

Answer option A is incorrect. Goal Seek is defined as a type of what-if analysis tools. It is used

if a user knows the result that he wants from a formula, but he is not sure what input value the

formula needs to get that result. It works with only one variable input value.

Answer option B is incorrect. The Solver add-in is used if a user knows the result that he wants

from a formula, but he is not sure what input value the formula needs to get that result. It is

used for more than one input value. It works with a group of cells related to the formula in the

objective cell.

In order to accomplish the task, you will have to choose one of the pre-built themes. Document

themes work on the overall design of the entire document. It enables users to specify colors,

fonts, and variety of graphic effects in a document. Themes change the look and feel of

the document.

C:\Documents and Settings\Administrator\Desktop\1.JPG

Microsoft Excel 2010 comes with a large collection of pre-built themes. Users can create their own themes for a document. Themes can be specified through Page Layout > Themes.

Answer option A is incorrect. The SmartArt option does not produce soothing graphic effects, soft fonts, and light colors.

Answer options B and D are incorrect. These options involve manual processing. Therefore, any

formatting done manually will increase the administrative burden.

ActiveX controls are used on worksheet forms, with or without the use of VBA code, and on VBA UserForms.Theyareusedwhenauserneedsmoreflexibledesignrequirementsthan

those provided by Form controls. They have extensive properties that can be used to customize their appearance, behavior, fonts, and other characteristics. The user can control different events that occur when an ActiveX control is interacted with. He can also write macros that respond to events associated with the ActiveX controls. When a user interacts with the control, the VBA code runs to process any events that occur for that control. The ActiveX controls cannot be added to chart sheetsfrom the user interface or to XLM macro sheets. It is not possible to assign a macro to run directly from the ActiveX control.

Answeroption A is incorrect.Aformcontrolis an original controlthat iscompatiblewith

old versions of Excel, beginning with Excel version5.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 an existing macro to a control, or write or record a new macro. These controls cannot be added to UserForms, used to control events, or modified to run Web scripts on Web pages.

Answer option B is incorrect. 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. Trust Center is where a user can find security and privacy settings for Microsoft Office 2010 programs.

C:\Documents and Settings\Administrator\Desktop\1.JPG

You will have to click File button to accomplish the task. Clicking the File button will open the

full- screen Backstage View of the sheet.