home

EXCEL 2

In order to complete this assignment you must be in Microsoft Excel--Start>>Programs>>Microsoft Excel.

Remember to include your name, class and date at the top of the assignment.

Objectives:

Students will know and be able to:
1. Format cells in Microsoft Excel.
2. Use the AutoSum function in Microsoft Excel.
3. Create and copy formulas in Microsoft Excel.
4. Understand the concept of overtime in the workplace.
5. Save as they are working, and create a back-up of their work when they are finished.

Formulas:

A cell may contain a formula which will allow you to add, subtract, divide, multiply, or perform various other operations:

Parts of an Excel Formula might include, but are not limited to:
1. An = sign. This tells excel that you want to start a formula.
2. A function name such as sum or average. (Sum +, Subtract -, Multiply *, Divide /)
3. A range of values enclosed in parenthesis: (A1:A6)
4. A combination of the above representing a formula: =sum(A1-A6)

Assignment #1

ToDo: John is one of the premier ski instructors in the United States and he decides that he would like to start his own ski instruction school: John's Ski Adventures. He hires some people to work for him and the first pay period is about to end. Help him determine the Total Pay for each employee in his business (not including taxes that would be withheld).

1. Make the John's Ski Adventures chart as seen below:

John's Ski Adventures

Payroll For February 6-13

Name Rate of Pay Regular Hours Overtime Hours Regular Pay Overtime Pay Total Pay

Boyd, Chad $ 5.00
31

0

Fleming, Regina $ 6.10
40

2

Leveille, Jamie $ 5.75
40

5

Fleming, Corey $ 5.50
38

0

Giroux, Stephanie $ 6.75
40

3

Harris, Lisa $ 7.25
40

7

Leveille, Jason $ 11.00
40

12

Total

2. Use the following shortcut to write a formula to add the totals for John's Ski Adventures assignment:

Click on the first Total in cell B12 (Total Rate of Pay).
Click the Auto Sum Button from the toolbar. See Below:

Click on the Green check Mark next to the X in the formulas tool bar. See Below:

Now the sum (total) should appear in the cell you selected .

3. Do the same for the Regular and Overtime Hours (and Regular, Overtime and Total Pay once you find the amounts).

Tip: Be sure that the AutoSum function is selecting the exact numbers you want to add.

4. To compute the totals for Chad Boyd, you must use the following formulas:

To compute the regular pay type an = sign cell E4
Click on the B4 cell (the rate of pay)
Type the Multiply symbol *
Click on the C4 cell (regular hours)
Press the Enter key - That's it.

5. See if you can write the Overtime Pay formula for Chad Boyd in Cell F4.

Overtime Hours * (Rate of Pay*1.5).

6. Compute the Total Pay for Chad Boyd in Cell G4.

Total Pay = Regular pay + Overtime pay

7. Now you can find the formulas for the remaining people on the payroll. Good Luck!

Assignment # Two

To Do: Below is a list of the number of clients each employee has instructed over the previous 5 months. Find the total number of clients each employee has trained:

Make this chart below on the bottom of Jason's Ski Adventures page.

	November	December	January	February	March	Totals
Boyd, Chad	2	6	8	6	3
Fleming, Regina	20	21	23	26	18
Leveille, Jamie	12	14	10	11	8
Fleming, Corey	3	7	9	7	4
Giroux, Stephanie	22	23	25	28	19
Harris, Lisa	25	21	20	19	18
Leveille, Jason	52	48	58	39	41

2. Find the Total number of clients for Chad Boyd.

To apply the formula to the rest of the other cells, place the cursor in the
lower right corner until it turns into a + then Click and drag to the last cell in the Column.

3. Nice job! Before you move to the Internet Assignment have Mr. Leveille check your work. When you are finished save a copy of your work to your disk, and a copy to your folder as>>Excel2(first initial)(last initial).