Microsoft Office Tutorials and References
In Depth Information
Working with Excel Fundamentals
Another new feature that goes hand in hand with the Ribbon is the Quick
Access Toolbar. (So there is a toolbar after all!) In Figure 1-5 the Quick Access
Toolbar sits just above the left side of the Ribbon. On it are icons that
perform actions with a single click. The icons are ones you select by using the
Customization tab in the Excel Options dialog box. You can put the toolbar
above or below the Ribbon by clicking the small drop-down arrow on the
Quick Access Toolbar and choosing the option. In this area too are the other
options for the Quick Access Toolbar.
Working with rows, column,
cells, ranges, and tables
A worksheet contains cells. Lots of them. Billions of them. This might seem
unmanageable, but actually it’s pretty straightforward. Figure 1-7 shows a
worksheet filled with data. Use this to look at a worksheet’s components.
Each cell can contain data or a formula. In Figure 1-7, the cells contain data.
Some, or even all, cells could contain formulas, but that’s not the case here.
Columns have letter headers — A, B, C, and so on. You can see these listed
horizontally just above the area where the cells are. After you get past the
26th column, a double lettering system is used — AA, AB, and so on. After all
the two-letter combinations are used up, a triple-letter scheme is used. Rows
are listed vertically down the left side of the screen and use a numbering
You find cells at the intersection of rows and columns. Cell A1 is the cell
at the intersection of column A and row 1. A1 is the cell’s address. There is
always an active cell — that is, a cell in which any entry would go into should
you start typing. The active cell has a border around it. Also, the contents of
the active cell are seen in the Formula Box.
When we speak of, or reference, cell, we are referring to its address. The
address is the intersection of a column and row. To talk about cell D20 means
to talk about the cell that you find at the intersection of column D and row 20.