In its simplest form, a spreadsheet is a table of rows and columns that contains data, both text and numbers, on which you perform actions, such as sorting and calculations, both simple and complex.
Spreadsheet consists of worksheet, rows, cells and columns all of which we will be looking at today.
Spreadsheet consists of worksheet, rows, cells and columns all of which we will be looking at today.
A row is a series of data banks laid out in a horizontal fashion in a table or spreadsheet. For example, in the picture below the row headers (row numbers) are numbered 1, 2, 3, 4, etc. As you can see from the picture below, row 16 is highlighted in red and cell D8 (on row 8) is the selected cell.
An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. A worksheet begins with row number one and column A. Each cell can contain a number, text or formula. A cell can also reference another cell in the same worksheet, the same workbook or a different workbook.
|
A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by an outline or border as shown in the image to the right. |
the toolbar
|
The shortcut buttons in the Spreadsheet document on the left will provide you with some examples, demonstrate how spreadsheets are useful for working with data. |