COMPONENTS OF MICROSOFT EXCEL


TITLE BAR: This is a bar at the top of an application or document that indicates its Name.

MENU BAR:This is a list commands displayed below the title bar of an application which when click draws down a pull down menu.

 

STANDARD TOOLBAR: A bar containing the buttons that when clicked produces instant actions like Bold, Italic, Underline etc.

COLUMNS These are the vertical lines that run across worksheet from the top to bottom, labeled alphabetically i.e A B C D E F… IV. There are 256 Columns in Microsoft Excel.

ROWS: These are the horizontal lines that runs across the worksheet from left to right, labeled numerically i.e. 1 2 3 4 5 6 ………………… 65536

 

FORMULA BAR: As you type in data into the active cell, it appears in the formula bar, which you can also use to edit your cell content.

CELL:The intersection of each Column and Row is referred to as a Cell. Each cell can hold a single piece of information known as “ENTRY”. When you select a cell on a worksheet, the cell becomes active and that’s what is called “ACTIVE CELL” in Microsoft Excel.

NAME BOX:The reference name or identifier for a particular cell is known as the cell address.

RANGE: A range is a collection of two or more cells in a row or column within a worksheet.

WORKSHEET: This is the main Microsoft Excel workspace. A single sheet contains a maximum of 65536 Row and 256 Columns. Microsoft Excel displays a particular sheet you are working on by showing a tick border around the sheet name. that’s what is referred to as “ACTIVE SHEET” in Microsoft Excel. 

SHEET TAB:Allows you to switch between worksheet and also shows you the worksheet number and/or name.

SCROLL BAR: A gray horizontal/vertical line that enables the mouse to move around the screen. It contains the scroll arrow and tab.

WORKBOOK: In Microsoft Excel, documents are called workbook or books unlike Microsoft Word where we have things like “Document 1, Document, Document 3 etc”. Workbooks keep the sheets (pages) you need together in the same file. The workbook can contain different charts, sheets, images/pictures etc. you can switch between sheets by clicking the sheet number or name tabs at the bottom of a workbook. In summary, workbook is the collection of worksheets. There are about 255 worksheets in a workbook. A workbook is also called a spreadsheet in Microsoft Excel. It is the printable document that you use to store and manipulate data.

CELL POINTER:It is the rectangular bar in the worksheet that moves around the screen. It sometimes indicates the position of your cell at any point in the worksheet. It also makes a cell active. Remember that whatever you type must appear in the active cell.