Excel Tutorial Part 1

Directions: Answer the question for sections I-III on a separate sheet of paper and build the Excel document below.

For this portion of the class you will be learning how to use Microsoft Excel by working through the tutorial at http://www.usd.edu/trio/tut/excel/index.html

Run both the Excel program and Internet Explorer so you can toggle back and forth between the tutorial and Excel.

Stop when you get to the Sum Function page!!!!!!!!!!!!

I. Define the following terms in your own words to receive credit:

1. Spreadsheet

2. Rows

3. Cells

4. Columns

II. Short Answer

1. What can spreadsheets do differently from adding numbers on a sheet of paper?

2. What 3 types of data can be found in a cell?

3. Describe what labels do.

4. Describe what constants do.

5. Describe what formulas do.

6. What must functions begin with?

7. On the Basic Formulas in Excel page which of the two equations mentioned (= B1 * B2 or = 23 * 5.36) is the most useful?  Explain why?

Using the chart on the Basic Math Functions page answer the following questions:

8. A1*B3 =

9. A3 / B2 =

10. A1*B1 =

III. Multiple Choice

1. _________ is the vertical(goes up and down) column that letters designate

a) Row    b) Cell     c) Column    d)  Spreadsheet

2. _________ is the horizontal portion that numbers designate.

a) Row    b) Cell     c) Column    d) Spreadsheet

3. _________ is the area that is the intersection between a row and a column.

a) Row    b) Cell     c) Column    d) Spreadsheet

IV. Excel Activity

Step 1- In cell A1 type in the Label Hours, in cell A2 type in the Label Wage per hour, and in cell A4 type in the Label Total Pay.

Step 2- In cell B4 type =SUM(B1*B2) and press Enter on the keyboard

Step 3- In cell B2 type in $5.35 and in B1 type in 40.

Step 4- Write the answer that appears in B4.

Step 5- Do steps 1-3 again but this time change B2 to $6.00 and in B1 type 30.

Step 6- Write the answer.

---