Basic Concepts of Excel

In this tutorial, you can get to know some basic definitions which you must know while using Excel

1. Workbook - the very basic document in Excel, typically consists of 3 worksheets (1 in Excel 2016). The workbook is a file, it can be saved with a name on your hard drive.
2. Worksheet - part of the workbook which consists of cells organized into columns and rows where we actually enter the data.
3. Cell - part of the worksheet, which is located at the intersection of column and row. It contains a special entry.
4. Active Cell - cell selected by the click of a mouse, surrounded by a frame.
5. Address of the cell – this is the name of the cell. The address consists of a column and row names, such as the D8 (the address of the cell that is at the intersection of column D and row 8). Each cell has its own address, which is a unique address within the same worksheet.
6. Range - a group of cells. Range in Excel can be: cells in one column, for example, F3: F13, cells in one line, for example, F3: K3, cells with several columns and rows, eg C1: H9
7. Format - the appearance of the data, the way they are presented in a cell or range of cells. Format consists of for example style (Bold, italic, ...), border, background, text alignment, etc
8. Formulas and functions - all formulas that calculate the value based on the data from cells.