Cell Basics

In Excel cell function and references are helpful to better understand Excel spreadsheets. Use Excel cell reference functions as well.

Challenge!

  1. Open an existing Excel 2010 workbook. If you want, you can use this example.
  2. Select D3, and notice how its cell address appears in the name box and its content appears in the formula bar.
  3. Try inserting text and numbers.
  4. Use the fill handle to fill in data to adjoining cells both vertically and horizontally.
  5. Cut cells and paste them into a different location.
  6. Delete a cell, and note how the content underneath it shifts up to fill its place.
  7. Try dragging and dropping some cells to other parts of the worksheet.