Correct Answer: C

A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 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 A 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 D is incorrect. Evaluate Formula is the 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 option B is incorrect. Trust Center is where a user can find security and privacy settings for Microsoft Office 2013 programs.

Correct Answer: A

Autofilter is used to filter the record as per the condition by hiding the rest. Defining different filters, you can compare data in multiple ways, so you can glean vital information without wasting vital time.

Answer options B and D are incorrect. There are no such options defined in Excel to filter the records.

Answer options C is incorrect. The Sort function is used to arrange the records in ascending or descending order.

Correct Answer: A

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 version 5. 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 2013 programs.

Correct Answer: BD

The Cell Shows ##### error occurs because the cell is not wide enough for displaying the calculated value. The other reason is that Excel is trying to show the contents of the cell as a date or time stored as positive numeric values within Excel, but the cell contains a negative value. 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

Correct Answer: C

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 A is incorrect. This is an invalid answer option.

Correct Answer: C

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 D 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. Answer option B is incorrect. 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.

Correct Answer: C

According to the question, you have to remove all subtotals from the worksheet with the least administrative effort. You can remove all subtotals from a worksheet at a time. For this, take the following steps: Open the Subtotal dialog box by clicking the Subtotal option in the Outline group on the Data tab.

Click the Remove All option.

Answer option A is incorrect. No such option is provided in Excel 2013.

Answer option B is incorrect. Although this will hide the rows containing the subtotals, the contents will remain there and can be made visible by using the Unhide row option. Moreover, the question specifically specifies to remove all subtotals from the sheet. Answer option D is incorrect. Although this step will accomplish the task, it will involve a lot of administrative burden of selecting each row and deleting it manually.

Correct Answer: D

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. Answer option A is incorrect. A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 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 use of months. Answer option B is incorrect. Trust Center is where a user can find security and privacy settings for Microsoft Office 2013 programs.

Correct Answer: A

A trendline is defined in Excel 2013. It is a data visualization tool to display the trend of a particular data range. It is used to show the slope of data points in a chart. There are various types of trendlines, such as linear trendlines, exponential trendlines, and linear forecast trendlines. Answer option B is incorrect. A sparkline is defined as a tiny chart in the background of a cell. Unlike charts on an Excel worksheet, sparklines are not objects. It is used because data presented in a row or column is useful, but patterns can be hard to spot at a glance. It is used to display a trend based on adjacent data in a clear and compact graphical representation by taking up a small amount of space. The benefit of using the sparklines is that these can be printed when a user prints a worksheet that contains them. This feature is not available in charts. Answer option C is incorrect. The Microsoft Office Backstage view is used to replace the traditional file menu with a new approach that uses In and Out features for efficiency. The improved Ribbon enables users to access their preferred commands rapidly and create custom tabs to personalize the way they work.Answer option D is incorrect. Excel provides a column chart facility to display data that is arranged in columns or rows on a worksheet. Line charts are used to display continuous data over time, set against a common scale. In a line chart, category data is distributed along the horizontal axis, and all value data is distributed along the vertical axis. Line charts are ideal for showing trends in data at equal intervals.

A line chart should be used where category labels are text, and are representing evenly spaced values such as months, quarters, or years.

Correct Answer: C

The various Protect Workbook options are as follows:

1.

Mark as Final: This option is used to make the document read-only. When a spreadsheet is marked as final, various options such as typing, editing commands, and proofing marks are disabled or turned off and the spreadsheet becomes read-only. This command helps a user to communicate that he is sharing a completed version of a spreadsheet. This command also prevents reviewers or readers from making inadvertent modifications to the spreadsheet.

2.

Encrypt with Password: When a user selects the Encrypt with Password option, the Encrypt Document dialog box appears. In the Password box, it is required to specify a password. Microsoft is not able to retrieve lost or forgotten passwords, so it is necessary for a user to keep a list of passwords and corresponding file names in a safe place.

3.

Protect Current Sheet: This option is used to select password protection and permit or prohibit other users to select, format, insert, delete, sort, or edit areas of the spreadsheet. This option protects the worksheet and locked cells.

4.

Protect Workbook Structure: This option is used to select password protection and select options to prevent users from changing, moving, and deleting important data. This feature enables a user to protect the structure of the worksheet.

5.

Restrict Permission by People: This option works on the basis of Window Rights Management to restrict permissions. A user is required to use a Windows Live ID or a Microsoft Windows account to restrict permissions. These permissions

can be applied via a template that is used by the organization in which the user is working. These permissions can also be added by clicking Restrict Access.

6.

Add a Digital Signature: This option is used to add a visible or invisible digital signature.

It authenticates digital information such as documents, e-mail messages, and macros by using computer cryptography. These signatures are created by specifying a signature or by using an image of a signature for establishing authenticity,

integrity, and non-repudiation.