For each step in the assignment, make changes to this spreadsheet as described
in each step.
1. In the cell below, write what Excel will do by default when a formula is copied:
2. Cut and paste cell D16 to cell E16, then change the value in D13 to 10.
3. In the cell below, write the steps for using AutoFill to copy a formula to adjacent 18 cells:
4. In the cell below, write what Excel will do by default when a formula is copied using AutoFill:
5. In the cell below, write how to access pasting options after you have pasted data:
6. In the cell below, write what will be true of linked data after you copy a formula and paste it as a link to another location:
7. In the cell below, write the absolute cell reference for column D, row 7, and write an explanation for when an absolute cell reference may be useful:
8. In the cell below, write the mixed cell reference with an absolute column F and relative row 12:
9. In the cell below, write the relative cell reference for column C, row 3:
10. In the cell below, write the mixed cell reference with a relative column B and absolute row 9:
11. In the cell below, write two ways to insert a row or column:
12. In the cell below, write the steps for inserting a range of cells in a worksheet:
13. Insert a row of cells below.
14. Insert a column of cells to the right of column A