Working with the MS Excel Worksheet
Airfare Daily Deals eCigarettes Eyeglasses Hotels Jewelry Online Backup Online Dating Online Printing Online Tickets Skin Care Textbook Rentals Vitamins Web Hosting Weddings
Find thousands of shopping-related forums
SEARCH

Working with the MS Excel Worksheet

Working with the MS Excel Worksheet What's on Screen? When you create a new workbook, the Microsoft Excel window displays a worksheet with a grid of rows and column location, for example C3. The Standard and Formatting toolbars, which are located at the top of the screen, have buttons that provide easy access to common tasks.

Working with the MS Excel Worksheet

What's on Screen?

When you create a new workbook, the Microsoft Excel window displays a worksheet with a grid of rows and column location, for example C3. The Standard and Formatting toolbars, which are located at the top of the screen, have buttons that provide easy access to common tasks.

A worksheet consists of the following sections: Columns and Rows:

• There are 256 columns in a single worksheet. Since the English alphabets are used to label columns, the label for the 27th column is AA, while the 53rd column is BA and so on till the 256th column is IV.

• There are 65,536 rows in a worksheet. The first row is labeled 1 while the last row is 65536.

Cells: A cell is the meeting point of a row and a column. For example, the first cell is referred to as A1 (column A, row 1). Similarly, F3 is the intersection of column F and row 3. Data and formulas are entered into the cells.

Menus and Toolbars: Menus provide access to the various tasks that you can perform with Excel, such as opening and closing a worksheet. Toolbars are shortcuts for some commonly used menu items. By default, the Standard and the Formatting toolbars are displayed.

Sheets: Excel is organized like a workbook with multiple pages labeled Sheet 1, Sheet 2 and so on. By default only six sheets are displayed. In order to work with more sheets, you need to drag the Tab split box (the small box between the sheet tabs and the horizontal scroll bar) to the right or left. To return to the default display of sheet tabs, double-click the box.

Each worksheet is independent of the other, although the values in different sheets can be combined to present a consolidated data set.

Opening a New Workbook

The steps to create a sample workbook are:

• Select the New button from the File menu.

The workbook opens with New workbook task pane.

• Opt out for My Computer link.

• The Templates dialog box appears on the screen.

• Select the Spreadsheet Solutions tab in the dialog box.

• A list of all installed sample workbooks is displayed

Work in cells and ranges

When you work with data in worksheet cells-for example, entering, copying, deleting, or formatting data-first you select the area to work in. The selection can be a single cell or a range of cells.

After making your selection, perform the action you want. Data you enter and work with can be text, such as a list of names and addresses; values, such as revenues or units sold; or a formula that calculates a value.

 

Need an answer?
Get insightful answers from community-recommended
experts
in Software on Knoji.
Would you recommend this author as an expert in Software?
You have 0 recommendations remaining to grant today.
Comments (0)
ARTICLE DETAILS
RELATED ARTICLES
ARTICLE KEYWORDS