HOW
TO MERGE CELLS: this command is used to join two or more
cells to form one but big cell,
Process:
highlight
the cells and from the home tab, click on format
and select format cell, click on
alignment from the box that will appear, click on merge cell from the four
Conner box and finally click OK.
HOW
TO GIVE CELL BORDER: though excel have is like a table
in times of description, but when printed out the border will not print
together with the write-ups, for your you excel work to print together with the
border you need to add cell borders to it. Now how can you add it? Follow the
procedure very well:
1. Highlight
the areas you want to give borders
2. then
from the home tab, click on format and select format cell, click on Border
from the box that will appear
3. select
the kind of border (style) you want by clicking on it
4. and
click on the outline and inside box then finally click ok
Note that “none” means NO BORDER:
HOW
TO DRAG THE CONTENTS OF A CELL
This may be needed when
typing and it happens that the particular range of cells where you placed your
text is no more required area for the worksheet, so you may be asked to
reposition the write-ups.
Procedure:
1.
highlight the required area of the
worksheet where the write-ups is
2.
place your mouse in the edge of the
highlighted area
3.
drag to any area of your choice
THINGS
TO KNOW ABOUT EXCEL:
1.
The rows are arrange numerically (123)
1-1048576
2.
The columns are arrange in alphabetical
order (ABC) A-XFD
3.
The formula must start with an equal-to
sign (=)
4.
You must know how to work with table
5.
Identification of cell address (cell
references)
6.
You should also be calculative and
statistical in nature
Etc.
