Correct Answer:

The following figure shows the option used to insert a signature line that specifies the individual who must sign.

Correct Answer: C

The #NULL! error is produced by Excel when a user attempts to intersect two ranges that do not intersect each other. This error can be resolved by reviewing the formula and then either by changing the variables to ensure that the user is getting a valid intersection or by using the Excel Iferror function to identify a null range and take the required action. Answer option D is incorrect. Excel #DIV/0! is produced when a formula attempts to divide by zero and a division by zero produces infinity that cannot be represented by a spreadsheet value. This error can be corrected or overcome by using the Excel IF function to identify a possible division by zero and produce an alternative result. Answer option A is incorrect. The #VALUE! Excel formula error occurs when any of the variables in a formula is of the wrong type. To correct this error, it is required to check each individual part of the formula to make sure that the correct argument types are used. If the function contains nested functions, the best way is to copy each of the arguments into a separate cell to check what they evaluate to. If the formula contains a number of terms, break down each term further to find out its components, until the source of the error is found. Answer option B is incorrect. The #NAME? error occurs when Excel encounters text in a formula and tries to interpret that text as a reference, a named range, or a function name but is not able to recognize the text as any of these. The best way to approach the #NAME? Excel function error is to check the correct spelling of the function names, references, and named ranges and to check that the variables used as text values are entered in double quotes. If the formula contains nested functions, it is required to check the results of these individually, until the source of the error is identified.

Correct Answer: A

In order to accomplish the task, you will use the following formula:

=VLOOKUP(B2,Item_table,2,FALSE)

Answer option B is incorrect. According to the question, you want the exact values in the column.

The TRUE value in the range_lookup argument provides the approximate match. Answer options C and D are incorrect. The VLOOKUP functions used in the formulas have wrong syntaxes.

Correct Answer: ABDE

Take the following steps to run a Macro:

1.

Click on the 'Macros' icon in the 'Developer' tab under the 'Code' category to run a Macro.

2.

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.

3.

The Macro will be run in any worksheet of the Workbook.

4.

A user can run the created Macro by using the shortcut key that he has specified while creating the Macro. The macro records the user's mouse clicks and keystrokes while he works and lets him play them back later. The macro can be used to record the sequence of commands that the user uses to perform a certain task. When the user runs the macro, it plays those exact commands back in the same order. Answer option C is incorrect. The benefit of connecting to external data from Microsoft Excel is that a user can automatically update Excel workbooks from the real data source whenever the data source is updated with new information. It is possible that the external data connection might be disabled on the computer. For connecting to the data source whenever a workbook is opened, it is required to enable data connections by using the Trust Center bar or by putting the workbook in a trusted location.

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: D

ActiveX controls are used on worksheet forms, with or without the use of VBA code, and on VBA UserForms. They are used when a user needs more flexible design requirements than 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 sheets from the user interface or to XLM macro sheets. It is not possible to assign a macro to run directly from the ActiveX control. 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 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 2013 programs.

Correct Answer: CD

Take one of the following steps to delete a slicer:

1.

Right-click the slicer, and then click Remove .

2.

Click the slicer, and then press Delete.

Answer options B and A are incorrect. These are invalid answer options.

Correct Answer: ABD

The following steps are taken to input Excel array formulas:

1.

Highlight the range of cells that a user wants to use as an input in his array formula.

2.

Type the array formula into the first cell or make this cell editable by pressing F2 or clicking

in the formula bar if a user has already specified a value into the first cell.

3.

Press CTRL-SHIFT-Enter.

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

Correct Answer: C

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 D 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 A is incorrect. 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. 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: D

A macro is defined as a tool that permits a user to automate tasks and add several functionalities to forms, reports, and controls. For example, if a user adds a command button to a form, he associates the button's OnClick event to a macro,

and the macro consists of the commands that are to be performed by the button each time it is clicked. The macro records the user's mouse clicks and keystrokes while he works and lets him play them back later. The macro can be used to

record the sequence of commands that the user uses to perform a certain task. When the user runs the macro, it plays those exact commands back in the same order.

Answer option B is incorrect. Evaluate Formula is a 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 options A and C are incorrect. The benefit of connecting to external data from Microsoft Excel is that a user can automatically update Excel workbooks from the real data source wheneverthe data source is updated with new

information. It is possible that the external data connection might be disabled on the computer. For connecting to the data source whenever a workbook is opened, it is required to enable data connections by using the Trust Center bar or by

putting the workbook in a trusted location.