Lesson 13

Part II (Continuation of Spreadsheet, continued)

In this part, we will explore some of the options in the Edit menu.

1. Using the Fill Sequence Command

4342345

2. Using the Fill Range Command to Sum Entries on Column A

3. Inserting Rows and Columns using the Edit Menu

4. Inserting/Removing Rows & Columns using Toolbar Buttons

5. Finding the Difference

Part II


Practice Exercises

  1. Please start with a clean Spreadsheet window. Are you ready?
  2. Beginning at cell A1 input a sequence using x as the expression, a low value of 1, a high value of 10 and a step size of .5.
  3. Get a screen capture and paste it into your Lesson13 document (under a title of PART II).
  4. With the sequence from step 2 still showing, insert a column in front of column A (your column A will move to B).
  5. Next, insert a row above row 1 (your data will shift down one row).
  6. Get a screen capture. Add two blank spaces following the first screen capture and then paste this one.
  7. Set C2=B3/B2.
  8. Copy the formula in C2 to cells C3 through C20.
  9. Make column C wider to better view the numbers.
  10. Select column C and then open the Graph menu and select Column/Clustered. Your window should now look like:
  11. Get a screen capture. Add two blank spaces following the second screen capture and then paste this one.