(Figure 1.4)
1.
The active worksheet window:
In
this part of the main Excel screen, you can
perform calculations, insert graphs, enter your
data etc. You can maximize the active worksheet
by clicking the maximize button
.When
working with a minimized screen, each window has
its own title. This way, you can open as many windows
as you like and still be able to identify them easily.
2.
The Title bar:
The
title bar indicates the title of the program you
are using and the file that is currently open. If
the file has not yet been saved, the title bar will
display the words Book 1. Whenever you minimize
your worksheet, a title bar will appear. This bar
will display the name of your file or the words
Book 1 if you have not yet saved the file.
3.
The Menu bar:
All
available Excel options are found here. Clicking
any one of these menus reveals a list of options,
called a "drop-down menu."
4.
The Tool bar:
This
bar, which contains what we call Quick buttons,
allows you to access certain options found in the
menu bars. It may be faster to choose options and
execute tasks with the tools on this bar, but not
all of the options are available. You will still
have to use the menus to access commands that are
not available through the tool bar. When you position
and hold the pointer over a button on the tool bar,
an indicator pops up to specify that button’s functions.
5.
Column and Row
A
worksheet is composed of 256 column and 65,536 rows
of data. Each column is identified by a letter (A=1,
B=2...Z=26, AA=27, AB=28 etc.) and rows are identified
by numbers. A column’s identifier is above it, the
row’s identifier is to its left.The dimensions of
column and rows can be adjusted to suit the need
of your worksheet.
6.
Cells
A
cell is an intersection of a column and a row. Each
cell in a worksheet has its own address. For example,
the intersection of the first column and the first
row has the address A1. The address of a cell is
always expressed useing this syntax: the column
followed by the row (AA789, BC6789 etc.).
7.
The Formula bar:
This
bar contains two distinct sections, the address
zone and the data entry zone. The address
zone indicates the location of the cursor on your
worksheet (the cell address). The data entry zone
is where you input the information that is to appear
in a cell.
8.
The scroll bar:
There
are two of scroll bars. This first is vertical and
it is used to scroll up and down across the rows,
while the second is horizontal and is used to scroll
back and forth across the columns. You can use the
scroll bars by clicking the arrows that point up,
down, left or right, or by dragging the square in
the scroll bar to move up or down.
9.
Status bar:
This
bar displays information on the selected function,
the status of the program, and certain keys on the
keyboard. For example, if you are modifying text,
the word EDIT is displayed.
10.
Page identifiers:
These
indicate which worksheet is active. They allow you
to switch from one page to another, since you can
have up to 256 pages in one folder of directory.
