Ms-Excel 2013 Screen Component
Ms-Excel 2013 Screen Component..?
When You will open Ms-excel 2013, a window will display like below with various of functions and features with its category name. we will describe here in detail...
Some common component of excel window are already discussed in MS-Word chapter. Like- Title bar, Tab, Ribbon, etc. Now we discuss about some new component that are only used in Excel –
Name Box – It shows the cell reference or cell name of the current selected cell. Example- A1, B5, Marks, etc.
Formula Bar – It shows the value or formula
of current selected cell. It is used to edit in value or formula of the
Column Header – Column Header is a column identification character. Like – A, B, C, etc. When you click on any column header, entire column selected automatically.
Row header – Row Header is a Row identification character. Like – 1, 2, 3, etc. When you click on any row header, entire row selected automatically.
New Sheet – When
you click on the button a new blank sheet automatically inserted at this point
Workbook – Excel document is called a workbook. A workbook contains no. of sheet, by default it display 1 sheet (3 sheets in old version).
Worksheet – A sheet is a page that is collection of rows and columns. It contains 1048576 rows and 16384 columns (65536 rows and 256 columns in old version). Row is a horizontal bar and column is vertical bar in a sheet.
Cell – Where rows and columns are intersect, is called cell.
Cell reference – In a sheet each cell is a distinct from other. Each cell in a sheet has own address. Address is a combination of column header and row header, these combination are called cell reference. Ex- A1, B5, etc.
Cell range – Cell range is a combination of number of cells. Cell range written as starting cell reference and ending cell reference with colon (:) operator. Example- (A1:A10), (B1:D5), etc.