INTRODUCTION:
Excel is an
application package that is design to handle numeric data (so many data) .e.g.
Taxes, Sales, Payrolls and result etc. in the computer system, so that they
could be calculated quickly and with ease.
FEATURES OF
EXCEL:
1. Data can be arrange in rows and
columns
2. Data can be representation in a chart
form.
3. Calculations and analysis of data
using the required formulae
IMPORTANCE OF EXCEL:
1. Engineering: Excel
is required for engineering work for the purpose of calculation and structural
records:
2. Business: it
is also required for business settings
and for the arrangement of payrolls and saves
3. Scientific and statistical data analysis: excel is required for scientific
calculations and statistics
HOW CAN I OPEN EXCEL?:
opening excel is not different from opening other Microsoft packages
such as, ms-word, ms-power point etc. so the same way you open them is the same
way you can open excel. I.E ( Click on the START MENU in your system, click on ALL PROGRAMS, from the list of folders that will display, slect MICROSOFT OFFICE, and finally click on MICROSOFT OFFICE EXCEL)
CELL
ADDRESS: this is an address which identifies the location of
a particular cell in excel
THE title bar, menu bar, quick access tool bar, as
well as the office button have been explained above, so no need of talking
about them again, but there are features here that we have not come across
those are the one we will treat now: these are as follows:
·
Formula
bar:
the formula bar is blank and
horizontally placed under the quick access tool bar. It displays the contents
of an active cell. It is also used to enter formula.
·
Name
box:
the name box displays the cell address of an active cell ( A1) etc.
·
Active
cell: an active cell is a cell that is currently selected
or activated. The active cells are usually bolder than other cells.
·
Cell:
a cell is a small division of a worksheet in a rectangular form. The cell is
formed when the vertical and the horizontal lines join or intercepts.
·
Horizontal
& Vertical Scroll bar you have been notified above.
WORK
BOOK: This has to do with the entire
work done under a book name. The work book contains the whole files you have in
your document now called book here in excel.
WORK
SHEET: the worksheet the unit of a work book. E.g. (sheet
1, sheet 2) if you look down in the lower part of your screen you will see then
labeled sheet 1 (page 1) sheet2 (page 2) sheet 3 (page 3) so more sheet can be
inserted by you if needed.
FORMULA:
these are mathematical expression that are use
calculating a new value in excel using an existing value or number.
FUNCTIONS
IN EXCEL: functions are expression that performs calculation
on data that are installed in a cell or range of cells. Some functions that can
be used in excel includes:
-
TOTAL - (=SUM(b2:i2)
-
MINIMUM - (=MIN(b2:c2)
-
MAXIMUM - (=MAX(b2:c2)
-
STANDARD
DEVIATION - (=STDEV(b2:c2)
-
COUNT - (=COUNT(b2:c2)
-
LOGARITHM
- (=LOG(any figre)
-
AVERAGE - (AVERAGE(b2:b2)
-
SQUARE
ROOT - (SQRT(given figure)
-
MULTIPLICATION - (*)
-
DIVISION - (/)
-
SUBTRACTION - (-)
-
PERCENTAGE - (%)
-
EXPONENTIAL
(CARAT) - (^)
-
EQUAL
TO - (=) ETC.
