Excel has many commands-- most of which can be executed through menus and toolbars.
The Menu bar is located at the top of the spreadsheet. It contains a row of nine menus that handle a unique set of tasks:
Filemenu – controls file operations.
Edit menu – rearranges data.
View menu – provides different ways to look at your spreadsheet.
Insert menu – Adds charts, pictures, and other objects.
Format menu - changes the appearance of cells.
Tools menu – analyzes and protect your data.
Data menu – manipulates your information.
Window menu - displays your open spreadsheets.
Help menu – provides information about all of Excel’s features.
Click on a menu name to see a drop-down list of its items. Some items contain other menus. And others trigger the opening of special forms called dialog boxes. Dialog boxes request additional information before carrying out a command.
Below the Menu bar are the Standard and Formatting toolbars. A toolbar is a row of mostly buttons with pictures on them. By simply clicking on a toolbar’s button, you can instantly perform a variety of tasks. The Standard toolbar has buttons for saving, opening, and printing spreadsheets. And the Formatting toolbar has ones for aligning data and changing the color of an entire cell.
It’s pretty hard to remember what each button does. But don’t worry. If you place your mouse pointer over a button, a little box describing the button’s purpose will appear.
By default, the Standard and Formatting toolbars are both available when you open a spreadsheet. But you can add other toolbars to help you draw pictures and shapes, track revisions, or find errors. Adding a toolbar to your spreadsheet is simple. Go to the Menu bar, click on the View menu and choose Toolbars. You can now select the toolbar of your choice.