CHAPTER I
INTRODUCTION
A. Background
Microsoft Excel is a softwere that has been
released by Microsoft, Microsoft exel used when you want to perform the
calculation, therefore, the author tries to discuss a little more about
Microsoft Excel 2007, Microsoft Excel 2007 is the development of Microsoft
excel 2003, Microsoft excel where between 2007 and 2003 is different, pebedaan
lies in its features, kalaw Microsoft Excel 2003 menus prepared using Microsoft
kalaw tek but the 2007 is more likely to use the icon.
Now also released Microsoft Office 2010,
Office 2010 is a combination of office 2003 and office
2007, the difference between
office 2010 with office
2007 is located on the file extension.
B. PURPOSE AND BENEFITS
1.
The
objective of this
paper is to complete the task from
one of the teachers who have
Taught KKPI productive.
2.
As the learning
materials to the author for
a better future
CHAPTER
II
DISCUSSION
A.
Know Microsoft Excel
Microsoft Excel, Excel henceforth abbreviated,
is an application program that banyakdigunakan to help calculate, projecting,
analyzing, danmempresentasikan data. Here we will be a lot of contact with
metode2 creating tables and graphs boiling data2 needed once in the preparation
of the company, results-Results of the study, as well as in the manufacture of
personal papers.
B. Working With Microsoft Excel
a) Microsoft Excel Worksheet Before starting the
discussion into Microsoft Excel, it helps us learn more
about Microsoft Excel dulubagaimana display it, along
with somecommon terms that will be
used. Some common istilah2 given in the figure
below will be widely used in
the subsequent discussion, so it would be better
if we memorize it very well.
b) Moving the Pointer Cells
(Cell Pointer) There are several ways to move
the cellpointer. For details please see
the table below.
c) Entering Data into Worksheet Different
types of data can be entered into
theworksheet as text, value, date, time, and so
forth. To enter data into a cell, it can followthe
following steps:
1. Select or click on the
cell where you want to enter data
2. Type of data to be
included
3. Press the Enter key or
the directional arrows or PgUp and PgDn keys
d) Fix typo Typing When there
is data, you can fix it by following the
steps below:
1. Select the cells whose data you want
to repair, and then press F2. Or
click the left
button maouse 2 times in cells whose data you want to
repair.
2. Further fix incorrect data and
press the Enter button when finished.
e) Using theformula you can enter
a formula in the form of mathematical instruction into
a cell on the worksheet. Arithmetic operators that can
be used include the +
(addition), -(subtraction), * (multiplication), and ^ (powers
of). To recognize how to use them, let'sfirst create
a table like the one below. To
fill the cell E5 Total Wages Received, can
be done in several ways.
a)
Writing Formulas Using Fixed Numbers
1.
Place
the cell pointer in the desired position (in this
example E5)
2.
Type the
formula "= 48 * 3500" in
the formula line and
press Enter. Note: Writing formula always begins
withlambng equal to (=).
b)
Write a formula
for the Reference Cell 1) Place thecell pointer in
the desired position (in this example E5) 2)Type in the
formula "= E3 * E4" in
the formula line and press Enter. Note: By using
this method, when the data incell E3 and (or) E4 changed,
the results in the cell E5punwill also change.
c)
Write
a formula by pointing the way to use the
keyboard or mouse:
1. Place the cell pointer in the
desired position (in this example E5)
2. Type "=" in the line
of the formula
3. Select
or click cell E3, then type "*"
4. Select the cell or click
on E4 and press Enter.
d) Make Range
/ Block cell at work when using Excel, we do
not just work in one cell. Sometimes, you will
work in a group / collection of cells. For
example, if you want to change the font type columns
and (or) line, want to changethe
formula and some columns (or rows), copy-paste ordelete multiple columns of
data and (or) line, etc.. Incondition2 like
this, you can use a range / block of
cells tofacilitate your work. Range named after
the address of the cell in the top left
corner to the bottom right corner. For example, the range of cells B2 to E7 written
the range B2: E7.
C. Range
/ cell block can be made in several ways:
1.
Creating Range Using the Shift Key
a)
Place the cell pointer early range
/ early part of the cell that you want to
block, namely B2 (see figure above).
b)
While holding down the Shift key, press the arrow
keys until the destination cell, the E7
2.
Creating Range Using Mouse **
a)
Click the cell that is the beginning
of cell range, ie B2.Pointer / mouse pointer should gentleness in
a state ofwhite plus sign (point to the cell, not
the edge of the cell).(see image above).
b)
While still holding the left mouse click, move
themouse (drag) to the destination cell, the cell E7.
3.
MakeA column or row of columns or
rows can be highlighted by clicking on the row number
or column letter you want. For example, just click
the column letter B edge to highlight the
entire column B.
4.
Highlight Rows Columns or RowsTo
highlight a series
of columns (eg B, C, D) or a series
of lines (eg 3, 4, 5) can be done by following these
steps:
a)
Click on the letters column or at
the beginning of the row number (in this example is
the B or 3)
b)
While still holding the left mouse button,
move (drag)pointer (pointer) mouse to highlight the
entire row that (inthis example is D or 5).
c)
Delete Data To erase the data in a particular cell
or range, move to the cell, or make a range where you
want to delete and press the Delete key. And if you
want to delete the data display format / cells can be done by
selecting it and clicking the Edit menu, Clear, Formats.
d)
Inserting Data Series with AutoFill Facility To enter
data such as numbers or text
with AutoFill facility, can bedone by following
the below STEP 2:
1.
Select / click on the cell where the starting
position ofthe data set you want to create. For example, select / click
on cell B2.
2.
Preliminary data type you want. For
example, the text"Jan" (January)
3.
In the next
cell (cell dibawah/B3 or disampingnya/C2)following the
data type you want. For example, in B3 type
"February" (February)
4.
Highlight / bloklah B2: B3.
5.
In a state still highlighted, position the
pointer / mousepointer to the bottom right corner
of the cell B3 to whiteplus sign turns into a
black plus.
6.
Press the left mouse button and slide /
drag the mouse pointer to the position desired
cell B12 for example. With this set of
data points can be displayed.See Figure below. i) Using AutoCalculate facilities andAutoSum
1. AutoCalculate AutoCalculate Facility (automaticcalculation) is
used to perform calculations quickly andeasily
from data2 were pretty much
in a particular range.Within the facility there
are 6 pieces AutoCalculatecommand, the command to automatically calculate rata2(Average), the
amount of data (Count), a lot of
data points(Count Nums), the value
of max (Max), the value of min(Min), and the
number of data points (sum). How to use itis as follows:
a. Highlight
the range of data to
be calculated / count. Eghighlight range C7: C12 from the
following data.
b. Click the right
mouse button on the status bar, and select the type
of calculation you want.
Suppose choose Average
(A) to calculate the average data.
c. The results will be displayed in the status
bar.
2. AutoCalculate above AutoSum function is to quickly
calculate data2 are quite a lot, but can not write automatically in your
worksheet. Special to the sum (Sum), there is another easy way to do that at
the same time can also directly write to your worksheet. The trick is to use
AutoSum toolbar button (Σ). Example, in the example above, if we want to write
the total units, place the mouse pointer to where we want (eg C13), and then
press the button on the toolbar Σ. Further highlight the range you want summed
(this example is C5: C10) and press Enter
e)
Adjust Column Widths
a.
Adjust Column Widths
Using the Mouse
1.
Move the mouse pointer on the right border of the column to be
changed to a white plus sign turns into a two-way arrows. Note: If you want to
change the width of a row of columns, the first column will be changed bloklah
width, then place the mouse pointer over the right border of a column.
2.
Click the left mouse button, and while continuing to press the
mouse drag (drag) was the mouse until the desired column width
b.
Set Column Width Based Data Longest
1.
Move the mouse pointer on the right border of the column letter
you want to change the width.
2.
Double-click on the column boundary. The width of the column
will follow the longest of data that exist in the fields as shown in
f)
Set the High Line
1.
Move the mouse pointer to the lower limit lines to be converted
to a white plus sign turns into a two-way arrows. Note: If you want to change
the row height rows, first row to be modified bloklah height, then place the
mouse pointer to one of the lower limit line.
2.
Click the left mouse button, and while continuing to press the
mouse button, drag (drag) was the mouse until the desired height of the row.
CHAPTER III
CLOSING
A.
Conclusion Microsoft Excel is
suitable Click OK tocount, as well as corporate
finance or financial ebuahorganization, provided
that the pebaca proficient inMicrosoft Excel.
B.
Because
not only the steps above there are many moresteps
in an operation to Microsoft exel
BIBLIOGRAPHY
KKPI Dikmenjur Edition III, OperateMicrosoft excel. Spread Sheet Software, InformationTechnology Development
Team DikmenjurDepdiknas, 2005 Complete Guide
to Microsoft Office 2003, AndiPublisher, Jogjakarta, 2006