MS Excel Tutorial

Components of Excel 2007 Environment

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.

The Microsoft Excel Window

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.

Excel spreadsheet

The Microsoft Office Button

Office Button

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.

The Quick Access Toolbar

Quick Access Toolbar

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

Title 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.

The Office Ribbon

The Ribbon

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

The Formula Bar

Formula bar
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.

  1. Click on View Tab.

  2. Click Formula Bar in the Show/Hide group. The Formula bar appears.

The Status Bar

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.