Ms Excel Concepts of Workbook and Worksheet tips for beginners


 Workbook: - This is an Excel file. In which there are many work seats. In which data is stored. A workbook contains 256 work sites. Y defaults are three work seats. New work seat can be added or deleted. Can be renamed and in this, the work of copying the seat etc. can be done easily. When the workbook is open, the work site opens automatically. Only one workbook can be worked on at a time. Which is called active work seat.

 Work seat: - The work seat is like a page in a book. In which we can store data. A work seat has 65536 rows and 256 columns. And 65536 * 256 = 16777216 is a cell. Each call has a name. Which is defined by alphabet. This range is from A to IV = 256. And row is defined by numeric number. Its range is from 1 to 65536. It can be renamed.

Cell: - Cell is formed by the joining of Rio and column. A work seat consists of 65536 * 256 = 16777216 cells. Data is written to the cell. 255 characters can be written in a cell. The name of the cell is formed by combining the name of Call um and Row. This is the address of the cell. The two cell ads together form the range ads. In this, two or more cells can be merged and the function of cell formatting can also be done.

Comments