Complete Excel
Section of the Interactive Training Tutorial
This is a new
application!!!
EXCEL!!!
P. E1.1 (Look
for Excel 97 in the top right hand corner)
Read the
Objectives!
PAY CLOSE
ATTENTION!!
It is a spreadsheet. Read
carefully the pages associated with the first chapter. This will give you a good basis for using a
spreadsheet and what a spreadsheet is used for.
Before you get started let me know. I want to review with you on some things.
Complete the chapter discussion.
When you finish reading and going through the Project. Come to me and discuss your questions. I will give you a Pretest that you will go
back through the chapter and work on.
The answers will be given to you to check.
When you are finished with the chapter discussion do your “Test
your knowledge”, save it as Objective 12A1.
Make sure you save this in your Excel Work folder.
Do apply your knowledge.
Save this as Objective 12A2 (do not print).
Do “Lab Test A”
Do “Lab Test B”
You will find them in the Excel Tests 1
Make sure you save each time the directions tell you to print.
This
is a link for the Dodge Example.
Do Practice Test Excel 1.
Type Questions and Answers.
Take Excel 1 Quiz
Next, do In The Lab Exercises.
Try your best to understand the goal of the Spreadsheet and how you can
use it in your life. Save them as
Objective 12A31
Objective 12A32
Objective 12A33
Read the Following Senario: Make a spreadsheet with the information
provided.
State Jul Aug Sep Oct Nov Dec
Montanna 2534.99 9283.00 1054.00 5233.02 2510.30 1432.56
1.
Develop a spreadsheet showing:
2.
Monthly totals
3.
Totals by state
4.
A graph representing percentage of sales per month
5.
A graph representing percentage of sales per state
6.
Highest monthly sales per state
7.
Highest sales per state
8.
Average sales per state
9.
Average sales per month
Do as
many “Cases and Places” p. E1.71 as you can before October 19
Test Review Pages
version 2
version
3
1.
49
2.
16
3.
26
4.
12
5.
42
6.
57
7.
23
8.
14
9.
28
10. 12
11. 8
12. 47
13. 50
14. 51
15. 13
16. 10
17. 33
18. 27
19. 20
20. 16
21. 35
22. 40
23. 11
24. 16
25. 52
26. 6
27. 14
28. 27
29. 50
30. 12
31. 23
32. 11
33. 49
34. 15
35. 52
36. 51
37. 51
38. 14
39. 13
40. 17
41. 53
42. 51
43. 39
44. 10
45. 49
46. 31
47. 42
48. 9
49. 6
50. 52
version 4
1.
50
2.
12
3.
23
4.
26
5.
51
6.
16
7.
33
8.
10
9.
27
10. 52
11. 14
12. 42
13. 57
14. 40
15. 49
16. 35
17. 13
18. 20
19. 8
20. 47
21. 16
22. 28
23. 12
24. 11
25. 16
26. 51
27. 14
28. 27
29. 6
30. 53
31. 42
32. 31
33. 6
34. 13
35. 12
36. 39
37. 9
38. 52
39. 51
40. 52
41. 17
42. 49
43. 11
44. 10
45. 23
46. 14
47. 49
48. 50
49. 51
50. 15
version 5
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
