| Program | Its own file format | Template format |
|---|---|---|
| LibreOffice Calc | .ods (OpenDocument Spreadsheet) | .ots |
| Microsoft Excel (2007 and later) | .xlsx | .xltx |
| Older Microsoft Excel | .xls | .xlt |
Inside a workbook
-
Worksheets
- Tabs such as Sheet1
- Add, rename, move or delete
-
Columns
- Run up and down
- Labelled A, B, C ... then AA, AB
-
Rows
- Run across
- Numbered 1, 2, 3 ...
-
Cells
- Where a column and a row meet
- Address: column letter + row number, such as C5
Address = column letter + row number (C5). Range = first cell : last cell (B2:D5). Cells in a range = columns × rows.
Key takeaways: a workbook holds sheets; a sheet is a grid of columns (letters) and rows (numbers); each cell has an address such as C5; a range such as B2:D5 is a block whose size is columns times rows. Calc saves as .ods and Excel as .xlsx, and each can read the other.