Introduction

Microsoft Excel XP is a spreadsheet application in the Microsoft Office suite. A spreadsheet is an accountancy program because that the computer. Spreadsheets are primarily used to job-related with numbers and text. Spreadsheets can help organize information, such as alphabetizing a list of name or bespeak records, and also calculate and also analyze information using math formulas.

You are watching: An excel window area that displays the value contained


By the finish of this lesson, you must be may be to:Identify the components of the Excel windowUnderstand the differences between a workbook and a worksheetUnderstand a cell and also its importance to ExcelMove approximately a workbook

The Excel window

Many items you watch on the Excel XP screen are typical in many other Microsoft software program programs like Word, PowerPoint, and previous execution of Excel, when some elements are details to Excel XP.

*

Workbook

Also called a spreadsheet, the workbook is a unique record created through Excel XP.

Title bar

*

The title bar screens both the surname of the application and the name of the spreadsheet.

Menu bar

*

The menu bar displays every one of the menus accessible for usage in Excel XP. The contents of any menu deserve to be shown by left-clicking the menu name.

Toolbar

Some regulates in the menus have actually pictures or icons connected with them. These photos may additionally appear as shortcuts in the toolbar.

*

Column headings

*

Each Excel spreadsheet includes 256 columns. Each tower is named by a letter or mix of letters.

Row headings

*

Each spreadsheet consists of 65,536 rows. Each heat is named by a number.

Name box

*

This reflects the deal with of the current choice or active cell.

Formula bar

*

The formula bar isplays information entered—or being gotten in as girlfriend type—in the present or active cell. The components of a cell can also be edited in the formula bar.

Cell

*

A cabinet is an intersection of a column and also row. Each cell has actually a distinctive cell address. In the picture above, the cell resolve of the selected cabinet is B3. The hefty border roughly the selected cabinet is called the cell pointer.

Navigation buttons and sheet tabs

*

Navigation buttons enable you to move to one more worksheet in one Excel workbook. Castle are provided to screen the first, previous, next, and also last worksheets in the workbook.

Sheet tabs separate a workbook into specific worksheets. A workbook defaults to 3 worksheets. A workbook should contain at least one worksheet.


Workbooks and worksheets

A workbook immediately shows in the workspace as soon as you open Microsoft Excel XP. Every workbook has three worksheets. A worksheet is a network of cells consisting of 65,536 rows by 256 columns. Spreadsheet information—text, numbers, or math formulas—is entered into various cells.

*

Column headings space referenced by alphabetic characters in the gray boxes that run across the Excel screen, start with column A and ending with column IV.

Rows space referenced by number that show up on the left and then operation down the Excel screen. The an initial row is called row 1, while the last row is called 65536.

Important termsA workbook is made up of 3 worksheets.The worksheets room labeled Sheet1, Sheet2, and Sheet3.Each Excel worksheet is consisted of of columns and rows.In stimulate to access a worksheet, click the tab that claims Sheet#.

The cell

An Excel worksheet is made up of columns and rows. Wherein these columns and also rows intersect, they kind little boxes called cells. The active cell—or the cabinet that deserve to be acted upon—reveals a dark border. All other cells expose a irradiate gray border. Each cell has actually a name. Its name is comprised of 2 parts: the shaft letter and also the row number.

*

In the adhering to picture, the cabinet C3—formed through the intersection of obelisk C and row 3—contains the dark border. That is the active cell.

*
Important termsEach cell has a unique cell address composed of a cell's column and also row.The active cell is the cell the receives the data or command you give it.A darkened border, called the cell pointer, identify it.

Moving about the worksheet

You can move around the spreadsheet in number of ways.

To move the cell pointer:To activate any kind of cell, suggest to a cell through the mouse and click.To relocate the pointer one cabinet to the left, right, up, or down, use the keyboard arrow keys.To scroll through the worksheet:

The vertical role bar located along the right edge that the display screen is supplied to move up or under the spreadsheet. The horizontal scroll bar situated at the bottom of the display screen is offered to move left or right throughout the spreadsheet.

*

The PageUp and also PageDown secrets on the key-board are used to move the cursor up or down one display at a time. Other keys that move the energetic cell are Home, which move to the first column on the present row, and Ctrl+Home, which move the cursor to the top-left edge of the spreadsheet, or cabinet A1.

To move in between worksheets:

As mentioned, each workbook defaults to three worksheets. This worksheets are stood for by tabs—named Sheet1, Sheet2 and Sheet3—that appear at the bottom the the Excel window.

See more: Easily Convert 15 Meters Equals How Many Feet, How Many Feet In 15 Meters

To move from one worksheet to another:Click the paper tab—Sheet1, Sheet2 or paper 3—you want to display.
*

Challenge!

Display the components of every menu in the food selection bar, and also note the icons connected with certain menu choices. Shot to uncover the pictures or shortcuts top top the conventional toolbar.Click each of the 3 worksheet tabs—Sheet1, Sheet2 and Sheet3—to end up being familiar moving from sheet to paper in the workbook.Use the web page Up (PgUp) and also Page down (PgDn) secrets to get used come scrolling in a worksheet.Use the horizontal and also vertical scrollbars to practice scrolling up, down, left, and also right in the worksheet.
*
Continue