Create general spread sheet using axle. There show the
method of using data and formula/ function.
Create a new workbook after stating the Excel and save it selecting
the save command. Normal tasks as examples for use, write some information,
such as photo. Will abide by the rules for writing it;
1.
At the beginning empty 4 rows have been placed
for writing Name-Address. However, the row or column can be added after writing
anyway it is well to start in such way.
2.
Type SL in B5 sel. Press the Tab or Right-Aero.
Writing will there and will place on the right side of cell (C5).
3.
Similarly type description in cell C5, or write
that you need. In order to large-small in the side of any sell change the right
sight of cell name by dragging
4.
Anything writes the required information in this
manner. Noticed it, the price of each goods hasn’t type. Will use price formula
for each product and total Value function will be used.
Use Formula
1.
It should be stay 6 color pencils rate at 45
Taka in F6 Sel. The value is got from Multiply of D6 and E6.
2.
F6 cell type by pointer=d6*e6
3.
At the beginning noticed the use of =marks. It
is needed to different formula from normal text.
4.
The result will see after typing formula and
pressing enter. Generally the result will see in cell and select the cell you
can see the Formula-12 Formula.
5.
In the time of critical work many times a
condition to see the formula is managed.
Copy the formula
1.
Total value for 1 no product is found in which
formula copy it and transfer it in other cell the value of other product can be
found, don’t need to write formula frequently.
2.
Command (Ctrl + C) after selecting F6 cell. Let
us know from around the cell of marquee selection that it is copying.
3.
F7 and F9, select the Cells of the drug.
4.
Paste command (Ctrl + V)
5.
Same formula will use for each goods and value
can be found for them.
6.
In the time of copying formula row from row and
column from the column can be copied. But from column to row or row to column
cannot be copied.
7.
Here may be refers to use simple formula you can
use in any critical mathematics formula in same rule.
Using function
Many kinds of formula are made in Excel. Those are used
directly, cannot change. Those are called function. Many kinds of function
related Math and Statistics can be used easily from here. Such as example,
additions function is SUM, average of the function is AVG etc.
Here different values to the sum
of products are using as total sum by using function.
1.
Type by pointer in F10 cell= SUM (F6: F9)
2.
It means there show the summation the value of F6
to F9 cells.
3.
You can do the work many ways without typing the
whole thing.
4.
SUM (type)
5.
Using your mouse select F6 to F9 until the drug.
6.
Press Enter (or click right mark in formula bar).
The formula is as complex as spreadsheets; you can make it
in normal way. Repeatedly, you can utilize one again creating spreadsheets and submitting
their new information.
This is the basic structure of spreadsheets. Then change the
font, Align text to be, use line, change color etc surely you can work (If you
know the word).
No comments:
Post a Comment