MS-Excel Interface and Moving in a worksheet

Certify and Increase Opportunity.
Be
Govt. Certified E-Governance Professional

MS-Excel Interface and Moving in a worksheet

Worksheet Interface
MS-EXCEL Window Elements
Microsoft Excel is a Spreadsheet package that is widely used for financial purposes. The workspace called the workbook is divided into a number of sheets called the worksheet.  It has following parts

• Menu Bar
• Status Bar
• Row and Row Number
• Column and Column Number
• Cell
• Cell Address
• Workbooks
• Worksheets
• Work Sheet tabs

Moving around a worksheet
To move between cells on a worksheet, click any cell or use the arrow keys. When we move to a cell, it becomes the active cell. To see a different area of the sheet, use the scroll bars.

 

To scroll	Do this
One row up or down	Click the arrows in the vertical scroll bar.
One column left or right	Click the arrows in the horizontal scroll bar.
One window up or down	Click above or below the scroll box in the vertical scroll bar.
One window left or right	Click to left or right of scroll box in the horizontal scroll bar.
A large distance	Drag the scroll box to the approximate relative position. In a very large worksheet, hold down SHIFT while dragging