Senin, 08 Agustus 2011

Tugas tutorial excel 2003


Excel 2003 Spreadsheet Tutorial - Overview

This tutorial covers the steps to creating a basic spreadsheet in Excel 2003.

Related article: Basic Excel 2007 Spreadsheet Tutorial.

Completing the steps in the topics below will produce a spreadsheet similar to the image above.

1.Tutorial Topics

2.Adding data to a spreadsheet

3.Widening Columns in Excel

4.Adding the Date and a Range Name

5.Adding formulas

6.Changing data alignment in cells

7.Number formatting - percent and currency

8.Changing cell background color

9.Changing font color

1.Entering Data into Excel 2003

Entering data into a spreadsheet is always a three step process. These steps are:

a.Click on the cell where you want the data to go.

b.Type your data into the cell.

c.Press the ENTER key on the keyboard or click on another cell with the mouse.
For this tutorial

To follow this tutorial, enter the data listed below into a blank spreadsheet using the following steps:

a.Open a blank Excel spreadsheet file.

b.Select the cell indicated by the cell reference provided.

c.Type the corresponding data into the selected cell.

d.Press the Enter key on the keyboard or click on the next cell in the list with the mouse.

2. Widening Columns in Excel 2003

After entering the data you will probably find that several words, such as Deductions, are too wide for a cell. To correct this so that the entire word is visible:

a. Place the mouse pointer on the line between columns C and D in the column header.

b. The pointer will change to a double - headed arrow.

c. Click with the left mouse button and drag the double - headed arrow to the right to widen column C.

d. Widen other columns to show data as needed.

3. Adding the Date in Excel 2003

It is normal to add the date to a spreadsheet. Built into Excel 2003 are a number of DATE functions that can be used to do this. In this tutorial we will use the TODAY function.

a. Click on cell C4.

b. Press the ENTER key on the keyboard.

c. The current date should appear in cell C4
Adding a Range Name in Excel 2003

d.Select cell C6 in the spreadsheet.

e.Click on the Name Box.

f.Type "rate" (no quotes) in the Name Box.

g.Cell C6 now has the name of "rate". We will use the name to simplify creating formulas in the next step.

4. Calculating employee deductions

a. Click on cell C9.

b. Type in the formula = B9 * rate and press the Enter key on the keyboard.
Calculating net salary

c. Click on cell D9.

d. Type in the formula = B9 - C9 and press the Enter key on the keyboard.
Additional formula information:
Excel 2003 Formulas Step by Step Tutorial
Copying the formulas in cells C9 and D9 to other cells:

a. Click on cell C9 again.

b. Move the mouse pointer over the fill handle (a small black dot) in the bottom right corner of the active cell.

c. When the pointer changes to a black "plus sign", click and hold down the left mouse button and drag the fill handle down to cell C12. The formula in C9 will be copied to cells C10 - C12.

d. Click on cell D9.

Repeat steps 2 and 3 and drag the fill handle down to cell D12. The formula in D9 will be copied to cells D10 - D12.

5. Changing Data Alignment

Note: For help on these steps, refer to the image above.

This step involves using icons located on the Formatting toolbar, which is normally located at the top of the Excel 2003 screen. If it is not present, this article, Finding Excel Toolbars can help you locate it.

a. Drag select cells A2 - D2.

b. Click on the Merge and Center icon on the Formatting Toolbar to center the title.

c. Drag select cells B4 - B6.

d. Click on the Align text right option icon on the Formatting Toolbar to right align the data in these cells.

e. Drag select cells A9 - A12.

f. Click on the Align text right icon on the Formatting Toolbar to right align the data in these cells.

g. Drag select cells A8 - D8.

h. Click on the Center icon on the Formatting Toolbar to center the data in these cells.

i. Drag select cells C4 - C6.

j. Click on the Center icon on the Formatting Toolbar to center the data in these cells.

k. Drag select cells B9 - D12.

l. Click on the Center icon on the Formatting Toolbar to center the data in these cells.

6. number formatting

Number formatting refers to the addition of currency symbols, decimal markers, percent signs, and other symbols that help to identify the type of data present in a cell and to make it easier to read.

In this step we add percent signs and currency symbols to our data.

Adding the percent symbol

a. Select cell C6.

b. Click on the Format menu to open the drop down list.

c. Click on Cells.. option to open the Format Cells dialog box.

d. Click on Percentage under the Category list.

e. Click OK.

f. The data in cell C6 should now read as 6 %.
Adding the currency symbol

g. Drag select cells B9 - D12.

h. Repeat steps 2 and 3 above.

i. Click on Currency under the Category list.

j. Click OK.

The data in cells B9 - D12 should now show the dollar symbol ( $ ) and two decimal places.

7. Changing cell background color

This step involves using icons located on the Formatting toolbar, which is normally located at the top of the Excel 2003 screen. If it is not present, this article, Finding Excel Toolbars can help you locate it.

a. Drag select cells A2 - D2 on the spreadsheet.

b. Click on the Fill Color icon on the Formatting Toolbar (looks like a paint can) to open the background color drop down list.

c. Choose Green from the list to change the background color of cells A2 - D2 to dark green.

d. Drag select cells A8 - D8 on the spreadsheet.

e. Repeat steps 2 and 3.

8. Changing font color

This step involves using icons located on the Formatting toolbar, which is normally located at the top of the Excel 2003 screen. If it is not present, this article, Finding Excel Toolbars can help you locate it.

a. Drag select cells A2 - D2 on the spreadsheet.

b. Click on the Font Color icon on the Formatting Toolbar (it is a large letter " A ") to open the font color drop down list.

c. Choose White from the list to change the color of the text in cells A2 - D2 to white.

d. Drag select cells A8 - D8 on the spreadsheet.

e. Repeat steps 2 and 3 above.

f. Drag select cells B4 - C6 on the spreadsheet.

g. Click on the Font Color icon on the Formatting Toolbar to open the font color drop down list.

h. Choose Green from the list to change the color of the text in cells B4 - C6 to dark green.

i. Drag select cells A9 - D12 on the spreadsheet.

j. Repeat steps 7 and 8 above.

At this point, if you have followed all the steps of this tutorial correctly, your spreadsheet should resemble the spreadsheet pictured in Step 1 of this tutorial.

Tidak ada komentar:

Posting Komentar