- Definition 1: Workbook
- A workbook is a spreadsheet file. By default, each workbook in Excel contains three sheets. Spreadsheet file names use .xls or .xlsx suffixes (i.e. file extension).
- Definition 2: Worksheet
- A worksheet is a single sheet in a workbook. By default, a workbook contains three worksheets.
- Definition 3: Column
- A column is a vertical block in a worksheet. Each column is identified by a letter in the column header.
- Definition 4: Row
- A row is a horizontal block in a worksheet. Each row is identified by a number in the row header.
- Definition 5: Cell
- A cell is the intersection of a column and a row. Cells are the basic building blocks of a worksheet. Each cell is assigned an address (e.g. cell reference, A1 means column A and row 1).
- Definition 6: Range
- A range is block of cells in a worksheet.
- Definition 7: Formula
- A mathematical formula that is run to compute results. Formulae are made up of standard arithmetic operations (e.g. +, -, *, /, ^).
- Definition 8: Function
- Functions are pre-constructed formulae that perform common calculations (e.g. summation and average). We can combine many functions and arithmetic operations in a single formula to carry out complex engineering computations.
