Microsoft Excel Interface
Microsoft Excel Interface:
Excel interface is very simple and efficient. It provides methods for carrying out tasks with minimum clicks of the mouse. It also provides ways to word with the keyboard.
Elements of Excel Interface:
The worksheet is where you enter all your data. Excel’s worksheet is made up of column and rows. in worksheet , there are 256 columns and 65,536 rows. Rows are label with numbers (1,2,3….)and columns are label with letters (A,B,C….. AA, AB ,AC….). Cells are then label with both the column letter and row number in that order.
A workbook is a group of worksheets saved together as one excel file. By default each workbook in Excel contains 3 worksheets. The first sheet is called Sheet 1 the next is Sheet 2 and so on. When you save a workbook, you are also saving changes made to each worksheet in the workbook.
3. Active Cell:
you use the active cell to tell excel where you want to enter or edit data.
4. Title bar
Title bar is located at the very top of the screen. Microsoft Excel displays the name of the current workbook on it.
The menus very from program to program. in general. we use menu commands to do thing like moving, copying, and erasing blocks of data, inserting or deleting columns and rows, printing, saving, and changing the appearance of data etc.
Toolbar’s provide shortcuts to menu commands. Toolbar’s are generally located just below the menu bar. Toolbars consist of icons that act as short cuts to the command found under the menus headings.
The toolbar that usually appears below menu bar is called standard Toolbar. So these toolbars can be customize and move around on the screen The option for displaying or hiding a tooolbar is available in view> Toolbars.
The next bar is the formula bar. This bar displays the location of the active cell and the value or formula used in the active cell.
The intersection of row and column is a cell and a cell holds data Cells may contain text, numbers, and even graphical patterns. They can also contain formulas, which display results based on the values in other cells.
9. Cell address:
cells are identify by combination of their column letter and row number. The fifth cell in second column is as cell B5. is is known as cell’s address or cell coordinates.
10.column and Row Heading:
the rowes of letters that stretch across the spreadsheet are the column heading. column headings represent name of columns. the rows of numbers that stretch down the spreadsheet are row heading. Row headings represent the names of the rows.
11. Sheet Tabs:
Sheet tabs at the bottom of the workbook. And you can click on the sheet tabs to move from one sheet to another in a workbook. You can click on the tab scrolling buttons to scroll the display of sheet tabs one at a time, or to display the first or last grouping of sheet tabs within a workbook.
12. The status Bar
Status bar appears at the bottom of Excel interface and It displays information about a command, a toolbar icon or an operation in progress.
13. Task pane:
The Task pane is Excel contains a few existing features. It makes then better and more effective. It is use for creating new files, accessing template, opening recently used files. searching for files, copying multiple items, inserting clip art etc. A dialog box stops the used from doing any thins else as along as the the dialog box appears.
The task pane remains available on one side. Its option are visible at all time. It can hide by going to the View menu and removing the check next to the task pane option.
A smart tag appears when the user makes an entry and Microsoft excel believes the user may want to change. Smart tags provide the facility to make changes easily. Cells with smart tag in appear with a green triangle in upper left corner. When the user places cursor in the cell, the Trace Error icon appears. Clicking on Trace Error icon displays its options. This feature is available in MS Excel XP.