in this tutorials we learn about the different components of Excel 2007 Spreadsheet. Excel 2007 is Spread sheet application of Microsoft office in which data is orgnized in form of table which contain column and rows. each combination of row and column is called cell where the particular value store. below we discuse one by one each components in detail.
When we open MS Excel 2007 then the first Screen comes called Excel Window and this window have different section. below the Image shown each and every section of Excel environment.
In MS Excel window in the left corner from top button is place is called Microsoft Office button. When you click this button then a menu appears which contain different general option for example new for creating a new file , open for open an existing file and save option for saving the file and many other option.
This is little bar which is placed close to the Office button. The Quick Access toolbar gives you with access to commands you frequently use. By default it contain Save option , Undo, and Redo option. You can add more option which you perform frequently .
For adding more Option in Quick Access bar click on a little arrow button on right side of the Quick access bar which is use for Customization of Quick Access tool bar. Its display a menu with different option click on any option which you want to add in Quick Access Bar.
The title bar contains the name of the program. On the extreme right are the buttons to minimize, maximize/restore and close. On the Title bar, Microsoft Excel displays the name of the workbook you are currently using.
This panel is located at the top of the program window. The office ribbon contain following item:
Command Tab
This is also called menu tab. This tab contain some option. when we select any option then related command are display below this tab.
Contextual command Tab
This tab is below the Command Tab. When we click on any option from Command tab then related commands depending on your context are appears in this tab. This section Divided in to groups Each group Have different Command related with same type of task
Formula bar is contain the cell address of the cell you are in displays in the Name box which is located on the left side and Cell entries Box which display on the right side of the Formula bar. You can enable and disable this bar.
Click on View Tab.
Click Formula Bar in the Show/Hide group. The Formula bar appears.
In the bottom of working window a bar is called status bar which displays status information and includes buttons that allow you to change your view .The Right side on the status bar there are Sheet tab by clicking on any tab the related sheet Contents will be open in Work Sheet. by default these tab have Sheet1 , sheet 2, sheet3. You can rename these sheets tabs name. For this purpose right click on sheet and select rename. You can also Change the sheet tab color by right clicking on sheet and select tab color. You can also add more Sheet Tabs by clicking on Insert Work Sheet Button in end of All Sheet Tabs. Status bar also contain The Zoom section from which we can zoom in the page or zoom out the page by moving the scroll right and left.
PMT() Financial Functions
Calculate the Sum of a Range Using AutoSum function
User Define Function (UDF) In Excel
Macros In Excel
Relative and Absolute Cell Reference in MS Excel
Page Setting and printing In MS Excel
Fill In Excel
How we use The Functions in MS Excel
How we Write Excel Formulas
Components of Excel 2007 Environment
Rounding The Numbers MS Excel
SUMIF FUNCTION In MS EXCEL
COUNTIF Function In MS Excel
COUNTBLANK Function In MS Excel
VLOOKUP Function In MS Excel
Pivot Table In MS Excel
Consolidation In MS Excel
Remove Duplicate Value In MS Excel
Convert Excel Data in to a Table