explain the components of ms Excel sheet?
Answers
Component of Excel Sheet
Workbook
Also called a spreadsheet, the workbook is a unique file created by Excel XP.
Title Bar
The title bar displays both the name of the application and the name of the spreadsheet.
Menu Bar
The menu bar displays all of the menus available for use in Excel XP. The contents of any menu can be displayed by left-clicking the menu name.
Toolbar
Some commands in the menus have pictures or icons associated with them. These pictures may also appear as shortcuts in the toolbar.
Column Headings
Each Excel spreadsheet contains 256 columns. Each column is named by a letter or combination of letters.
Row Headings
Each spreadsheet contains 65,536 rows. Each row is named by a number.
Name Box
This shows the address of the current selection or active cell.
Formula Bar
The formula bar isplays information entered—or being entered as you type—in the current or active cell. The contents of a cell can also be edited in the formula bar
Cell
A cell is an intersection of a column and row. Each cell has a unique cell address.
Answer:
MS Excel has following components :-
1.Autosum
2.Conditional Formatting
3.Hide,unhide,freeze ,unfreeze rows & columns
4.Page break
5.page margin,Orientation, Size,Print area,Background, headlines, headers,footers,gridlines