Insert Tab Microsoft Excel 2007 Full Knowledge Guide

Insert Tab Microsoft Excel 2007 

Insert Tab MS Excel 2007 Full Knowledge Guide

All the options under this Insert Tab Microsoft Excel. They are all related to bringing more than one page comment, object image clip art Chart Word Art and symbol and signature line etc. to the file.  

Table   

With this option you can insert pivot table and common table inserts in the sheet. 

Pivot Table and Pivot Chart: – With the help of this option, Pivot table and Pivot chart can be created.  

Table: – With the help of this option, the result of the formula use in the select column or row can be obtain as a table.  

Illustration 

Picture: – Can bring clip art, picture etc. made by it. By clicking on this option, a dialog box will open in front of you, now you can open a folder with photos from it and select the image from there and insert it into your page.  

Clip Art: – Can bring clip art made by it. For this you click on clip art, then a task pane will open in front of you. Go to the search bar in it and type the name of whatever art you want to take in it, it will bring you in front of you by searching and you can insert it in your page.   

Shape: – By this, you can bring an object made in different designs. Like – text box, line, rectangle, Oval, Basic shapes, Block Arrow, Flow Chart, Call out, Star and banner, etc.   

Smart Art: – Through this, you can write in different designs. On clicking smart art, a dialog box of smart graphic will appear in front of you. As soon as you click on All, the graphic design will start to appear, now you will click on the design in it. That design will be insert in your page. You can do the formatting etc. by clicking on the Design tab above.  

Chart  (Insert Tab Microsoft Excel)

With the help of this option, you can bring the selected record as a chart.  

Insert Tab MS Excel 2007 Full Knowledge Guide

You can select any chart design from it. You can try and make a chart of Sales, Purchase, Profit, Loss, in the chart.  

Column: – With this option, the records creat in the sheet can be view as Column chart.  

Line: – With this option, you can view the records created in the sheet as a line chart.  

Pie: – With this option, one can view the records made in the sheet as a pie chart.

Insert Tab MS Excel 2007 Full Knowledge Guide

Bar: – With this option, one can view the record made in the sheet as a bar chart.  

Area: – With this option, you can view the records created in the sheet as an area chart.

Using The Data Tab in Microsoft Excel 2007

Scatter: – With this option, the records create in the sheet can be view as a scatter chart.  

Other Charts: – With this option, the records create in the sheet can be see as other chart.

Links Hyperlink: – Through this, Heading file links bookmark etc. to the current file. On clicking this, the following dialog box will open.  

Browse for File Here, we link other files to current file. By clicking on this button, select the name of any file you wish and make it ok both the places. While doing so, where the cursor is. There the file name will come with its address. Now whenever you move the mouse on this name, the mouse will change into a hand. Which is a symptom of the link. On which you can open the linked file by ctrl + click.   

Note – The file you are linking to. That file must be from MS Office.  

Text

Under this option, you can insert text boxes in your page containing text, word art and design.  

Insert Tab MS Excel 2007 Full Knowledge Guide

Text Box: – With this option, you can insert a text box in your page. The advantage of inserting text text box is that you can drag that box anywhere and you can set any color you want.  

Header Footer : – This option is use to bring a header into the page. For example, the name of the book, text name etc. are use in the header. And use Footer option to bring footer in the page. For example, the name of the book writer is use in footer.  

Word Art: – Through this you can write in different design in your sheet.  

Signature Line: – With this you can put your signature in your sheet. And if you want to stamp the company, you can put it.  

Object: – With this you can bring an object to your document.  

Symbol: – By this, all kinds of symbols are stuck, Remember that only symbols with Math will be able to be insert only. When you have install the font of Math.

Related posts

Leave a Comment