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

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

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.

What-if analysis is defined as the process of changing values in cells to observe the way in which

those changes are affecting the outcome of formulas in the worksheet. There are three types of

what-if analysis tools that are named as scenarios, data tables, and Goal Seek. A user can also

install the Solver add-in to accommodate more variables than Goal Seek.

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