Page 249 - open office
P. 249
Open a worksheet. Type the name of a school, say MI ER A Public School (in A1 cell) and then press the
down arrow key to make the cell A2 as the active cell.
ow, in cell A2, type PERFORMA CE REPORT . Move to row number 4. Type the headings of the data in
separate columns by pressing the right arrow key/mouse click: Enroll No. in column A, Name in column B,
Class in column C, Section in column D and Father’s Name in column E.
ow, we can feed data under the given headings in separate cells starting from the 5th row viz., below Enroll
No, Name, Class, Section and Father’s Name of each student in different row.
N ot e s
The ‘f
mula. When the data
is typed
The ‘fx’ button is used to enter or edit formula. When the data is typed in a cell, two buttons
The ‘fx’ button is used to enter or edit formula. When the data is typed in a cell, two buttons
er or
o ent
on is used t
x’ butt
edit for
o butt
ons
in a cell, tw
Cr
Tick Mark
and
the ‘f
er
oss Mark
af
on is the check
t
on, i.e.,
. Tick Mark
x’ butt
butt
appear
appear after the ‘fx’ button, i.e., Cross Mark and Tick Mark. Tick Mark button is the check
appear after the ‘fx’ button, i.e., Cross Mark and Tick Mark. Tick Mark button is the check
OK
it
butt
cancels
on
butt
butt
Cancel
the
is
Cr
on.
and
Mark
oss
on
as
mark button and it works as OK button. Cross Mark button is the Cancel button and it cancels
butt
mark button and it works as OK button. Cross Mark button is the Cancel button and it cancels
mark
on
w
it
and
orks
what ev er is typed. Aut oSum butt on is used t o calculat e the sum o f specified range o f cells.
whatever is typed. AutoSum button is used to calculate the sum of specified range of cells.
whatever is typed. AutoSum button is used to calculate the sum of specified range of cells.
MOVING IN A WORKSHEET
To work in ‘Calc’, commands or data have to be entered with the help of input devices like mouse and
keyboard in different cells of the worksheet. The following are some of the shortcuts for different actions in
the worksheet.
Using Mouse
To Select Action Required
Single Cell Click on the specified cell.
Multiple Cell Drag the mouse over the range of cells.
A Row Click on the row heading.
A Column Click on the column heading.
Multiple Rows Click on the first row number and drag till the required row.
Multiple Columns Click on the first column and drag till the required column.
Whole Worksheet Click on the uppermost left corner of the worksheet.
Using the Keyboard
To Move the Cell Pointer/Select Action Required
To move right Press the Right arrow or Tab.
To move left Press the eft arrow or Shift Tab.
To move above Press the Up arrow or Shift Enter.
Working with Spreadsheet 24

