Excel concepts
Workbook: it consists of several worksheets. A worksheet is an Excel file. When you start Excel or create a document, the default workbook file name created in Excel is book1, book2 ,...... The extension is XLS.
Number of worksheets in the workbook: 1-255
Worksheet: A Workbook is used to store and process data in Excel. A Workbook (Excel file) can contain multiple worksheets, sheet1.sheet2 ,......
Two types of worksheets: Data worksheet and chart Worksheet
A worksheet consists of several cells.
Number of rows and columns in the worksheet. The number of rows is 1-65536, and the number of columns is 1-256.
Cell: it is the basic unit for storing data. It is formed by the intersection of rows and columns.
Cell address: column label + row number
Cell area: the area composed of multiple consecutive cells is called the cell area.
Cell region representation: consists of the cell address in the upper left corner and lower right corner of the cell area (separated by: In the middle)
Basic concepts in Excel