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.