The Clipboard is a temporary storage area in the computer's memory where information is held when it is being copied or cut from one program or document and pasted into another. It allows users to transfer data such as text, images, or files between different applications.

In MS Word, you can automatically generate the following tables:

• Table of contents: Created by marking headings and subheadings in the document.
• Table of figures: Created by using captions for figures in the document.
• Table of tables: Created by using captions for tables, similar to the table of figures.

However:

• Table of important terms used: There is no automatic feature in MS Word to generate a table of important terms. This would typically need to be created manually or with the use of custom indexing, which is not straightforward.

Therefore, Table of important terms used cannot be automatically created in MS Word.

When pasting copied data in MS Excel, you have several options for controlling how the data is pasted:

• Transpose: Allows you to change the orientation of the copied data from rows to columns or columns to rows.
• Formula: Pastes only the formulas from the copied cells without any formatting.
• Hyperlink: Pastes any hyperlinks associated with the copied data.

Absolute is not a valid option for pasting data. While you can have absolute references in Excel formulas (using $), it is not an option available when pasting data.

Therefore, Absolute is not a valid pasting option in MS Excel.

In MS-Excel, every formula or function must start with the equals sign (=). This symbol indicates that the characters following it represent a formula or function to be calculated rather than plain text.

For example:

• To add two cells, you would type =A1 + B1.
• To use a function like summing values, you would type =SUM(A1:A10).