Page 245 - open office
P. 245
N ot e s
labelled
is
as
A
column
Calc,
In Calc, the first column is labelled as A and the last column i.e. 1 24th column is labelled as AM . In
the
st
fir
and
as
labelled
is
In
.
AM
column
last
the
column
1 24th
i.e.
In Calc, the fir st column is labelled as A and the last column i.e. 1 24th column is labelled as AM . In
In
A
A
and
the
and
labelled
is
is
labelled
as
as
column
column
16,3 4th
is
labelled
labelled
is
16,3 4th
last
last
the
column
i.e.
i.e.
column
the
the
2 1 ,
st
fir
fir
MS-Ex
MS-Ex
MS-Excel 2 1 , the first column is labelled as A and the last column i.e. 16,3 4th column is labelled
2 1 ,
cel
cel
st
column
column
as ‘XFD’.
as ‘XFD’ .
Cells
A rectangular box formed by the intersection of a row and column is called a cell. Cell is the basic unit of a
worksheet where data (numbers, text, formulas, etc.) are entered.
Title Bar
It lies at the top of the window screen. It displays the name of the active workbook. When the spreadsheet is
newly created, by default it is named as Untitled1, second is Untitled2 and so on.
Menu Bar
It lies below the title bar in the active window screen. It contains different menus which have many options
to perform various operations. If you click on them or press ‘Alt’ along with the underlined character of the
menu name, the specific menu opens with its relevant options.
Standard Toolbar
It generally lies below the menu bar. It contains shortcut buttons of frequently used options. By clicking any
of them, the option is directly executed.
Show Draw
Functions
Sources
Open Edit File Print Cut Paste Hyperlink Sort Navigator Data
Page AutoSpell
New Save Preview Check Copy Undo Redo Descending Gallery Zoom
Document Export Spelling Format Sort Chart Find & Help
as e-mail Replace
Directly Paintbrush Ascending
as PDF
Formatting Toolbar
It lies below the standard toolbar. It contains shortcut buttons that provide quick access to frequently used
formatting options that help to change the appearance of the text or data inside the sheet.
NF: Add Increase
Align Right Decimal Places Indent
Style and Merge Decrease Background
Formatting Font Name Font Size Italic Align Le Cells NF: Percent Indent Color
Bold Underline Justi ed NF: Standard Borders Font Color
Align Center NF: Currency Delete Decimal
Places
Formula Bar
Formula bar lies below the formatting toolbar. Formula that performs different calculations in cells is entered
and displayed here. It is denoted by ‘fx’.
Working with Spreadsheet 245

