We assume that you have read through the features described in Chapter 1’s Tables 1 to 3, and that you have familiarized yourself with various Excel features. To refresh your memory: A worksheet consists of columns (vertical) and rows (horizontal). A cell is an intersection of a row and column where a user can enter data. A cell reference is referred to as the active cell, your selection of a certain cell. Example in Figure 7, your cell reference is A1. A cell range refers to a selection of multiple cells, indicating the area that has been selected e.g. A1
When you select a cell, it provides a cell reference with the name of the cell. The rectangular box in a worksheet is referred to as a cell. A cell reference (A1) appears in the name box as indicated in Figure 8.
Let’s delve a bit deeper and explore the other important parts of the worksheet shown in Figure 9:
Table 4. Other Parts of the Excel worksheet
There is also a hidden menu you can access at any time, called the ‘Shortcut menu’. Right click anywhere in your worksheet on a cell to get a list of commands often used. Also beware of the many hidden visual cues that pop up as you interact with the interface, like action buttons and information pop ups that appear when the mouse hovers over information. To access the ‘Key Tips’, you can press Alt to show you keyboard keys you can press to access various commands on the ribbon.
Detailed example 1:
Worksheets can be added and renamed once they are in the workbook. If you have a computer, please do the following to rename and insert new sheets:
1. On the Sheet tab bar, right-click the sheet tab that you want to rename, and then click Rename. Note: alternatively, you can double click the tab and type in the new worksheet name.
2. Now type the new name, e.g. January, for the worksheet and press enter.
3. The to the right of the worksheet names is the easiest way to add a new worksheet, and is called the ‘new sheet’ tab. Click it to add Sheet3.
4. Worksheets can be moved around to change their order by left-clicking, holding and dragging it to the position you want it to appear.
5. Now try to rename Sheet2 to February, and move it to after the January worksheet.
A great use of Excel is to create a personal budget consisting of monthly income and expenditure, and every month’s expenses can be listed on separate sheets as in our example. If you are working in Excel, save a copy of this file you have just created for use in a later reading.