Introduction

Microsoft Excel XP is a spreadsheet application in the Microsoft Office suite. A spreadsheet is an accounting program because that the computer. Spreadsheets are primarily used to work-related with numbers and also text. Spreadsheets can assist organize information, such together alphabetizing a list of surname or notified records, and also calculate and analyze info using math formulas.

You are watching: A worksheet is made up of


By the end of this lesson, you must be may be to:Identify the components of the Excel windowUnderstand the differences in between a workbook and a worksheetUnderstand a cell and its prestige to ExcelMove roughly a workbook

The Excel window

Many items you view on the Excel XP display screen are conventional in most other Microsoft software application programs choose Word, PowerPoint, and previous versions of Excel, if some facets are specific to Excel XP.

*

Workbook

Also dubbed a spreadsheet, the workbook is a unique file created by Excel XP.

Title bar

*

The location bar displays both the name of the application and also the name of the spreadsheet.

Menu bar

*

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

Toolbar

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

*

Column headings

*

Each Excel spreadsheet has 256 columns. Each tower is called by a letter or mix of letters.

Row headings

*

Each spreadsheet consists of 65,536 rows. Each row is called by a number.

Name box

*

This mirrors the deal with of the current an option or energetic cell.

Formula bar

*

The formula bar isplays details entered—or being gotten in as you type—in the present or energetic cell. The contents of a cabinet can additionally be edited in the formula bar.

Cell

*

A cabinet is an intersection the a column and row. Each cell has actually a distinctive cell address. In the snapshot above, the cell attend to of the selected cabinet is B3. The hefty border about the selected cabinet is dubbed the cabinet pointer.

Navigation buttons and also sheet tabs

*

Navigation buttons allow you to relocate to an additional worksheet in an Excel workbook. They are used to display the first, previous, next, and last worksheets in the workbook.

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


Workbooks and worksheets

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

*

Column headings are referenced by alphabetic personalities in the gray boxes the run throughout the Excel screen, start with shaft A and also ending with column IV.

Rows are referenced by numbers that appear on the left and also then operation down the Excel screen. The first row is called row 1, if the last row is called 65536.

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

The cell

An Excel worksheet is comprised of columns and rows. Wherein these columns and rows intersect, they kind little boxes dubbed cells. The energetic cell—or the cell that deserve to be action 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 pillar letter and also the row number.

*

In the following picture, the cell C3—formed through the intersection of obelisk C and row 3—contains the dark border. It is the active cell.

*
Important termsEach cell has a distinctive cell address created of a cell's column and row.The active cell is the cell that receives the data or command you offer it.A darkened border, referred to as the cell pointer, identify it.

Moving approximately the worksheet

You can move about the spreadsheet in several ways.

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

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

*

The PageUp and also PageDown secrets on the key-board are provided to relocate the cursor up or under one screen at a time. Other tricks that move the energetic cell room Home, which move to the an initial column top top the existing row, and Ctrl+Home, which moves the cursor to the top-left edge of the spreadsheet, or cell A1.

To move between worksheets:

As mentioned, every workbook defaults to three worksheets. This worksheets are represented by tabs—named Sheet1, Sheet2 and also Sheet3—that show up at the bottom of the Excel window.

See more: How Much Does Michelle Obama Weight, Brother, Is She A Man, Michelle Obama`S Height, Weight

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

Challenge!

Display the components of every menu in the menu bar, and note the icons connected with specific menu choices. Shot to discover the pictures or shortcuts on the typical toolbar.Click every of the 3 worksheet tabs—Sheet1, Sheet2 and Sheet3—to end up being familiar moving from sheet to sheet in the workbook.Use the web page Up (PgUp) and also Page under (PgDn) tricks to obtain used come scrolling in a worksheet.Use the horizontal and vertical scrollbars to exercise scrolling up, down, left, and right in the worksheet.
*
Continue