For Seniors: How to Explore Microsoft Excel’s Unique Features - dummies

For Seniors: How to Explore Microsoft Excel’s Unique Features

By Faithe Wempen

Excel has many elements in common with the Microsoft Office interface, but the number-crunching program also has the features that are unique. For starters, sheets (which are equivalent to a page in a Word document) are also called worksheets. A workbook is the entire data file, containing one or more worksheets.

These unique Excel features include items such as row numbering, a Formula bar, and worksheet tabs:


  • Row numbers: Each row has a unique number. To select an entire row, click its number.

  • Column letters: Each column has a unique letter. To select an entire column, select its letter.

  • Cells: At the intersection of each row and column is a cell. You enter content into a cell by clicking the cell and then typing.

  • Active cell indicator (a.k.a. the cell cursor): This thick outline indicates which cell is the active cell — where your cursor is located at the moment. Whatever you type next appears in the active cell, and whatever commands you issue apply to that cell.

  • Name box: The active cell’s name appears here. For example, if the selected cell is at the intersection of column A and row 1, A1 appears in the Name box.

  • Formula bar: The contents of the selected cell appears here. If the content is text, that text shows here as in the cell itself. If the content is a formula, the formula appears here, and the result of the formula appears in the cell. For example, if the cell contains the formula =2+1, the formula bar shows =2+1 and the cell itself shows 3.

  • A formula is a math expression, beginning with an equals sign, such as =2+1. Formulas can also contain cell references. For example, =A2+B2 adds the amount found in cell A2 to the amount found in B2.

  • Worksheet tabs: By default, each workbook file has three sheets. They’re like pages in a notebook. Each sheet is shown as a tab; click a tab to switch to that sheet.