MS Excel Learning Classes – 2

MS Excel Learning Classes – 2

MS Excel  Interface

Excel screen consists of five areas:

  • the workbook window, which occupies most of the screen;
  • the menu bar;
  • two or more toolbars;
  • the formula bar;
  • and the status bar.

A document window consists of the following parts:

Document Control icon

Used to size and position the window using the keyboard. (Note: Use the mouse to perform the same options available in the Control menu).

Scroll bars

Placed at the right and bottom borders of the document window, scroll bars facilitate moving around a worksheet using the mouse.

Sheet tabs

Sheet tabs identify the various pages in a workbook. Using the mouse, you click a tab to move to that particular page or double-click a tab to rename it.

Tab Split box

Using the mouse, you drag the tab split box to increase or decrease the space shared by the sheet tabs and the horizontal scroll bar.

Tab Scrolling arrows

Using the mouse, you click the tab scrolling arrows to move quickly to the first sheet, previous sheet, next sheet, or last sheet in a workbook file.

The Workbook

  • Excel file is called a workbook, in which you work and store your data.
  • You can think of an Excel workbook as a three-ring binder with tabs at the beginning of each new section or topic.
  • This is Excel’s name for a file having .xls , xlsx as extension.
  • Most of the Excel screen is devoted to the display of the workbook.
  • The workbook can have multiple sheets with different information on each sheet.
  • The workbook consists of grids and columns.
  • This permits you to keep related data in one file rather than break it up into several different files.
  • In addition, the term workbook will refer to the book of pages that is the standard Excel document.
  • The workbook can contain worksheets, chart sheets, or macro modules.
  • Each that can hold many worksheets.
    • In a workbook, you can add and delete sheets, copy information from one sheet to another, and organize your information into logical sections.
  • Each workbook appears in its own document window, which can be minimized to an icon, maximized to fill the entire document area, or displayed as a window.
  • A worksheet is the most common sheet that you will create in an Excel workbook file. Other sheets may include chart sheets and macro or module sheets.
  • Each new workbook contains blank sheets.
  • Similar to a large piece of ledger paper, a worksheet is divided into vertical columns and horizontal row.
  • Each cell is given a cell address, like a post office box number, consisting of its column letter followed by its row number.

Worksheets  

  • The worksheet is a grid of columns (designated by letters) and rows (designated by numbers).
  • The letters and numbers of the columns and rows (called labels) are displayed in gray buttons across the top and left side of the worksheet.
  • A worksheet is divided into a grid of columns and rows.
  • The Excel worksheet contains 256 columns.
  • It is used to list and analyze data.
  • A letter is assigned to each column and appears as a column heading above the worksheet grid.
  • The column letters range from
  • A through IV.
  • After column Z comes column AA, after AZ comes BA, and so on, up to IV.
  • A number is assigned to each row and appears as a row heading to the left of the worksheet grid.
  • The row numbers range from 1 through 65,536.
  • You can enter and edit data on several worksheets simultaneously and perform calculations based on data from multiple worksheets.
  • When you create a chart, you can place the chart on the worksheet with its related data or on a separate chart sheet.
  • The Excel worksheet can contain as many as 256 sheets, labeled Sheet1 through Sheet256.
  • The column width is 256 characters.
Spread the love
About admin 2013 Articles
Please feel free to contact us or send your comments. [email protected]