Question

if we move a cell containing a formula having reference to another cell in the worksheet. what will happen to the cell numbers using the formula?
a)cell row and columns will change at the destination
b) the cell row changes at the destination
c) the cell columns are changed at destination
d) no changes ​

Answer 1

Explanation:

Press Alt + F11. This gets you to the Visual Basic Editor, where VBA is written. ... ...

Choose Insert→Module in the editor. ...

Type this p rogramming code, shown in the following figure: ...

Save the function. ...

Return to Excel.

Click the Insert Function button on the Formulas tab to display the Insert Function dialog box. ...

1. Click OK.

Answer 2

Answer:

a)cell row and columns will change at the destination

Explanation: