Lesson 5


Exploring an Excel Worksheet

Excel Worksheet (Figure 1)

Excel Worksheet Cell Adress Scheme

Excel’s basic worksheet structure is based on usage of cells organized into columns and rows. When a cell of a column intersects with the cell of a row, the cell that is the result of this intersection results in a cell address containing the column and row. For example, in FIGURE 2 below, we see a block of contiguous cells containing a mixture of text and numbers. This is known as a range. In this range of data, notice that there are column headings (A, B, C . . .) at the top and there are also numbered row headings on the left (1, 2, 3 . . .). Let’s focus on column D and row 3. Where column D and row 5 intersect results in a cell address, D3. The data in cell address D3 is 616. If we focus on column A and row 4, we would be looking at the intersection of that column and row, which would be cell address A4. The data in cell address A4 is March. This scheme of intersecting columns and rows is used throughout Excel worksheets as the basis for determining cell addresses.

Figure 2

Know the location of the following (Figure 1):

  • Filename
  • User Account
  • Ribbon Display Option
  • Ribbon
  • Tabs
  • Quick Access Toolbar
  • Name Box
  • Formula Bar
  • Active Cell
  • Cell
  • Vertical Scroll Bar
  • Horizontal Scroll Bar
  • Add Sheet
  • Status Bar
  • Normal, Page Layout, Page Break Views
  • Zoom Control


Back to: Intro to Excel 2016 > Module 2 – Intro to Excel 2016

Leave a Reply