Pages

Components of an excel workbook


COMPONENTS OF AN EXCEL WORKBOOK
Row Number
The horizontal group of cells is termed as a row. Each row is assigned a number. The row numbers appear on the left side of the workbook
Column Number
The vertical group of cells is termed as a column.Each column is assigned a number. The column number appears below the Formula Bar in the workbook.
Column Headings
The name given to each column is termed as column  heading. These appear just below the Formula Bar.
Vertical Scroll Bar
The vertical scroll bar consists of two buttons UpArrow Scroll button and the Down Arrow Scroll button. Clicking on any of these buttons allows you to see those rows of a sheet, which are not visible on thescreen.

Horizontal Scroll Bar
The horizontal scroll bar consists of two buttons:Right Arrow Scroll button and the Left Arrow Scroll button. Clicking on any of these buttons allows you to see those columns of a sheet, which are not visibleon the screen.
Select ‘All’ button
This is the first place where the row numbers and  column headings meet.
Sheet tab
Using this, one can move from one sheet to anotherof the workbook. By default, an Excel workbook has three sheets with its name displayed. The default names of these sheets are Sheet1, Sheet2 and Sheet3. These names can be changed and new names can be assigned to them. This tab appears just above the Status Bar.

No comments:

Post a Comment