Introduction

Microsoft Excel XP is a spreadsheet application in the Microsoft Office suite. A spreadsheet is an accountancy program for the computer. Spreadsheets are mainly used to occupational with numbers and text. Spreadsheets can assist organize information, such as alphabetizing a perform of name or bespeak records, and also calculate and also analyze info using math formulas.

You are watching: In excel the electronic spreadsheet is called


By the end of this lesson, you should be maybe to:Identify the parts 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 check out on the Excel XP screen are conventional in many other Microsoft software programs like Word, PowerPoint, and previous execution of Excel, while some elements are particular to Excel XP.

*

Workbook

Also referred to as a spreadsheet, the workbook is a unique paper created through 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 all of the menus available for use in Excel XP. The components of any kind of menu deserve to be shown by left-clicking the menu name.

Toolbar

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

*

Column headings

*

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

Row headings

*

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

Name box

*

This mirrors the deal with of the current selection or energetic cell.

Formula bar

*

The formula bar isplays details entered—or being entered as girlfriend type—in the current or energetic cell. The components of a cabinet can likewise be edited in the formula bar.

Cell

*

A cabinet is one intersection of a column and row. Every cell has actually a distinctive cell address. In the picture above, the cell address of the selected cabinet is B3. The heavy border about the selected cabinet is called the cell pointer.

Navigation buttons and also sheet tabs

*

Navigation buttons permit you to relocate to one more worksheet in an Excel workbook. Lock are provided to screen the first, previous, next, and last worksheets in the workbook.

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


Workbooks and worksheets

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

*

Column headings room referenced through alphabetic personalities in the gray boxes that run throughout the Excel screen, start with obelisk A and ending with shaft IV.

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

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

The cell

An Excel worksheet is made up of columns and rows. Whereby these columns and rows intersect, they type little boxes referred to as cells. The energetic cell—or the cell that deserve to be plot upon—reveals a dark border. All various other cells reveal a irradiate gray border. Every cell has actually a name. Its surname is comprised of two parts: the column letter and the heat number.

*

In the adhering to picture, the cabinet C3—formed through the intersection of pillar C and row 3—contains the dark border. It is the active 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 offer it.A darkened border, called the cell pointer, identifies it.

Moving approximately the worksheet

You deserve to move around the spreadsheet in several ways.

To move the cabinet pointer:To activate any type of cell, allude to a cell with the mouse and also click.To relocate the pointer one cell to the left, right, up, or down, usage the keyboard arrow keys.To scroll v the worksheet:

The vertical scroll bar situated along the appropriate edge of the display screen is used to move up or under the spreadsheet. The horizontal role bar situated at the bottom the the display screen is used to move left or right across the spreadsheet.

*

The PageUp and also PageDown tricks on the keyboard are supplied to relocate the cursor increase or under one display screen at a time. Other tricks that relocate the active cell are Home, which moves to the first column ~ above the present row, and also 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 3 worksheets. This worksheets are represented by tabs—named Sheet1, Sheet2 and also Sheet3—that show up at the bottom the the Excel window.

See more: What Is The Epiphyseal Plate Composed Of, Bone Development & Growth

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

Challenge!

Display the components of every menu in the food selection bar, and note the icons linked with specific menu choices. Shot to discover the images or shortcuts ~ above the conventional toolbar.Click every of the three worksheet tabs—Sheet1, Sheet2 and also Sheet3—to come to be familiar moving from sheet to sheet in the workbook.Use the page Up (PgUp) and Page under (PgDn) tricks to get used come scrolling in a worksheet.Use the horizontal and also vertical scrollbars to exercise scrolling up, down, left, and right in the worksheet.
*
Continue