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

In order to accomplish the task, Rick should take the following steps: Select all the five sheets.

Write a disclaimer message in the A1 cell of the active sheet. Grouping of sheets is a feature provided in Microsoft Office Excel 2013. Selecting more than one sheet groups those sheets. When multiple sheets are grouped, data that a user

enters or edits in the active sheet is reflected in all sheets in the group. To select all sheets, right-click a sheet

tab, and then click Select All Sheets on the shortcut menu.

Users can select multiple sheets by holding the Ctrl key while clicking the sheets. Answer option C is incorrect. Clicking the first sheet after selecting all sheets will ungroup the sheets and the message will only get inserted in the first sheet. Answer options B and A are incorrect. Both these options will work, but Rick will have to work more than required. Grouping sheets is a better option to work simultaneously on multiple sheets. Users can select multiple sheets by holding the Ctrl key while clicking the sheets. Answer option C is incorrect. Clicking the first sheet after selecting all sheets will ungroup the sheets and the message will only get inserted in the first sheet. Answer options B and A are incorrect. Both these options will work, but Rick will have to work more than required. Grouping sheets is a better option to work simultaneously on multiple sheets.

Correct Answer: ABD

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.

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.

Answer option D is incorrect. You can create a new document with the same details but it will increase the overhead and is a very time consuming process. Answer option D is incorrect. You can create a new document with the same details but it will increase the overhead and is a very time consuming process.

Correct Answer: D

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

=$B$3/100 * E8

According to the question, the formula will be inserted in cell F8 and then the cell's border will be dragged to the F12 cell. Furthermore, the incentive percentage is fixed for all sales managers

and the value is provided in the cell B3. You will have to insert a formula that refers to the B3 cell as an absolute reference. For this you will have to type currency symbol ($) before the row

name and column number. In order to accomplish the task, type the following formula in the cell F8:

=$B$3/100 * E8

When absolute reference is used for referencing a cell in a formula, dragging cell's border to another cell does not change the cell's reference. Answer options B and E are incorrect. This formula references the B3 cell as a relative reference.

After inserting the formula, when the cell's border is dragged, it will change the cell reference relatively.

Answer options A and C are incorrect. Ampersand symbol (and) is not used for referencing cells in Excel.