Insert Menu
To Insert Cells
Þ Select the required cells where you want to insert new blank cells.
Þ Click on Insert menu.
Þ Click on Cells command.
Þ Then a dialog box will appear.
Þ Choose any one option. (Shift cells right, shift cells down & insert entire Rows, Columns).
Þ Click on Ok
To insert rows
Þ Select the required rows where you want to insert new rows.
Þ Click on Insert menu.
Þ Click on Rows command
To insert columns
Þ Select the required columns where you want to insert new columns.
Þ Click on Insert menu.
Þ Click on Columns command.
To insert worksheet.
Þ Select the sheet name where you want to insert new worksheet.
Þ Click on Insert menu.
Þ Click on Work sheet command.
[Now a new worksheet will appear in the sheet tabs]
To insert chart
Þ First type the data for chart.
Þ Select the data range.
Þ Click on insert menu.
Þ Click on Chart command.
Þ Then a chart wizard box will appear.
Þ Choose any chart type and chart subtype form standard type tab. [For more chart types click on Custom types tab]
Þ Click on Next button.
Þ Choose the required option from series in [Rows or Columns]
Þ Click on Next button.
Þ Type the chart title in Chart title box.
Þ Type the X and Y category titles.
Þ Click on Axes tab and choose the required options.
Þ Click on Gridlines tab and choose the required options.
Þ Click on Legend and choose any option.
Þ Click on Data labels and Data table tab and choose the required options.
Þ Click on Next button.
Þ Now choose the required location to place chart.
Þ Click on Finish button.
[If you want to change the chart type, chart options, chart location etc then select the chart, click on Chart menu and choose the required options.]
Using Formula
Þ Put the active cell at the required cell where you want to use formula.
Þ Type (=) equal sign, [Formula always begins with (=) sign]
Þ Enter the formula with cell references and operators
Þ Press Enter Key
Functions Operators:-
| + | Addition |
| - | Subtraction |
| * | Multiplication. |
| / | Division |
| % | Percentage. |
| = | Equal comparison. |
| < | Less than |
| > | Greater than. |
| <= | Less than or equal to |
| >= | Greater than or equal to |
| <> | Is not equal to and/ Or/ Not Logic. |
Using Function wizard
Þ Place the cursor in cell where you want to insert Function.
Þ Click on Insert menu.
Þ Click on Function Command.
Þ Then a function wizard box will appear.
Þ Select the required Function category.
Þ Choose any Function name. (Sum, average, min, max etc.)
Þ Click on Ok.
Þ Then a dialog box will appear.
Þ Type the cell references in Number box.
Þ Click on Ok button.
To insert comment.
Þ Select the required cells where you want to insert comment.
Þ Click on Insert menu.
Þ Click on Comment command.
Þ Then a comment box appears.
Þ Type the required comments.
To show or Hide comments.
Þ Select the required cells that contains comment.
Þ Press opposite mouse button.
Þ Choose show comment/Hide comment.
To Edit or Delete comment.
Þ Select the required cells that contains comments.
Þ Press opposite mouse button.
Þ Choose Edit comments or Delete comments.
To insert Clipart.
Þ Click on Insert menu.
Þ Click on Picture command.
Þ Then a Clipart box will appear.
Þ Click any category.
Þ Choose any picture and press the mouse button.
Þ Choose Insert clip
Þ Then close the clipart box.
To insert Auto shapes.
Þ Click on Insert menu.
Þ Click on picture command.
Þ Click on Auto shapes.
Þ Then an auto shapes toolbar will appear.
Þ Choose any shape from toolbar.
Þ Press the mouse button and drag it to draw auto shapes.
To insert word art.
Þ Click on Insert menu.
Þ Click on Picture command.
Þ Click on Word art.
Þ Then a word art style box will appear.
Þ Choose any style.
Þ Click on Ok.
Þ Now type the required text.
Þ Click on Ok.
To insert Object (Paint brush picture)
Þ Click on Insert menu.
Þ Click on Object command.
Þ Then a dialog box will appear.
Þ Choose Paint brush picture.
Þ Click on Ok.
Þ Now draw any picture you like.
To insert hyperlink.
Þ Select the required cells or object where you want to insert hyperlink.
Þ Click on Insert menu.
Þ Click on hyperlink command.
Þ Then a dialog box will appear.
Þ Click on File of Browser for option.
Þ Choose the required file.
Þ Click on Ok.
Þ Again click on Ok.