excel in English

Microsoft Excel 1.1 Depinisi

Microsoft Excel is a program of the application sheet (spredasheet) to manage data such as numbers in the making of reports and graphs, pengelolahan data and so forth. This program is most popular, comprehensive and widely used because the program is simple to use is flexible and easily integrated into other applications denagn program. So sanagt assist in completing the work.

1.2 Editing data
1. Enter Rangakaian Data
The steps include a series of data such as numbers and text, for example, enter data rangkaina number series:
• Click cell A3.
• Type 1 Numbers
• Press the Ctrl and do not loose.
• Click in offshore and do not, then slide it down until the desired, and when you've finished a freelance Mouse and Ctrl keys.
2. Create Graphic
Once we enter the data in the spreadsheet data can be displayed in the form of graphs. Cart is a wizard to create a facility that serves as a graphic picture and description of progress or development perusahaan.Langkah making a graph:
• Type the table in accordance with what you want
• Highlight the set A4 to denagn cell B9.
• Click the insert menu, select Chart and click the menu or click on the standard toolbar.
• Click the Standard Type.
• Select a graphic that you want.
• Click next, type the number of junior high students ..., the Chart Title box.
• Ktik academic year at the bagina Category (x) axis function is to determine the title graphic on the axis X.
• Type the text on the amount of the bagina Value (Y) axit.setelah the next type.
• Click finish. And there will be a graph as you wish.

1.3 Managing LEMBAR WORK
1. Insert Column
• Select the fields that will be inserted for example, column B.
• Click the Insert menu and click on the option Column.Hasilnya akan shown in the picture below.
2. Deleting Columns
• Select the fields that will be removed, for example, column A.
• Click the Edit menu and click on the Delete option. Or right-click on Mouse and then click Delete.

3. Insert Row
• Select the line that will be inserted blank lines, for example, line 1 and 2.
• Click the Insert menu and click on the Rows option.
4. Deleting Rows
• Select the row to be removed, for example, line 3 and line 4.
• Click the Edit menu and click on the delete option or click on the Right Mouse click and detele.

1.4 Data Format
1. Prevent some text on Tues.
• Enable a report that you have created, such as training praktikum 3.
• Highlight some of the cells or blocks that will be in the format.
• Click the Format menu and click on the option Cell atatu Ctrl-1. So there will be some cell format dialog box.
• Klikj tab Aligrnment.
• In the text-Horizontal Alignment, click pikihan Center, and the Text Alignment bagin-vertical, click the option that type Center.setelah OK.
1.5 use the formula and function

1. Writing Formulas with Fixed Numbers
Matetamstika the formula is placed in the cell tertentu.Kita need to know first about the use of arithmetic operators (operatir Aritematika), which often use in other anatara:
a. Grouping ().
b. Multiplication (*).
c. Perpangkatan (^).
d. Division (/).
e. Increase (+)
f. Reduction (-).
2. Meng-Coy formula
• Activate the file that you have created as an example praktikum 3. We will calculate the amount of price in the results obtained from the multiplication between Number and Unit Price.
• Place the instructions in the cell where we want, such as E5.
• Type in the characters "=" (equal to)
• Click on cell C5.
• Type in the characters "*" (multiplication)
• Type the cell D5.
• Press the Enter key or symbol in the formula bar enter.
• Click on cell E5 that contains the formula.
• Place the mouse on the Fill Handle (lower right corner) on the cell's address.
• Click and never released, kemudain slide salmapi the desired cells, for example, cell E11.
• Then release the mouse and click any cell.

USING THE FUNCTION STATISTICS (lookup)

SUM = sum up data in the Range
Formula: EXEMPLARY = SUM (D5: D11)
Calculating Average = the average value
Formula: Sample average = (D5: D11)
MAX = largest value Menghasilakan
Formula: Example = MAX (D5: D11)
MIN = Generate smallest value
Formula: Example = MIN (D5: D11)
COUNT = Calculating the amount of data from a range
Formula: Example = COUNT (D5: D11)

USING THE FUNCTION Logic
Example: when the value of students who "Passed" or "NOT Graduate"
• Click cell H3, and isis keteranagn on the formula
• The formula is = IF (G3> 60; "Graduate," NOT Graduate ")
• Make the process use the copy with the formula.

USING THE SPECIAL FUNCTIONS (VLOOKUP AND HLOOKUP)
a. VLOOKUP function is used for reading the table arranged in vertical. Vlookup general form of the function is as follows:
Barang Code Name Price
T02 Television 21 inch 1500000
L01 Lemari Es One Door 1000000

VLOOKUP formula is
= Vlookup (B3, B8: C10, 2, False)
Then click F5 on the keyboard and the resulting formula is like this:
= Vlookup (B3, $ B $ 8: $ C $ 10.2, False)
b. Function Hlookup
Hlookup function used for reading the table is arranged horizontally. General form of the function is Hlookup

Code T02 L01
Name Barang Television 21 inch Extra Ice One Door
Price 1,500,000 1,000,000

Hlookup formula:
Hlookup = (B3, B8: D9, 2, False)
Then click F5 on the keyboard and the resulting formula is like this:
= HLOOKUP (B3, $ B $ 8: $ D $ 9.2, False)