Question

1. Differentiate absolute and relative cell addressing.
2. Write steps to split the cell content in multiple lines when the contents are bigger than
column width?
3. Write procedure to insert three columns between columns D and E.​

Answer 1

Answer:

1)There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

2) Split cells

Click in a cell, or select multiple cells that you want to split.

Under Table Tools, on the Layout tab, in the Merge group, click Split Cells.

Enter the number of columns or rows that you want to split the selected cells into.

3) To insert columns:

Select the column heading to the right of where you want the new column to appear. For example, if you want to insert a column between columns D and E, select column E. ...

Click the Insert command on the Home tab. Clicking the Insert command.

The new column will appear to the left.

Explanation:

Hope this helps you