Computer application II (use of packages) windows, msword, powerpoint, excel and internet table of content chapter One



Download 9.57 Mb.
Page50/66
Date20.04.2018
Size9.57 Mb.
#45533
1   ...   46   47   48   49   50   51   52   53   ...   66
The Microsoft Excel Window includes the following components:


ITEMS

MEANINGS

Rows

Rows are referenced by the numbers.

Columns

Columns are referenced by the alphabets.

Cell

A cell is an intersection of a row and a column. Cells can contain various types of data. A cell is referenced by the name of the column and row. For example, the first cell A1 is in column A and row 1.

Worksheet

A worksheet contains rows and columns and their intersection forms the cells. A worksheet consists of 65,536 rows and 256 columns.

Workbook

A workbook consists of worksheets. It is also referred to as an Excel file. A workbook can be defined as a set of worksheets.

The Down Arrow Key

You can use the down arrow key to move downward one cell at a time.


The Up Arrow Key

You can use the Up Arrow key to move upward one cell at a time.

The Tab Key


You can use the Tab key to move across the page to the right, one cell at a time.

Name box:

A name box displays the name of a selected cell and a range of cells.

Task Pane

A task pane serves as an additional navigation tool substituting the frequently used dialog boxes. The task pane appears each time you start Excel.

Horizontal scroll bar

A horizontal scroll bar serves as a tool to view the left or right part of the worksheet that is not displayed on the screen.

Vertical scroll bar

A vertical scroll bar serves as a tool to view the top or bottom part of the worksheet that is not displayed on the screen.

Sheet Tab

A sheet tab helps to navigate between worksheets in a workbook.

The Shift+Tab Keys

You can hold down the Shift key and then press the Tab key to move to the left, one cell at a time.

The Right and Left Arrow Keys

You can use the right and left arrow keys to move right or left one cell at a time.


Title bar: A title bar displays the name of the current workbook.



Menu bar: A menu bar consists of various menus, such as File, Edit, and View.



Toolbar: A toolbar contains buttons that provide easy access to the commands and functions of Excel.


Formula bar: A formula bar contains tools for creating and editing formulas.


Starting Excel

Opening Excel Worksheet

To start Excel, we perform the following



Click Start à Programs à Microsoft Excel

  • A blank workbook is opened.




Download 9.57 Mb.

Share with your friends:
1   ...   46   47   48   49   50   51   52   53   ...   66




The database is protected by copyright ©ininet.org 2024
send message

    Main page