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 mainly used to work-related with numbers and also text. Spreadsheets can assist organize information, such together alphabetizing a list of name or notified records, and also calculate and analyze details using mathematics formulas.

You are watching: An element in the excel window that displays the value


By the finish of this lesson, you should be may be to:Identify the parts of the Excel windowUnderstand the differences in between a workbook and a worksheetUnderstand a cell and also its prestige to ExcelMove about a workbook

The Excel window

Many items you watch on the Excel XP display are standard in most other Microsoft software application programs choose Word, PowerPoint, and previous execution of Excel, while some facets are specific to Excel XP.

*

Workbook

Also called a spreadsheet, the workbook is a unique document created by Excel XP.

Title bar

*

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

Menu bar

*

The menu bar displays all of the menus available for use in Excel XP. The materials of any menu can be presented by left-clicking the food selection name.

Toolbar

Some regulates in the menus have pictures or icons linked with them. These images may additionally appear together shortcuts in the toolbar.

*

Column headings

*

Each Excel spreadsheet contains 256 columns. Each column is called by a letter or combination of letters.

Row headings

*

Each spreadsheet has 65,536 rows. Each row is named by a number.

Name box

*

This shows the resolve of the current an option or active cell.

Formula bar

*

The formula bar isplays details entered—or being gotten in as girlfriend type—in the current or active cell. The materials of a cabinet can additionally be edited in the formula bar.

Cell

*

A cabinet is an intersection of a column and row. Every cell has actually a distinct cell address. In the picture above, the cell resolve of the selected cell is B3. The heavy border around the selected cabinet is dubbed the cabinet pointer.

Navigation buttons and sheet tabs

*

Navigation buttons permit you to move to an additional worksheet in one Excel workbook. Castle are used to display the first, previous, next, and also last worksheets in the workbook.

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


Workbooks and also worksheets

A workbook instantly shows in the workspace as soon as you open up Microsoft Excel XP. Each workbook has three worksheets. A worksheet is a grid of cells consisting that 65,536 rows through 256 columns. Spreadsheet information—text, numbers, or mathematical formulas—is gone into into various cells.

*

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

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

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

The cell

An Excel worksheet is comprised of columns and rows. Whereby these columns and rows intersect, they kind little boxes dubbed cells. The active cell—or the cabinet that deserve to be plot upon—reveals a dark border. All various other cells reveal a light gray border. Each cell has actually a name. Its surname is comprised of 2 parts: the tower letter and the heat number.

*

In the following picture, the cabinet C3—formed by the intersection of shaft C and also row 3—contains the dark border. It is the energetic cell.

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

Moving around the worksheet

You can move about the spreadsheet in several ways.

To move the cell pointer:To activate any cell, allude to a cell through the mouse and also click.To move the pointer one cell to the left, right, up, or down, use the keyboard arrow keys.To scroll with the worksheet:

The vertical role bar situated along the ideal edge of the display is used to relocate up or under the spreadsheet. The horizontal role bar located at the bottom the the display is offered to relocate left or right across the spreadsheet.

*

The PageUp and PageDown keys on the key-board are used to move the cursor up or under one screen at a time. Other tricks that move the active cell are Home, which move to the very first column ~ above the current row, and also Ctrl+Home, which moves the cursor to the top-left corner of the spreadsheet, or cell A1.

To move in between worksheets:

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

See more: Three Of Four Numbers Have A Sum Of 22. Of The Average Of, Three Of The Four Numbers Have A Sum Of 22

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

Challenge!

Display the materials of every menu in the menu bar, and note the icons connected with specific menu choices. Shot to uncover the photos or shortcuts top top the standard toolbar.Click every of the three worksheet tabs—Sheet1, Sheet2 and Sheet3—to become familiar moving from sheet to sheet in the workbook.Use the page Up (PgUp) and Page down (PgDn) secrets to get used come scrolling in a worksheet.Use the horizontal and vertical scrollbars to exercise scrolling up, down, left, and also right in the worksheet.
*
Continue