|
Step 4.4 - First exercises with Excel |
 |
 |
 |
|
Written by Gianni
|
|
Thursday, 12 March 2009 13:47 |
EXCEL EXERCISES
1 - Open a new Workbook.
2 - Create the following tables beginning from the cell C2.
Obviously instead of the formulas, on the column F, the results will be seen.
Tabella primi esercizi
|
A |
B |
C |
D |
E |
F |
| 1 |
|
|
|
|
|
|
| 2 |
|
|
1.exercise 1 - I use the operator of the addition |
| 4 |
|
|
|
Monday |
Tuesday |
total |
| 5 |
|
|
board |
30 |
35 |
=D5+E5 |
| 6 |
|
|
trips |
12 |
32 |
=D6+E6 |
| 7 |
|
|
various |
5 |
7 |
=D7+E7 |
| 8 |
|
|
total |
|
|
=SUM(F5:F7) |
| 9 |
|
|
|
|
|
|
| 10 |
|
|
|
|
|
|
| 11 |
|
|
exercise 2 - I use the operator of the subtraction |
| 13 |
|
|
|
price |
discount |
total |
| 14 |
|
|
pen |
2 |
0,3 |
=D14-E14 |
| 15 |
|
|
pencil |
1,5 |
0,2 |
=D15-E15 |
| 16 |
|
|
rubber |
1 |
0,1 |
=D16-E16 |
| 17 |
|
|
total |
|
|
=SUM(F14:F16) |
| 18 |
|
|
|
|
|
|
| 19 |
|
|
|
|
|
|
| 20 |
|
|
exercise 3 - I use the operator of the multiplication |
| 22 |
|
|
|
quantity |
price |
total |
| 23 |
|
|
cover |
5 |
1 |
=D23*E23 |
| 24 |
|
|
first course |
5 |
5 |
=D24*E24 |
| 25 |
|
|
second course |
3 |
7 |
=D25*E25 |
| 26 |
|
|
fruit |
3 |
3 |
=D26*E26 |
| 27 |
|
|
coffee |
2 |
1 |
=D27*E27 |
| 28 |
|
|
total |
|
|
=SUM(F23:F27) |
| 29 |
|
|
|
|
|
|
| 30 |
|
|
|
|
|
|
| 31 |
|
|
exercise 4 - I use the operator of the division |
| 33 |
|
|
|
km |
days |
Km/day |
| 34 |
|
|
January |
1350 |
31 |
=D34/E34 |
| 35 |
|
|
February |
1300 |
28 |
=D35/E35 |
| 36 |
|
|
March |
1200 |
31 |
=D36/E36 |
| 37 |
|
|
total |
3850 |
90 |
=D37/E37 |
3 - Save the excel folder, naming it First Excel Exercises.
|
|
Last Updated ( Thursday, 12 March 2009 14:58 )
|